Power BI Developer

Job summary

Develop dashboards and data models using Power BI, DAX, and Power Query, integrating and transforming data from databases, REST APIs, and other sources. Support data refreshes and workspace administration while applying data visualization practices and developing KPIs.

Job details

Pay Range: CAD 60-70/hr Required Technical Skills Strong hands-on experience with Microsoft Power BI Desktop and Power BI Service. Proficiency in Python, including Pandas, NumPy, Matplotlib, and Seaborn. Strong knowledge of SQL, including complex queries, joins, CTEs, subqueries, and stored procedures. Expertise in DAX, Power Query (M), data modeling, and dashboard development. Experience with ETL/ELT processes, data integration, and data transformation. Knowledge of relational databases such as SQL Server, Oracle, MySQL, or PostgreSQL. Experience integrating REST APIs and multiple data sources into Power BI. Understanding of data warehousing concepts, star schema, snowflake schema, and dimensional modeling. Experience with Power BI Gateway, scheduled refresh, and workspace administration. Knowledge of data visualization best practices and KPI development. Preferred Skills Experience with Azure Data Factory, Azure SQL, or Microsoft Fabric. Exposure to cloud data platforms such as Snowflake, Databricks, or AWS. Knowledge of Git, version control, and deployment pipelines. Experience in statistical analysis, forecasting, and predictive analytics using Python. Familiarity with Power Automate and advanced Excel.

What you’ll do

Develop dashboards and data models using Power BI, DAX, and Power Query, integrating and transforming data from databases, REST APIs, and other sources. Support data refreshes and workspace administration while applying data visualization practices and developing KPIs.

Requirements

The role requires hands-on experience with Power BI Desktop and Service, strong Python and SQL skills, and expertise in DAX, Power Query, data modeling, and dashboard development. Candidates should also have experience with ETL/ELT, relational databases, data warehousing, REST API integration, Power BI Gateway, scheduled refreshes, and workspace administration.

Listed skills

• Python · Preferred
• SQL · Preferred
• REST APIs · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Microsoft Power BI
• Python
• Pandas
• NumPy
• Matplotlib
• Seaborn
• SQL
• DAX
• Power Query
• Data Modeling
• ETL/ELT
• REST APIs
• Data Warehousing
• Power BI Gateway
• Azure Data Factory
• Microsoft Fabric

Job areas

• Data & Analytics
• Technology
• Software

More jobs from LanceSoft, Inc.