Lead Developer - Power BI (7-15 yrs)

Education & Experience : Bachelor of Engineering with 7+ Years of relevant experience.

Mandatory Certifications :

- PL-300: Microsoft Power BI Data Analyst is a must.

- DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI is considered an asset.

- Microsoft Certified Azure Fundamentals - AZ-900 is considered an asset.

Mandatory Technical skills :

- Proficiency with Power Query.

- Proficiency with DAX.

- Proficiency with dimensional modelling (star schema).

- Proficiency with SQL.

- Proficiency with Power BI report development.

- Proficiency with Power BI dataset/semantic model development.

Considered an asset :

- Knowledge of Power BI Row Level Security.

- Knowledge of Power BI dataflows.

- Knowledge of Power BI portal administration.

- Knowledge of Microsoft Azure.

- Knowledge of Jira Service Management

- Knowledge of Microsoft Power Platform

- Knowledge of Microsoft Fabric

- Knowledge of Agile/SCRUM.

Key Responsibilities :

- Collaborate with stakeholders to understand and meet their data analysis needs.

- Develop and maintain Power BI dashboards and reports.

- Use Power Query for data transformation and manipulation.

- Write advanced DAX formulas for complex business calculations.

- Implement dimensional modelling (star schema) for efficient data organization.

- Manage semantic models' data refreshes.

- Implement Power BI Row Level Security (RLS) to provide data access based on user roles.

- Create and manage dataflows to automate data updates.

- Write SQL queries for data extraction and analysis.

- Organize backlog in the Jira ticketing tool.

- Write comprehensive documentation.