We are looking for a Power BI Developer to join our data team and play a key role in designing, developing, and deploying impactful analytics solutions. The ideal candidate will be an expert in Power BI dashboard/report development with a strong understanding of data modeling, performance tuning, and secure data governance.
Responsibilities:
- Design and build interactive dashboards and reports using Power BI Desktop and Power BI Service.
- Write advanced DAX measures, calculated columns, and develop efficient data models.
- Develop and optimize complex SQL queries to extract and transform data.
- Use Power Query (M Language) for data shaping, transformation, and cleansing.
- Implement Import Mode, Direct Query, and Hybrid Models with performance best practices.
- Set up and manage CI/CD pipelines using Azure DevOps for Power BI report lifecycle management.
- Use Git and Power BI Deployment Pipelines to manage Dev/Test/Prod environments.
- Integrate Power BI with SQL Server, Azure SQL, and Azure Data Lake Gen2.
- Administer Power BI Service including managing workspaces, datasets, and dataflows.
- Conduct performance tuning using Performance Analyzer and Query Diagnostics.
- Implement Row-Level Security (RLS) and Object-Level Security (OLS) for data security.
- Collaborate with cross-functional teams to understand business requirements and deliver actionable insights.
Skills Required:
- Proven experience in Power BI dashboard and report development.
- Strong command of DAX and data modeling principles.
- Proficiency in SQL for querying and transforming data.
- Skilled in Power Query / M Language.
- Hands-on with Direct Query, Import Mode, and hybrid models.
- Familiarity with Azure DevOps and CI/CD pipelines for Power BI.
- Experience in version control (Git) and deployment pipelines.
- Knowledge of Azure Data Lake (Gen2) and Azure SQL integrations.
- Expertise in Power BI Service managing datasets, workspaces, and dataflows.
- Experience with Performance Analyzer, Query Diagnostics, and optimization strategies.
- Strong understanding of data security implementation (RLS/OLS).
