Expert - Data & BI Engineer (Microsoft Certification preferred)
Core
Designing and developing scalable data solutions, building ETL pipelines, and delivering business intelligence solutions to drive data-driven decision making.
Role type
Senior Data & BI Engineer
Builds
Enterprise Data Warehouse, dimensional data models, ETL/ELT pipelines, Power BI datasets, reports, and dashboards
Domain
Retail consumer intelligence, Data Engineering, Business Intelligence
Deliverable
production ML models | product features | dashboards & analysis
Required skills
SQL Server, Azure Data Factory (ADF), Power BI, DAX, Power Query, Data Warehousing, ETL/ELT, Data modeling, Query optimization
Preferred skills
Microsoft Fabric, Python, Power Automate, REST API integration
Technologies
SQL Server, Azure Data Factory, Power BI, Azure Data Lake Storage Gen2, Microsoft Fabric, Python, Power Automate
Responsibilities
Design, develop, and optimize SQL Server databases, stored procedures, views, and functions; Develop and maintain ETL/ELT pipelines using Azure Data Factory; Perform data validation, reconciliation, and quality checks; 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; Participate in code reviews, deployment activities, and DevOps processes
Seniority
Senior, hands-on IC