Senior BI Engineer / Data Architect (10-12 weeks contract)

About the Role :

We’re looking for an experienced Senior BI Engineer / Data Architect to lead and deliver an end-to-end BI project for one of our clients over a three-month period.

This role involves full ownership of the BI architecture and delivery — from designing the semantic model and building the Operational Data Store (ODS) to developing automated Power BI dashboards with Active Directory–based security.

Key Responsibilities :

Design and implement a semantic model / SQL cube for enterprise reporting.

Build an Operational Data Store (ODS) consolidating data across MS SQL and MySQL systems (TR, Toolbox, Denali, Magento).

Develop and manage ETL / ELT processes using SQL CDC and SSIS.

Implement analytical models using SSAS.

Deliver Power BI dashboards with automation and role-based access via Microsoft Active Directory.

Ensure performance, scalability, and data accuracy across the BI stack.

Required Skills & Experience :

Strong expertise in MS SQL Server and MySQL.

Hands-on experience with SQL CDC, SSIS, and SSAS.

Proven ability to design ODS and semantic layers for BI solutions.

Advanced proficiency in Power BI (data modeling, DAX, automation).

Experience integrating Active Directory for security management.

Solid understanding of data architecture, ETL / ELT workflows, and business intelligence frameworks.

Ability to independently own and deliver complex BI projects end-to-end.

Duration :

3 Months (Project-Based Engagement)

Work from home