Power Bi jobs in Canada

Are you a skilled Data Analyst passionate about leading the implementation and management of impactful data-driven solutions? Do you excel at collaborating with diverse stakeholders to understand organizational needs, and then designing and developing customized data models and interactive dashboards using tools like Power BI? Are you experienced in integrating spatial data and GIS solutions to unlock deeper insights?

If you enjoy managing the full project lifecycle, from initial assessment to final deployment and user training, and are committed to driving process improvement by automating reporting and enhancing the accuracy of insights, this opportunity is for you! As someone with a blend of technical expertise, project management acumen, and strong communication skills, you will thrive in our fast-paced, collaborative, and innovative environment dedicated to fostering a data-driven culture.

Your Opportunity

Dillon’s is looking for a Data Analyst to join our multidisciplinary team of professionals. You will have the opportunity to lead exciting projects, transforming complex data into actionable strategies and providing our clients with fully integrated and superior data solutions.

At Dillon, we operate as one team. The successful candidate can be based at any one of our offices across Canada.

We offer flexible work hours to help balance the competing demands of work and personal life.

Responsibilities

What Your Day Will Look Like

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.
  
  
  

Project Leadership & Solution Delivery

• 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 (e.g., 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 (e.g., 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 benefits
• Generous retirement savings plan
• Student 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 organization
• We 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.
  

About Dillon

Dillon is a proudly Canadian, employee-owned, professional consulting firm specializing in planning, engineering, environmental science, and management. We partner with clients to provide committed, collaborative, and inventive solutions to complex, multi-faceted projects. With over 20 offices and more than 1000 employees across Canada, Dillon offers a wide range of services related to building and improving facilities and infrastructure, protecting the environment, and developing communities.

Now operating for over 75 years, we continue to strive for excellence in everything we do. Dillon has been listed as one of Canada’s Best Managed Companies for the past 18 years and has the distinction of having achieved Platinum Club member status in this program.

Employment Equity, Diversity & Inclusion at Dillon

Dillon is committed to the principles of employment equity, inclusiveness, and diversity within our organization. We strive to achieve a workplace where opportunities are based on skills and abilities and that respects and values differences.

Inclusion is more than a word to us, it is the way we choose to run our business. We encourage you to contact us if you require accommodation during the interview process. We would love to hear from you!