Job Description

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.

Qualifications
- 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)

Additional Information

Our Benefits
- Adaptable working environment
- Volunteer time off
- LinkedIn Learning
- Employee-Assistance-Program (EAP)

NIQ may utilize artificial intelligence (AI) tools at various stages of the recruit

📌 Expert - Data & BI Engineer (Microsoft Certification preferred) (Chennai)
🏢 Nielseniq
📍 Chennai