Power BI Engineer — AI-Driven Analytics & Dashboards

Semperis; Toronto; Hybrid; CAD 100,000 - 130,000; Full time

Job summary

Semperis is seeking a BI Engineer to join the Business Analytics team in a hybrid Toronto-based role. You will own Power BI development, build scalable dashboards, and translate business questions into analytics that drive decision-making.

You will collaborate with Data Warehouse Engineers and stakeholders, applying advanced DAX, data modeling, and AI-enabled analytics to elevate reporting and user productivity across the organization.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Statistics, Mathematics, Engineering, Analytics, or a related field.
• 5+ years of experience designing and developing business intelligence solutions.
• 4+ years of hands on Power BI experience building enterprise reporting solutions.
• Advanced expertise with DAX, Power Query, and Power BI semantic modeling.
• Strong understanding of dimensional modeling, data warehousing concepts, and analytical data structures.
• Proficiency in SQL for data analysis and troubleshooting.
• Experience testing and validating dashboards for accuracy, consistency, and performance.
• Demonstrated ability to communicate effectively with both technical and business audiences.
• Strong analytical and problem-solving skills with a focus on delivering business value.
• Experience using AI tools to improve analytics workflows.

Responsibilities

• Own the design, development, and maintenance of Power BI reporting solutions, dashboards, scorecards, and executive reporting.
• Develop highly visual, intuitive dashboards that enable self-service analytics.
• Build and maintain Power BI semantic models and datasets that support scalable reporting and analysis.
• Create and optimize complex DAX measures, calculations, KPIs, and business logic.
• Establish reporting standards, best practices, and governance processes for Power BI development.
• Monitor and optimize report performance, refresh processes, and adoption metrics.
• Partner with business stakeholders to define requirements, metrics, and reporting solutions.
• Translate business questions into actionable analytics and visualizations.
• Develop scalable measurement frameworks and reporting methodologies.
• Support data validation, testing, and quality assurance across reporting assets.
• Drive continuous improvement of BI processes, tools, and reporting standards.
• Identify opportunities to leverage AI capabilities within Power BI and analytics workflows.
• Partner with data and engineering teams to operationalize AI-driven insights within reporting experiences.
• Evaluate and implement generative AI use cases that improve business user productivity and analytics adoption.

Skills

Analytical thinking

Problem solving

Communication

DAX

SQL

Education

Bachelor's degree in Computer Science, Information Systems, Statistics, Mathematics, Engineering, Analytics

5+ years experience in BI

Tools

Power BI

Snowflake

dbt

Python

SQL

Job description

Semperis is seeking a BI Engineer to join the Business Analytics team in a hybrid Toronto-based role. You will own Power BI development, build scalable dashboards, and translate business questions into analytics that drive decision-making.

You will collaborate with Data Warehouse Engineers and stakeholders, applying advanced DAX, data modeling, and AI-enabled analytics to elevate reporting and user productivity across the organization.