Data Engineer

AON SINGAPORE CENTER FOR INNOVATION, STRATEGY AND MANAGEMENT PTE. LTD.; Singapore; On-site; SGD 70,000 - 100,000; Full time

Job summary

A leading consultancy firm in Singapore is seeking an experienced Data Engineer to enhance its analytics solutions. Candidates should have 3-7 years of experience in data engineering, proficiency in SQL Server, and skills in Python and Power BI. This role offers exposure to product development and ongoing learning opportunities, making it ideal for innovative professionals.

Benefits

Comprehensive benefits package

Two Global Wellbeing Days annually

Variety of working style solutions

Qualifications

• 3 - 7 years experience in a Data Engineer role as part of a team.
• Strong experience in RDBMS, particularly SQL Server.
• Good experience with Python and C#.
• Experience in Data Engineering/ETL tools such as Databricks.
• Strong problem-solving skills and good team-player attitude.

Responsibilities

• Work with product owner(s) and analysts on analytics solutions/products.
• Design, develop and maintain databases and ETL processes.
• Enhance applications through ongoing improvements.
• Take ownership of tasks and provide Level 2/3 support.
• Track and report on progress to local Lead Developer.

Skills

Data Engineering experience

RDBMS (SQL Server)

Data Modeling

Python

SQL design & tuning

Power BI

ETL tools such as Databricks

Git, Jira, Agile Scrum

Problem-solving skills

Team player

Education

BS or MS degree in Computer Science, Information Technology or equivalent

Tools

Databricks

Power BI

SQL Server

Job description

Data Engineer

About ACIA

Aon’s Centers for Innovation and Analytics in Dublin and Singapore are at the heart of delivering Aon’s Data & Analytic Services team’s mission to:

• accelerate the rate of innovation through digital solutions to help better respond to clients’ evolving needs
• provide foundational data and analytics capabilities in one place for 50,000 Aon colleagues and our global clients who use our risk and people solutions

Established in 2012, there are over 200 colleagues in Singapore’s Centre today including actuaries, software developers, data scientists, financial analysts and accountants. We are expanding rapidly and looking for dedicated individuals who can leverage emerging technologies and collaborate across Aon’s solution lines to help clients and colleagues make better, data-driven decisions today and tomorrow.

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

• Work closely with product owner(s), investment analysts and other developers on the requirements, design and delivery of analytics solutions/products for the Investment Consulting domain.
• Design, develop and maintain database, ETL, analytics and visualization component of the solutions to support scalable analytical reports.
• Adhere to development/testing standards and processes.
• Enhance applications by identifying opportunities for on-going improvements, e.g. DAX code optimization, refactoring, performance tuning and bug fixing.
• Take ownership of assigned tasks and applications and ensure effective operation of business systems through Level 2/3 support of application incidents, code/data fixes, testing & release processes.
• Track and report on progress to local Lead Developer and Product Owner(s).
• Leverage capabilities of Aon’s Data Analytics Service Platform and integrate our solutions with data engineering and data analytics tools.

How this opportunity is different

ACIA’s Wealth Solutions team is currently looking for a Data Engineer to help expand the delivery capabilities of our analytics solutions, which serves the needs of the firm’s clients and investment consultants worldwide. This role provides great exposure to the business, and the opportunity to take part in product development/implementation, training and support.

Skills and experience that will lead to success

• 3 - 7 years’ experience in a Data Engineer role as part of a team.
• BS or MS degree in Computer Science, Information Technology or equivalent.
• Strong experience in RDBMS (SQL Server).
• Good knowledge of OLAP architecture design.
• Good knowledge in Data Modeling (e.g. Star/snowflake schema, etc).
• Good experience with Python, C#.
• Good experience in SQL design & tuning, stored procedures.
• Good experience in Power BI.
• Experience in Data Engineering/ETL tools such as Databricks.
• Experience with Git, Jira, Agile Scrum is a plus.
• Strong problem-solving and analytical skills and a good team-player.

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 are committed to providing equal employment opportunities and fostering an inclusive workplace. If you require accommodations during the application or interview process, please let us know. You can request accommodations by emailing us at [e-mail] or your recruiter. We will work with you to meet your needs and ensure a fair and equitable experience.