Data Analyst

At Mott MacDonald, we trust our brilliant people to do brilliant things in engineering, management, and development services, supporting multisector project work in over 150 countries. As one of the largest employee-owned companies in the world, we pride ourselves on our ability to deliver exceptional outcomes through our network of 20,000+ talented consultants. With sustainability and innovation at the heart of all our sectors in North America, including, Buildings, Energy, Transportation, and Water.

We believe in empowering our people to excel, learn, and grow, offering diverse opportunities to contribute to career-defining work. Join us and be part of a collaborative environment where your ambitions are united with ours, and you can truly shape your story. 

If you share that vision, even if you don’t meet every requirement listed, we’d still love to hear from you. We value potential and diverse perspectives as much as experience. Let’s explore how we can support your growth and help you take the next step in your career, while contributing to an exciting new chapter for Mott MacDonald in North America.

Mott MacDonald is a dynamic and innovative engineering, management and development consultancy working with high profile clients across Canada and globally. We are wholly independent, employee-owned company delivering social, economic, and environmental value by connecting innovation to outcomes.

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:

Specific duties include:

• 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
• Summarize 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 organization 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 standardization.
• Data visualization: You can interpret requirements and present data in a clear and compelling way, using graphical representations and data visualizations.
• 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

At Mott MacDonald, our employees have a stake and a voice in our business, providing them with a direct connection to our success through our personal and group performance bonuses.

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.

Collaboration at Our Core

At Mott MacDonald, we believe great ideas happen when we're together. Our hybrid approach centers 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. 

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.