Data Analytics & Automation Engineer

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:

• 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.

• 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.

• 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).

• 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.

• 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.

• Partner with operational leaders, broking teams, analytics professionals, and technology customers.
• Lead discovery sessions, solution workshops, and project planning activities.
• Communicate…