Microsoft BI/ Data Engineer

Responsibilities

• Develop and maintain ETL/ELT processes using SSIS, Fabric Pipelines, and/or Azure Data Factory, including advanced Script Tasks (C# or ) to automate file operations and apply custom business logic.
• Develop and implement solutions in Microsoft PowerBI and Microsoft Fabric, including Lakehouse/Warehouse modeling, Dataflows Gen2, Pipelines, and Semantic Models; support the modernization of existing ETL and reporting assets into Fabric and Azure cloud-based frameworks.
• Design, develop, and optimize complex T-SQL stored procedures, functions, and database objects for high-volume OLTP and Data Warehouse environments, with expertise in transaction isolation levels, table hints, deadlocks, linked servers, OPENQUERY, triggers, and column-level encryption.
• Perform advanced database performance tuning, including execution plan analysis, indexing strategies, partitioning, and transaction optimization.
• Contribute to the design and enhancement of OLTP and OLAP data models, ensuring alignment with business, analytical, and performance requirements.
• Build and support integrations that consume or expose REST APIs, including testing, validation, and troubleshooting using Postman and related API tools.
• Create and govern dashboards and visual analytics in Power BI or Tableau, ensuring accuracy, compliance with governance standards, and proper alignment with semantic models.
• Verify and maintain data quality and integrity across the data warehouse, semantic models, dashboards, reports, and data extracts.
• Troubleshoot and resolve database, ETL, reporting, data quality, performance, capacity, replication, and distributed data issues; participate in incident resolution and root-cause remediation.
• Maintain thorough documentation, adhere to change control processes, and support regulatory, cybersecurity, and data protection compliance.
• Collaborate with Product Managers, Analysts, Engineers, and cross-functional teams to enhance BI and data platform capabilities.

What we're seeking

• Bachelor s degree in Engineering or Computer Science
• 6 years of experience in reports and data warehouse development
• 5 years software development experience on Microsoft BI Platform including, , MS SQL Server
• 4 years of experience in DB Development (OLTP) using MS SQL
• 2 years of experience in building Data Marts using dimensional models
• 2 years of experience in building Dashboards and KPI visualization on Power BI and/or Tableau
• Strong reporting and data warehouse development skills on issues that are complex and evaluative in nature where troubleshooting may call for referencing an advanced knowledge base
• Large data migration experience
• Hands on experience using Oracle

What makes you stand out

• Maintaining code/scripts in TFS for multiple environments
• Cloud technology like Microsoft Azure, MS Power BI and Microsoft Fabric.
• DBA activities like database backup and restore.
• Data extraction using API
• Handling data in XML