Description

You will design and maintain scalable semantic models and analytical solutions to drive business insights.

Responsibilities

• Design and maintain efficient Power BI semantic models using star schema techniques for optimal performance.
• Develop and optimize complex DAX queries, including calculated columns, measures, and tables.
• Build and manage ETL pipelines and data processing workflows using Azure Databricks and Databricks Lakehouse.
• Implement modular and reusable data transformation models using DBT.
• Monitor and optimize the performance of semantic models, DAX queries, and data pipelines as data volumes scale.

Required Skills

• 8+ years of experience in data modelling and analytics engineering.
• Expertise in Power BI, specifically semantic model development and DAX implementation.
• Proficiency with Azure Databricks and Databricks Lakehouse.
• Strong SQL query skills for data manipulation and analysis.
• Experience implementing DBT for data transformation and modeling.
• Hands-on experience with ETL processes and data warehousing concepts.
• Experience implementing row-level security, incremental refreshes, and Power Query.

Preferred Skills

• Experience developing advanced analytical solutions using AI capabilities, predictive analytics, or machine learning within Power BI.
• Ability to integrate APIs to extend Power BI functionality.

Key Skills

Education

Any Graduate