Data Analytics & Automation Engineer

Aon; Calgary; On-site; CAD 90,000 - 120,000; Full time

Job summary

Aon is a leading risk, retirement, and health solutions firm seeking a Data Analytics & Automation Engineer. You will collaborate with business leaders and technology teams to deliver scalable reporting, automation, and data solutions that enable strategic decision-making across Canada.

You will own analytics delivery, Power Platform solutions, data engineering in Snowflake and Databricks, and deployment governance, while partnering with stakeholders to drive adoption and impact.

Qualifications

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

Responsibilities

• 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 ALM processes across development, testing, and production environments.
• Maintain deployment pipelines and solution release processes.
• Support governance, security, licensing, and 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.

Skills

Power BI

Power Apps

Power Automate

SQL

Python

Data Warehousing

Databricks

Snowflake

Azure Data Services

Education

Bachelor's degree or equivalent in Computer Science/Engineering/IT/Data Analytics

Tools

Power BI

Power Apps

Power Automate

SQL

Python

Databricks

Snowflake

Azure Data Services

Job description

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.