Lead Data & BI Engineer (Azure / Microsoft BI Stack) – Short-Term Engagement

Technologies we use

About the project

Your responsibilities

• Analyze and troubleshoot the existing SQL Server → Azure Analysis Services data processing pipeline
• Identify and diagnose root causes of cube processing failures
• Resolve issues related to: incorrect join logic, duplicate records, null value handling, incorrect key relationships, inconsistencies between fact and dimension tables
• Review and redesign multidimensional models in Azure Analysis Services
• Improve fact/dimension modeling and relationships
• Refactor ETL logic responsible for feeding the analytical cube
• Ensure data integrity and consistency across dimensions, measures, and reporting layers
• Optimize cube processing and improve overall reporting performance in Power BI

Our requirements

• Minimum 6+ years of experience in Data Engineering / BI Engineering roles
• Azure Analysis Services (AAS)
• Microsoft SQL Server
• Power BI
• Multidimensional data models (OLAP cubes)
• Experience with data pipeline troubleshooting and optimization
• Strong understanding of data warehouse modeling (fact/dimension design)
• Experience diagnosing data integrity and ETL issues
• Ability to redesign and stabilize complex analytical processing pipelines
• Strong analytical and problem-solving skills in BI environments

This is how we organize our work

This is how we work