Power BI Developer
- Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Posting language
- English
- Posted
Original job description
Key Responsibilities
- Design, develop, and maintain interactive dashboards and reports using Microsoft Power BI.
- Create DAX measures, calculated columns, KPIs, and other business metrics.
- Perform data extraction, transformation, and cleansing using Power Query.
- Write, optimize, and troubleshoot SQL queries to retrieve data from various sources.
- Develop efficient data models, relationships, and star schema structures.
- Connect Power BI to multiple data sources, including SQL Server, Excel, SharePoint, and cloud-based databases.
- Publish and manage reports in Power BI Service.
- Configure scheduled data refresh, gateways, workspaces, and report access permissions.
- Implement Row-Level Security (RLS) to ensure secure data access.
- Optimize dashboard performance, data refresh processes, and report usability.
- Collaborate with business stakeholders to understand requirements and deliver actionable insights.
- Ensure data accuracy, consistency, and quality across reports and dashboards.
- Maintain technical documentation and provide ongoing support for BI solutions.
Required Skills and Qualifications
- Strong knowledge of Microsoft Power BI Desktop and Power BI Service.
- Proficiency in DAX, including measures, calculated columns, and filter context.
- Experience with Power Query and M language for data transformation.
- Strong SQL skills, including joins, aggregations, subqueries, and query optimization.
- Good understanding of data modeling, relationships, fact and dimension tables, and star schemas.
- Experience integrating data from multiple sources.
- Knowledge of dashboard design principles, data visualization, and report performance optimization.
- Experience with Power BI publishing, scheduled refresh, gateways, and Row-Level Security.
- Strong analytical, problem-solving, and communication skills.
Preferred Skills
- Knowledge of Microsoft Fabric, Azure Data Factory, or Azure SQL.
- Experience with Excel, SSAS, SSRS, or other BI tools.
- Familiarity with ETL processes, data warehousing, and data governance.
- Microsoft Certified: Power BI Data Analyst Associate (PL-300) certification is an advantage.
More about this job
Responsibilities
Design, develop, and maintain Power BI dashboards, reports, data models, and metrics, connecting to multiple data sources and using DAX, Power Query, and SQL. Publish and administer reports in Power BI Service, optimize performance and data quality, implement secure access, and collaborate with stakeholders to deliver insights and ongoing BI support.
Requirements
Requires strong knowledge of Power BI Desktop and Service, DAX, Power Query and M, SQL, data modeling, data integration, visualization, and report performance optimization. Strong analytical, problem-solving, and communication skills are required; experience with Microsoft Fabric, Azure services, other BI tools, ETL, data warehousing, or the PL-300 certification is preferred.
Skills
- Microsoft Power BI
- DAX
- Power Query
- M Language
- SQL
- Data Modeling
- Data Visualization
- Dashboard Design
- Power BI Service
- Row-Level Security
- Data Integration
- Query Optimization
- Data Quality
- Microsoft Fabric
- Azure Data Factory
- Azure SQL
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
Keywords
- Microsoft Power BI Desktop
- Power BI Service
- DAX
- Power Query
- M Language
- SQL
- Data Modeling
- Star Schema
- Fact Tables
- Dimension Tables
- Data Visualization
- Dashboard Design
- Row-Level Security
- Scheduled Data Refresh
- Power BI Gateways
- Power BI Workspaces
- SQL Server
- Excel
- SharePoint
- Microsoft Fabric
- Azure Data Factory
- Azure SQL
- SSAS
- SSRS
- ETL
- Data Warehousing
- Data Governance
- PL-300
- Data Quality
- Software Development