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)

Employment type
Full-time

Work arrangement
No