Position: Tech Lead BI Migration (Qlik to Power BI on Azure
Location Chicago, IL(2 days at client Office)
Duration 3 Months
Start Date 1st March
________________________________________
Overview
We are seeking an experienced Technical Lead to oversee the end to end migration of enterprise BI reporting solutions from Qlik (QlikView/Qlik Sense) to Power BI, leveraging the Microsoft Azure data platform. This role will drive architecture, development standards, data modeling, and team leadership to ensure a scalable, secure, and high quality BI environment.
________________________________________
Key Responsibilities
1. Migration Leadership
Lead the conversion of Qlik dashboards, data models, and scripts into Power BI datasets, semantic models, and reports.
Assess existing Qlik assets, document functional requirements, and define the migration roadmap.
Ensure functional parity or improvement when redesigning reports in Power BI.
2. Technical Architecture & Development
Design scalable BI and analytics architecture on Azure (Azure Data Lake, Azure SQL, Azure Synapse, Azure Data Factory, Azure Analysis Services/Fabric).
Build optimized Power BI semantic models, including star schema modeling, DAX measures, and performance tuning.
Oversee integration with data pipelines feeding BI datasets.
3. Governance, Security & Best Practices
Implement Power BI workspace governance, RLS/OLS security models, deployment pipelines, and DevOps ALM practices.
Establish coding standards for DAX, M queries, data modeling, and reusable components.
Ensure compliance with data privacy, security, and enterprise standards.
4. Stakeholder Engagement
Partner with business stakeholders to translate requirements into performant BI solutions.
Collaborate closely with data engineering, cloud infrastructure, and analytics teams.
Provide guidance, training, and enablement for Power BI adoption across teams.
5. Technical Leadership & Mentoring
Lead a team of BI developers and analysts delivering migration work.
Conduct code reviews, provide architectural guidance, and ensure solution quality.
Drive continuous improvement, innovation, and modernization of the BI stack.
________________________________________
Required Skills & Experience
8 12+ years of experience in Business Intelligence, Analytics, and Data Engineering.
Strong expertise in QlikView/Qlik Sense, including load scripts, data models, and dashboard design.
Advanced proficiency in Power BI DAX, Power Query, data modeling, performance optimization, deployment pipelines.
Hands on experience with Azure data services:
o Azure SQL / Synapse
o Azure Data Factory / Fabric pipelines
o Azure Data Lake (ADLS Gen2)
o Azure Analysis Services or Power BI semantic models
Strong understanding of data warehousing concepts (star schema, ETL/ELT).
Experience leading development teams in complex BI modernization or cloud migration programs.
Strong communication and stakeholder management skills.
________________________________________
Preferred Qualifications
Experience with Microsoft Fabric
Familiarity with CI/CD for Power BI using Azure DevOps or GitHub.
Knowledge of Qlik-to-Power BI automated migration tools
Azure certifications such as DP 203, PL 300, or AZ 900.