Data Analytics & Automation Engineer

Aon Corporation; Toronto; Hybrid; CAD 90,000 - 130,000; Full time

Job summary

Aon Corporation invites a Data Analytics & Automation Engineer to join our Canada-wide team, shaping analytics, automation, and data platforms for Commercial Risk. You will deliver scalable reporting and data solutions that empower business decisions and drive efficiency.

Collaborate with analytics professionals and technology partners to design, implement, and govern Power BI, Power Apps, Power Automate, and modern data platforms such as Snowflake and Databricks, while advancing Aon's Data &

Qualifications

• 5+ years of experience in data engineering, analytics, BI, or automation roles.
• Experience developing solutions with Power BI, Power Apps, Power Automate, SQL and Python.
• Hands-on experience with Snowflake, Databricks, Azure Data Services or similar platforms.
• Ability to translate business requirements into scalable technical architectures and communicate with technical/non-technical stakeholders.
• Bachelor's degree or equivalent experience in a related field.

Responsibilities

• Own the build, development, and delivery of enterprise reporting and analytics solutions.
• Develop scalable Power BI dashboards and self-service reporting capabilities.
• Design, develop, and maintain Power Apps and Power Automate solutions.
• Maintain deployment pipelines and ALM processes across environments.
• Develop and supervise scalable data pipelines and data ingestion.

Skills

Data analytics

Data engineering

BI reporting

Automation

Education

Bachelor's degree in CS/Engineering/IT/Data Analytics

Tools

Power BI

Power Apps

Power Automate

SQL

Python

Snowflake

Databricks

Azure Data Services

Job description

Posting Description

Data Analytics & Automation Engineer

Ready to build data solutions that shape business decisions across Canada?

Passionate about using analytics, automation, and modern data platforms to tackle sophisticated business challenges?

Join Aon and play a key role in transforming how data, reporting, and automation support Commercial Risk operations. This is an exciting chance to define scalable analytics solutions, deliver business insights, and drive innovation through modern data platforms and automation technologies.

Applicants must be legally authorized to work in Canada. This role is not eligible for sponsorship, and we are unable to sponsor or take over sponsorship of an employment visa or work permit.

Aon is in the business of better decisions

At Aon, we shape decisions for the better to protect and enrich the lives of people around the world.

As an organization, we are united through trust as one inclusive team and we are passionate about helping our colleagues and clients succeed.

What the day will look like

As a Data Analytics & Automation Engineer, you will collaborate with business leaders, analytics professionals, operational collaborators, and technology teams. You will deliver scalable reporting, automation, and data solutions that support strategic decision-making. You'll play a meaningful role in developing and managing data platforms, automation technologies, and reporting capabilities that enable the business to operate more efficiently and effectively.

Key responsibilities include:

Analytics Solution Delivery

• Own the build, development, and delivery of enterprise reporting and analytics solutions.
• Interpret business requirements and develop scalable technical solutions.
• Develop and maintain Power BI dashboards and self-service reporting capabilities.
• Partner with business leaders to identify reporting opportunities and drive adoption of analytics solutions.
• Deliver insights that support data-driven decision making across multiple business functions.

Power Platform Ownership

• Design, develop, and maintain Power Apps and Power Automate solutions.
• Establish and lead application lifecycle management (ALM) processes across development, testing, and production environments.
• Maintain deployment pipelines and solution release processes.
• Support governance, security, licensing, and Power Platform guidelines.
• Fix sophisticated platform issues and collaborate with Microsoft support where required.

Data Engineering & Platform Management

• Support and enhance analytical environments within Databricks and Snowflake.
• Design and maintain automated data ingestion, transformation, and integration processes.
• Develop and supervise scalable data pipelines.
• Improve accessibility and reliability of enterprise data assets.
• Support the ongoing enhancement of Aon's Data & Analytics Service Platform (DASP).

Business Process Automation

• Find opportunities to streamline and automate manual processes.
• Develop enterprise automation solutions using Power Automate and related technologies.
• Manage workflows supporting reporting, access provisioning, operational activities, and data management processes.
• Ensure all automation solutions align with governance, audit, and security standards.

Dashboard & Reporting Administration

• Administer dashboard publishing, distribution, and access management processes.
• Support reporting platforms, microsites, and content distribution solutions.
• Ensure reporting solutions remain secure, scalable, and reliable.
• Coordinate support and ownership transitions for reporting assets.

Customer Engagement & Governance

• Partner with operational leaders, broking teams, analytics professionals, and technology customers.
• Lead discovery sessions, solution workshops, and project planning activities.
• Communicate technical concepts effectively to non-technical audiences.
• Maintain user documentation, operational procedures, and platform governance standards.
• Participate in ongoing platform support and issue resolution activities.

How this opportunity is different

This role sits within a highly transparent and evolving Data & Analytics function supporting Aon's Commercial Risk business across Canada. You'll join a collaborative team that combines business expertise, analytics, and technology to solve real-world challenges and uncover opportunities that drive growth and operational excellence.

Unlike many data-focused roles, you'll have the opportunity to influence the full lifecycle of solutions, from business discovery and customer engagement through to engineering, automation, reporting, and adoption. You'll work alongside data analysts, data scientists, operational leaders, and technology partners while helping shape the future of analytics and automation capabilities across the business.

Skills and experience that will lead to success

• 5+ years of experience in data engineering, analytics, business intelligence, or automation-focused roles.
• Experience developing solutions using Power BI, Power Apps, Power Automate, SQL, and Python.
• Hands-on experience with modern data platforms such as Snowflake, Databricks, Azure Data Services, or similar technologies.
• Solid ability to translate business requirements into adaptable technical architectures and communicate effectively with both technical and non-technical customers.
• Bachelor's degree or equivalent experience in Computer Science, Engineering, Information Technology, Data Analytics, or a related field, or equivalent practical experience.

Aon is not accepting unsolicited resumes from search firms for this position. If you are a search firm, you will not be compensated in any way for your submission of a candidate, even if Aon hires that candidate.

#LI-HYBRID

#LI-NA1