Analyste BI senior

AtkinsRéalis; Montreal (administrative region); Hybrid; CAD 90,000 - 120,000; Full time

Benefits offered by this job

Hybrid working culture

Flexible benefits

Job summary

AtkinsRéalis, a world‑class engineering services and nuclear organization in Canada, seeks a Senior BI Analyst for the Major Projects Sector. You will turn complex project data into clear insights, building dashboards and models with Power BI, SQL, and data transformations to support stakeholders across projects.

You will work across teams to design solutions, ensure data quality, and automate repetitive processes, while leveraging cloud and on‑premise data sources.

Qualifications

• Bachelor's degree in Computer Science, Engineering, Information Technology or related field.
• Practical experience developing BI, reporting or data analytics solutions.
• Experience with Power BI including data modelling, Power Query and DAX.

Responsibilities

• Work with stakeholders to understand needs and translate into BI solutions.
• Design data models, reports and dashboards from raw data.
• Develop and optimize SQL queries and data transformation processes.
• Contribute to Power BI solutions and data reliability for reporting.
• Participate in testing and deployment from development to production.
• Collaborate with developers, analysts, project managers and owners.
• Suggest improvements to dashboards, reporting methods and BI practices.
• Help automate recurring business and reporting processes where appropriate.

Skills

Power BI

SQL

Data modelling

DAX

ETL processes

Education

Bachelor's degree in CS/Engineering/IT

Tools

Power BI

Power Query

Python (advantage)

Azure SQL/Cloud data

Job description

Overview

Join the Business Systems Team and help turn complex project data into clear, useful insights. As a Senior BI Analyst, you will work with project teams, business stakeholders and technology specialists to develop and improve business intelligence solutions for the Major Projects Sector.

You do not need to have experience with every technology listed below. We are looking for someone with a solid BI foundation, strong analytical skills and an interest in learning and growing with the team.

Your role

• Work with stakeholders to understand their needs and translate them into practical BI solutions.
• Design data models, reports and dashboards that transform raw data into meaningful information.
• Develop and optimize SQL queries, data transformation processes and reporting solutions.
• Contribute to the development, enhancement and maintenance of Power BI solutions.
• Support the quality, integrity and reliability of data used for reporting and analysis.
• Participate in solution testing and deployment, from development through production.
• Collaborate with developers, business analysts, project managers and business owners.
• Recommend practical improvements to existing dashboards, reporting methods and BI practices.
• Help automate recurring business and reporting processes where appropriate.

About You

• A bachelor's degree in Computer Science, Engineering, Information Technology or a related discipline, or an equivalent combination of education and relevant experience.
• Practical experience developing business intelligence, reporting or data analytics solutions.
• Experience using Power BI, including data modelling, Power Query and DAX.
• The following experience would help you succeed in the role, but candidates with comparable or transferable experience are encouraged to apply:
  • Experience designing, developing or maintaining BI reports, data models or data warehouse solutions.
  • Experience working with data from multiple sources, such as databases, files, spreadsheets, SharePoint, enterprise applications or cloud platforms.
  • Experience supporting solutions from development through production.
• Experience with one or more of the following would be an asset; expertise across the full list is not expected:
  • Microsoft Power Automate for workflow or business-process automation.
  • REST APIs and Web services, including authentication, JSON, endpoints, pagination and error handling.
  • Python for data preparation, automation or analytics.
  • Power BI Dataflows.
  • Microsoft SQL Server.
  • Microsoft Azure services such as Azure SQL Database, Azure Data Factory, Azure Data Lake Storage or Azure Functions.
  • Microsoft Fabric or Databricks.
  • SharePoint and enterprise application integration.
  • Other cloud data and analytics platforms.
  • Data warehouse design or advanced data integration patterns.
• Working knowledge of SQL and relational databases.
• Understanding of data quality, governance, security and access-management practices.
• Familiarity with ETL or data integration processes.
• Strong analytical, problem-solving and organizational skills.
• Ability to communicate in both French and English when supporting stakeholders in both languages. The specific business need for English should be validated and stated in the posting where applicable.*
• Ability to understand business needs and translate them into clear technical or analytical solutions.
• Ability to communicate effectively and work collaboratively with technical and non-technical stakeholders.
• Ability to work independently while contributing to a team environment.
• The ability to explain technical topics clearly.
• An interest in continuous improvement and knowledge sharing.
• Curiosity and a willingness to learn new tools and business domains.
• A collaborative and client-focused approach.
• Sound judgement and attention to detail.
• A practical, solution-oriented mindset.
• This position requires knowledge of a language other than French, namely English, as it involves collaboration with members of the Canadian or global leadership team located outside Québec.

Rewards & benefits

Explore the rewards and benefits that help you thrive – at every stage of your life and your career at AtkinsRéalis in Canada.

Enjoy competitive compensation, employee recognition, and a brilliant range of flexible benefits you can tailor to your health, wellbeing, financial and lifestyle needs.

Make the most of diverse opportunities for training and professional development to grow your skills and expertise.

And take advantage of our hybrid working culture and generous time-off policies to balance a fulfilling career with your personal life.

Be rewarded. Find out more.

About AtkinsRéalis

We're AtkinsRéalis, a world-class engineering services and nuclear organization. We connect people, data and technology to transform the world's'infrastructure and energy systems. Together, with our industry partners and clients, and our global team of consultants, designers, engineers and project managers, we can change the world. We're committed to leading our clients across our various end markets to engineer a better future for our planet and its people.

Find out more.

Additional information

AtkinsRéalis cares about your privacy. AtkinsRéalis and other subsidiary or affiliated companies of AtkinsRéalis (referred to throughout as "AtkinsRéalis") are committed to protecting your privacy. Please consult our Privacy Notice on our Careers site to know more about how we collect, use, and transfer your Personal Data.

By submitting your personal information to AtkinsRéalis, you confirm that you have read and accept our Privacy Notice.