Data Analyst

About Mott MacDonald

Mott MacDonald is a global engineering, management, and development consultancy that works across more than 150 countries. As a large employee-owned organization, the company focuses on delivering strong results through a network of 20,000+ consultants. In North America, its work spans areas such as Buildings, Energy, Transportation, and Water, with sustainability and innovation at the center of its approach.

The company emphasizes learning, growth, and opportunities to contribute to meaningful work. It encourages applicants who bring potential and fresh perspectives, even if they do not meet every requirement, and values an inclusive, collaborative environment where people can develop their careers.

Role Summary

Mott MacDonald is seeking a motivated consulting Data Analyst to join its Digital Consulting team in Canada. The role is based in one of the Canadian office locations, including Vancouver, Calgary, or Toronto, and involves supporting multidisciplinary project teams working in the built environment.

The team includes BIM and GIS specialists, data professionals, software developers, and digital advisory consultants. In this position, you will contribute to data-driven project delivery by translating business needs into practical data strategies and analytical solutions.

What You Will Do

• Work with clients and project teams to understand requirements and shape suitable data solutions.
• Support delivery by gathering and transforming data through ETL workflows.
• Build business intelligence reports using Microsoft tools and applications.
• Identify opportunities to use data analysis and visualization to improve project outcomes.
• Collect, organize, move, and manage data across different systems.
• Clean, combine, abstract, and summarize datasets for analysis.
• Link multiple data sources and present findings in a clear format for different audiences.
• Help define a data strategy from business need through to implementation and delivery.
• Engage with stakeholders, gather detailed requirements, and create a workable project plan around the outputs.

Candidate Profile

The preferred candidate has 1 to 2 years of experience and a bachelor’s degree in Engineering, Science, Mathematics, Physics, or a related field. Experience using Microsoft Power Platform on data-related work is preferred.

You should bring strong communication ability, customer-facing experience, creative thinking, and the ability to manage your own time effectively while meeting team goals. The role also calls for someone who is proactive about improving systems and working methods.

Skills and Knowledge

• Analytical thinking and structured problem solving
• Clear verbal and written communication
• Data management and storage awareness
• Data modelling, cleansing, standardization, and enrichment
• Data visualization and reporting
• Logical and creative reasoning
• Strong IT and mathematical capability
• Data quality assurance, validation, and linkage
• Statistical analysis and applied methodology
• Power BI development and dashboarding
• Python or similar scripting ability

Compensation and Benefits

The expected annual salary range for this role is $63,500 to $77,500. Final pay will depend on qualifications, overall experience, and the responsibilities of the position.

Employees participate in the company’s success through personal and group performance bonuses, reflecting the organization’s employee-owned model.

Work Arrangement

This is a permanent full-time position. The role follows a hybrid working pattern with an in-office culture and typically requires a minimum of three days per week in the office, while still allowing flexibility to balance client, team, and personal commitments.

Equal Opportunity and Accommodation

Mott MacDonald is committed to fair employment practices, equal opportunity, and an inclusive workplace where people are encouraged to contribute and express themselves. Accommodation is available for applicants with disabilities in line with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act, 2005 (AODA), and candidates may request support during the hiring process.

Additional Details

This is an existing vacancy. The posting applies to locations in Calgary, Toronto, and Vancouver. The contract type is permanent, the work pattern is full time, and the role is listed under the market area of Various. The discipline is Other. Job reference: 14889. Recruiter contact: Faiqa Shahid.