Expert - Data & BI Engineer (Microsoft Certification preferred)

Job Summary We are seeking an experienced Data & BI Engineer (7-9 years) with strong expertise in SQL Server, Azure Data Factory (ADF), and Power BI . The role involves designing and developing scalable data solutions, building ETL pipelines, writing complex sql queries, optimizing databases, and delivering business intelligence solutions that drive data-driven decision making. Key Responsibilities Design, develop, and optimize SQL Server databases, stored procedures, views, functions, and ETL processes. Develop and maintain ETL/ELT pipelines using Azure Data Factory (ADF) . Perform data validation, reconciliation, and quality checks to ensure data accuracy. Optimize query performance, indexing, partitioning, and data processing workloads. Build and support enterprise Data Warehouse and dimensional data models. Develop Power BI datasets, reports, dashboards, and KPIs using DAX and Power Query. Monitor and troubleshoot ADF pipelines, SQL jobs, and Power BI refreshes. Collaborate with business stakeholders to understand reporting and analytics requirements. Participate in code reviews, deployment activities, and DevOps processes. 7-9 years of experience across Data Engineering, Data Warehousing, and Business Intelligence. Strong hands-on experience with: SQL Server Azure Data Factory (ADF) Power BI Azure Data Lake Storage Gen2 Preferred Hands-on Skills Microsoft Fabric Python for data processing and automation Power Automate integration REST API integration Preferred Certifications Microsoft Certified: Power BI Data Analyst Associate (PL-300) Microsoft Certified: Azure Data Engineer Associate (DP-203) Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)