Analyste BI senior

Snc-Lavalin; Montreal (administrative region); Hybrid; CAD 80,000 - 110,000; Full time

Benefits offered by this job

Hybrid working culture

Generous time-off policies

Flexible benefits

Job summary

AtkinsRéalis is seeking a Senior BI Analyst to turn complex project data into clear insights. You’ll design data models, dashboards and reports, and optimize SQL queries across the Major Projects Sector. Collaboration with stakeholders and tech teams is key to delivering reliable BI solutions.

Strong BI foundation and the ability to learn new tools, with a mix of English/French communication as needed, are valued. Hybrid work culture and professional development opportunities are offered.

Qualifications

• Bachelor's degree in Computer Science, Engineering, IT or related field or equivalent experience.
• Practical experience developing BI, reporting or data analytics solutions.
• Experience with data from multiple sources and data governance basics.
• Familiarity with Power BI, Power Query and DAX.

Responsibilities

• Understand stakeholder needs and translate them into BI solutions.
• Design data models, reports and dashboards from raw data.
• Develop and optimize SQL queries and data transformations.
• Contribute to Power BI solutions development, maintenance and deployment.
• Support data quality, integrity and reporting reliability; test and deploy.

Skills

Power BI

SQL

Data modelling

DAX

Problem solving

Communication

Education

Bachelor's degree in Computer Science, Engineering, IT or related

Tools

Power BI Dataflows

Azure Data Factory

Job description

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 judgment 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 the 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.

Worker Type Employee Job Type Regular

At AtkinsRéalis, we seek to hire individuals with diverse characteristics, backgrounds and perspectives. We strongly believe that world-class talent makes no distinctions based on gender, ethnic or national origin, sexual identity and orientation, age, religion or disability, but enriches itself through these differences. Created by the integration of long-standing organizations dating back to 1911, AtkinsRéalis is a world-class engineering services and nuclear company dedicated to engineering a better future for our planet and its people. We create sustainable solutions that connect people, data and technology to transform the world's infrastructure and energy systems. We deploy global capabilities locally to our clients and deliver unique end-to-end services across the whole life cycle of an asset including consulting, advisory & environmental services, intelligent networks & cybersecurity, design & engineering, procurement, project & construction management, operations & maintenance, decommissioning and capital. The breadth and depth of our capabilities are delivered to clients in strategic sectors such as Engineering Services, Nuclear and Capital.

News and information are available at Atkinsrealis or follow us on LinkedIn.