Design, build, and maintain Power BI dashboards, data models, and ETL processes using DAX, Power Query, SQL, and Azure. Partner with stakeholders and engineers to gather requirements, ensure data quality, optimize performance, implement governance/security, surface insights, and provide training and executive presentations.
This is a remote position.
Job Description:
The Business Intelligence Analyst will be responsible for designing, developing, and maintaining advanced business intelligence solutions to support data-driven decision-making, operational monitoring, compliance reporting, and performance measurement. The role involves creating complex Power BI dashboards, scorecards, visualizations, and data models using DAX, Power Query, SQL, and Azure-based data platforms. The analyst will work closely with business stakeholders, data architects, and data engineers to gather reporting requirements, develop ETL processes, manage data pipelines, and ensure data quality and consistency. Responsibilities also include analyzing large and complex datasets, identifying trends and insights, implementing security and governance controls, optimizing report performance, delivering executive-level presentations, providing user training and support, and leveraging AI-assisted analytics capabilities to enhance data exploration and business intelligence outcomes. The position requires strong analytical, problem-solving, communication, and stakeholder management skills to translate business needs into effective reporting and analytics solutions.
The Business Intelligence Analyst will be responsible for designing, developing, and maintaining advanced business intelligence solutions to support data-driven decision-making, operational monitoring, compliance reporting, and performance measurement. The role involves creating complex Power BI dashboards, scorecards, visualizations, and data models using DAX, Power Query, SQL, and Azure-based data platforms. The analyst will work closely with business stakeholders, data architects, and data engineers to gather reporting requirements, develop ETL processes, manage data pipelines, and ensure data quality and consistency. Responsibilities also include analyzing large and complex datasets, identifying trends and insights, implementing security and governance controls, optimizing report performance, delivering executive-level presentations, providing user training and support, and leveraging AI-assisted analytics capabilities to enhance data exploration and business intelligence outcomes. The position requires strong analytical, problem-solving, communication, and stakeholder management skills to translate business needs into effective reporting and analytics solutions.
Requirements
- 5+ years of Power BI dashboard design, development, and optimization
- 5+ years of translating business requirements into analytical solutions
- 5+ years of SQL development, querying, and data transformation
- 5+ years of analyzing large and complex datasets
- 5+ years of developing complex measures, calculated columns, DAX, and Power Query
- 4+ years of Power BI solution design and architecture
- 4+ years of advanced data visualization and reporting techniques
- 4+ years of Power BI Service implementation (data refresh, security, deployment)
- 4+ years of presenting insights and data storytelling
- Post-secondary degree/diploma/certificate in Computer Science or related field
What you need to know about the Ottawa Tech Scene
The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.
