Data Analyst

We are looking for a highly motivated consulting Data Analyst to join our Digital Consulting team in one of our Canadian office locations (Vancouver, BC / Calgary, AB / Toronto, ON). We are an agile and responsive team of BIM and GIS specialists, data professionals, software developers and digital advisory management consultants focused on the built environment. Shaping and Executing You will help shape solutions according to client needs and manage their successful delivery.

You will not be working alone but supported by the wider business for access to our deep domain knowledge and diverse digital capability. The day‑to‑day activities in the role will range from gathering data through ETL processes to building BI reports using Microsoft applications. We are looking for candidates who are keen to share their experience to date in the application of data analytics, modelling and business intelligence related data design.

You will be embedded within interdisciplinary teams on infrastructure and built environment projects, working with consultants, engineers, planners and project managers. You will be an advocate for data science and data analytics on your projects, identifying opportunities for data‑driven approaches to improve project delivery and outcomes. You will be conceptualizing from a high‑level business need and then executing a data strategy to fulfil that need.

You will be responsible for collecting requirements from relevant stakeholders and building a project plan around the deliverables. Responsibilities Identify opportunities for data analysis and data visualization Interact with stakeholders and develop requirements Apply tools and techniques for data analysis and data visualization Identify, collect and migrate data to and from a range of systems Manage, clean, abstract and aggregate data alongside a range of analytical studies on that data Manipulate and link different data sets Summarise and present data and conclusions in the most appropriate format for users Candidate Specification We are seeking a dynamic and talented person with 1‑2 years’ experience and a bachelors degree in the fields of Engineering, Science, Mathematics, Physics or related degree. Our preferred candidate will have working knowledge in data projects using Microsoft’s Power Platform.

You must be a good communicator with customer engagement experience. You must also think creatively and should always be seeking new and more efficient ways to improve systems. You must be able to manage your own time to achieve goals set with the project team.

Skills and Qualities Analytical and problem‑solving skills: You can apply analytical techniques to present a solution. Communication skills: You have strong verbal and written communication skills and understand how to share insights with technical and non‑technical stakeholders. Data management: You understand data sources, data organisation and storage.

Data modelling, data cleansing, and data enrichment skills: You understand conceptual, logical and physical data modelling and can develop knowledge of data cleansing and standardisation. Data visualisation: You can interpret requirements and present data in a clear and compelling way, using graphical representations and data visualisations. Logical and creative thinking skills: You can approach a problem, applying logic and creativity.

Proven IT and mathematical skills: You have proven IT and mathematical skills, demonstrated through relevant qualifications or work experience. Quality assurance, validation and data linkage abilities: You know how to conduct data quality assurance, validation and linkage. Statistical methods and data analysis skills: You know about statistical methodologies and data analysis techniques.

Power BI development and data analysis skills are required to manage datasets and dynamic reports. Working knowledge of Python or other scription capabilities Collaboration at Our Core At Mott MacDonald, we believe great ideas happen when we’re together. Our hybrid approach centres on an in‑office culture, with most of your time spent collaborating face‑to‑face and a minimum of three days per week in the office.

We balance flexibility with connection, so you and your manager can choose how to meet client, team and personal commitments. We seek to promote fair employment procedures and practices to ensure equal opportunities for all. We encourage individual expression in our workplace and are committed to creating an inclusive environment where everyone feels they have the opportunity to contribute.

Equal Opportunity Employer We are an equal opportunity employer and are committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act, 2005 (AODA). Mott MacDonald Canada Limited will provide accommodations to job applicants with disabilities throughout the recruitment process. If you require an accommodation, please notify us and we will work with you to meet your needs.

Multiple factors such as qualifications, overall experience and position responsibilities will be used to determine the successful candidate’s actual salary within the expected range. The expected salary range for this position is from $63,500 – $77,500. This posting is for an existing vacancy. #J-18808-Ljbffr