Associate Director, Business Intelligence

Posting Description:
**Associate Director, Business Intelligence Development**

We’re hiring

Aon is currently recruiting an Associate Director - Business Intelligence Development to join our team in Singapore.

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

**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.
- Lead the design, development and maintenance of database, analytics and visualization component of the solutions to support scalable analytical reports.
- Lead and mentor junior members in the team
- Establish and implement best practices and processes on BI, adhere to development/testing standards and processes.
- Track and report on progress to local App Developer Lead 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 an Associate Director - Business Intelligence Development 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**
- 8-15 years’ experience in a Business Intelligence Development role as part of a team
- BS or MS degree in Computer Science, Information Technology or equivalent
- At least 2 years of experience in leading BI reporting development and familiar with relevant tools, methodologies, and processes
- Strong experience in RDBMS (SQL Server 2016+) - SQL design & tuning, stored procedures.
- Strong experience of OLAP architecture design
- Strong experience in Power BI and implementing complex DAX queries
- Strong experience in Data Modeling (e.g. Star/snowflake schema, etc)
- Experience with Object-Oriented programming, C#, Python is a big plus
- Experience in Data Engineering/ETL tools like StreamSets, Databricks, SSIS, etc is a plus
- Experience in Snowflake is a plus
- Knowledge 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 a diverse workforce. Plus, our agile, inclusive 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, but we also recognise that flexibility goes beyond just the place of work... and we are all for it. We call this Smart Working

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, diverse workplace where all colleagues feel empowered to be their authentic selves. Aon is proud to be an equal opportunity workplace.