Data Engineer

Aon Corporation; Town of Poland (NY); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Comprehensive benefits package

Global Wellbeing Days

Job summary

A leading global risk management firm is seeking a Data Engineer to design and develop scalable data workload architectures. The successful candidate will work in a cross-functional Agile team and focus on data integration, quality management, and ensuring efficient data processes. Strong programming skills in Python, expertise in ETL tools, and a solid understanding of SQL are required. The role offers a hybrid work environment and a comprehensive benefits package.

Qualifications

• In-depth knowledge in programming languages such as Python, including Spark/Scala.
• Experience with ETL tools and lakehouse architectures (3+ years).
• Familiarity with relational and non-relational databases such as Oracle and MSSQLServer.

Responsibilities

• Work within a cross-functional Agile team to deliver on release goals.
• Design scalable and efficient data workload architectures.
• Develop, test and maintain data pipelines for integrating diverse data sources.

Skills

Python

SQL

Data pipeline development

Agile methodologies

ETL tools experience

Problem-solving

Communication skills

Education

College degree in STEM-related discipline

Tools

Databricks

Apache SparkSql

Azure DevOps

GitLab

Job description

Data Engineer

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, diverse team, and we are passionate about helping our colleagues and clients succeed. Specifically within Commercial Risk Solutions we offer risk advisory, risk transfer and structured solutions that help organisations and individuals identify, quantify and manage their risk exposure through insurance.

What the day will look like

This role will provide the candidate an opportunity to deliver enterprise-scale data workloads following a data lakehouse architecture on a modern cloud-based data stack for our new Commercial Risk Solutions Ecosystem. These data workloads represent strategic feeds to support our BI/Analytics solutions that are essential to the value proposition of our ecosystem.

Responsibilities of this role include:

• Cross-functional Team: Work within a cross-functional Agile team alongside Product Owner, Data Architect and Data Analysts to deliver on release goals for a global program
• Data Workload Design: Design scalable and efficient data workloads architectures that integrate our transactional systems with a new lakehouse data model.
• Data Integration: Develop, test and maintain data pipelines (ETL) for integrating diverse data sources into a unified format embedding best practices and standards.
• Data Management: Manage and optimize data to ensure efficient data storage, retrieval, and processing.
• Data Quality Management: Implement automated data quality checks and ensure data integrity throughout the migration process.
• Documentation: Create and maintain comprehensive documentation for data processes, ensuring knowledge transfer, observability and supportability.
• Performance Monitoring: Monitor and optimize data performance to meet defined service-level agreements.
• Troubleshooting: Identify and resolve data-related issues in a timely manner, collaborating with relevant teams.

How this opportunity is different

Aon has transitioned to a product-oriented model and is investing in capabilities like never before. This role will give the chosen candidate a unique opportunity to shape the product and data delivery model for our Commercial Risk Ecosystem to drive significant revenue and efficiency opportunities across all countries where Aon operates.

Skills and experience that will lead to success

• Advanced Technical Skills:
  • In-depth knowledge in programming languages such as Python incl. Spark/Scala.
  • Experience with ETL tools and lakehouse architectures (3+years) through Databricks, Apache SparkSql and similar
  • Strong SQL skills for data manipulation and querying Pipeline efficiency optimization skills
• Hands on experience with Agile technical practices, source versioning and Agile project management tools (Azure Repos, GitLab, Azure DevOps, Jira, Confluence, other)
• Database Knowledge: Familiarity with relational and non-relational databases (Oracle, MSSQLServer).
• Agile planning skills – Kanban and Scrum release/sprint planning.
• Problem-Solving: Proven ability to solve complex data engineering challenges and optimize system performance.
• Good communication and interpersonal skills to collaborate effectively with team members and stakeholders
• College degree in STEM-related discipline.

How we support our colleagues

In addition to our comprehensive benefits package, we encourage an inclusive workforce. Plus, our agile environment allows you to manage your wellbeing and work/life balance, ensuring you can be your best self at Aon. Furthermore, all colleagues enjoy two “Global Wellbeing Days” each year, encouraging you to take time to focus on yourself. We offer a variety of working style solutions for our colleagues as well.

Our continuous learning culture inspires and equips you to learn, share and grow, helping you achieve your fullest potential. As a result, at Aon, you are more connected, more relevant, and more valued.

Aon values an innovative and inclusive workplace where all colleagues feel empowered to be their authentic selves. Aon is proud to be an equal opportunity workplace.

Aon provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, veteran, marital, domestic partner status, or other legally protected status.

We welcome applications from all and provide individuals with disabilities with reasonable adjustments to participate in the job application, interview process and to perform essential job functions once onboard. If you would like to learn more about the reasonable accommodations we provide, email [e-mail]

Please attach CV in English only.

#LI-HYBRID