Data Analyst

Dillon Consulting; Hamilton; Hybrid; CAD 72,000 - 96,000; Full time

Job summary

Dillon Consulting seeks a data analyst with extensive experience in project management and data visualization. The successful candidate will collaborate with diverse stakeholders to deliver data-driven solutions and enhance organizational insights through comprehensive data models and dashboards. Join us to contribute to impactful projects within a supportive and innovative environment.

Benefits

Employee share purchase plan

Competitive compensation package

Flexible work hours and hybrid working options

Learning and Development opportunities

Goodlife Fitness Corporate Membership

Wellness Subsidy

Qualifications

• 5-7+ years of professional experience in a data analyst role.
• Experience with project management involving complex reporting requirements.
• Relevant certifications in Power BI or project management are desirable.

Responsibilities

• Collaborate with stakeholders to assess needs and define project scope.
• Lead the implementation of data-driven solutions overseeing the project lifecycle.
• Facilitate workshops to promote knowledge transfer and ensure solutions meet requirements.

Skills

Data Analysis

Project Management

Communication

Problem Solving

Data Visualization

SQL

Education

Degree in Data Science, Computer Science, or related field

Tools

Power BI

Tableau

ArcGIS

QGIS

Job description

Client Enablement & Stakeholder Collaboration

• Collaborate closely with a wide range of stakeholders, including senior leadership, IT departments, data scientists, and client teams, to assess organizational needs and define project scope.
• Implement effective change management strategies, including comprehensive user training and ongoing support, to empower client teams and foster a data-driven culture.
• Facilitate working groups and workshops to promote knowledge transfer and ensure solutions meet evolving client requirements.
• Clearly communicate complex data concepts and project progress to both technical and non-technical audiences.
• Lead the implementation and management of data-driven solutions for clients, overseeing the full project lifecycle from initial assessment and requirements gathering to deployment, user training, and ongoing support.
• Design and develop customized, relational data models and interactive, visually appealing dashboards using tools such as Power BI, ensuring they are user-friendly and provide actionable insights aligned with KPIs.
• Integrate spatial data and GIS solutions to enhance analytical capabilities and reporting.
• Ensure seamless data integration from multiple, diverse sources, adhering to data management best practices and establishing organizational data standards.
• Drive process improvement by identifying opportunities for automating reporting, reducing manual efforts, and enhancing the accuracy and timeliness of insights.
• Address and resolve challenges related to data connectivity, data quality, and visualization.

Learning and Development

• Commit to self-development and ongoing learning and professional development
• Contribute to Dillon’s corporate profile through active participation in professional associations and committees

Qualifications

What You Will Need To Succeed

• A degree in Data Science, Computer Science, Information Management, Statistics, Mathematics, Engineering, Business Analytics, or a related field.
• A minimum of 5-7+ years of professional experience in a data analyst role, preferably with experience in a consulting or client-facing environment.
• Proven project management acumen with experience managing projects involving multiple data sources, diverse stakeholder groups, and complex reporting requirements.
• Relevant certifications in Power BI, other BI tools, data analytics, or project management (., PMP) are highly desirable.

Experience

• Proven experience in designing, developing, and implementing customized relational data models and interactive dashboards using Power BI (or similar BI tools like Tableau, Qlik).
• Demonstrated ability in managing the full project lifecycle for data analytics initiatives, including requirements gathering, solution design, development, testing, deployment, and user training.
• Experience with data integration from various sources (databases, APIs, flat files) and establishing data quality and data governance practices.
• Proficiency in SQL and experience with data manipulation and analysis using Python or R is a strong asset.
• Experience with integrating and visualizing spatial data using GIS tools (., ArcGIS, QGIS) and techniques.
• Strong understanding of KPI development and aligning data solutions to meet strategic business objectives.
• Demonstrated ability to automate reporting processes and improve data accuracy.
• Exceptional analytical, problem-solving, and critical-thinking skills.
• Excellent verbal and written communication skills, with the ability to present complex information clearly and persuasively to diverse audiences.
• Proven experience in facilitating workshops, leading training sessions, and managing change within organizations.

Why Choose Dillon

Dillon is powered by people who are technically proficient, passionate about socially important projects, and motivated to deliver superior, tangible results. We strive to remain at the forefront of technology and innovation, and are empowered to continually grow and develop.

We live our core values :

• Reliability : words result in actions that build trust;
• Achievement : do the work to hit the target;
• Continuous development : always learning; always adapting; always growing;
• Creativity : discover new possibilities;
• Courage : do the things that matter, especially when it’s hard;
• Inclusiveness : enabling belonging to draw strength from our differences.

Dillon is a certified Great Place to Work . This recognition underscores our commitment to fostering an outstanding employee experience and cultivating an exceptional workplace culture. At Dillon, we believe that our people are our greatest asset. This designation reflects our ongoing efforts to ensure that our workplace is not just a place of work, but a community where everyone can thrive.

In addition, we offer :

• Employee share purchase plan Dillon is 100% employee owned and share ownership is open to all employees.
• A competitive compensation package Comprehensive health benefitsGenerous retirement savings planStudent loan repayment assistance with matching employer contributions
• Flexible work hours and hybrid working options Dillon values its staff and the contributions that are made each day and understands that work arrangements can differ based on personal needs and business needs. We are taking a trust-based approach to offer a variety of flexible and hybrid work options to help balance the competing demands of work and personal life.
• Learning and Development opportunities As a knowledge-based business, the organic growth of our knowledge and skills occur through our work performance and roles. The creation and sharing of knowledge allows us to take local knowledge to scale, capture lessons learned through experience, and continuously improve service delivery. The development of self and others is an evident and measured core behaviour within our organizationWe use a composite approach to development including coaching to build the how, mentoring to share lessons, advising to round out perspectives, and co-creation of knowledge through internal learning opportunities.
• Focus on Innovation The ability to anticipate, examine, and adopt new and innovative solutions is a crucial driver for the continual and progressive advancement of our business performance. In our culture, people are empowered to reflect and question current practices and seek forward looking solutions to today’s problems and tomorrow’s opportunities.
• Employee and Family Assistance program A variety of EFAP tools and online resources to support well-being are available to all employees.
• Goodlife Fitness Corporate Membership Our employees can take advantage of reduced annual membership fees.
• Wellness Subsidy Our employees can take advantage of a wellness subsidy that can be put towards expenses for a variety of health and / or wellness related activities such as gym membership, purchase of home fitness equipment, yoga classes and dance classes.