Senior Data Engineer

Senior Data Engineer

Bangalore/Gurgaon, India

AXA XL recognizes data and information as critical business assets, both in terms of managing risk and enabling new business opportunities. This data should not only be high quality, but also actionable – enabling AXA XL’s executive leadership team to maximize benefits and facilitate sustained dynamic advantage. Our Chief Data Office also known as our Data Intelligence & Analytics team (DIA) is focused on driving innovation through optimizing how we leverage data to drive strategy and create a new business model – disrupting the insurance market. As we develop an enterprise-wide data and digital strategy that moves us toward greater focus on the use of data and data-driven insights, we are seeking an Assistant or Associate Scientist for our Semantic & Data Modeling Design team. The role will support the team’s efforts in creating a holistic view of data across the firm while leading the development of virtual data models. This role requires a person who is a team player and can work well with team members from other disciplines to deliver data-driven solutions together.

DISCOVER your opportunity

What will your essential responsibilities include?

· Internalize and execute DIA and company-wide goals to become a data-driven organization.

· Understand our existing data and architecture deeply (granular level).

· Apply best practices in Data Virtualization to develop and grow our enterprise semantic layer.

· Through highly performant Data design decisions, drive seamless data access across the various lines of business for technical and business consumption.

· Design Business Object, Logical, Physical and Semantic Models at the enterprise and/or individual line of business and/or product level.

· Design prototypes and work in a fast-paced iterative solution delivery model.

· Actively collaborate with various teams across AXA XL in our effort to transform into a data-driven organization.

· Learn and deliver on third-party applications (e.g., PowerBI, MicroStrategy, SAP PowerDesigner).

· Contribute to the development of the Data Modeling team’s tools, skills, culture, and impact.

· Collaborate with globally distributed team members.

You will report to the Data Modeling Division Lead.

SHARE your talent

We’re looking for someone who has these abilities and skills:

Required Skills and Abilities:

· Bachelor’s degree in computer science, Mathematics, Statistics, Finance, related technical field, or equivalent work experience.

· Relevant years of extensive work experience in various data modelling techniques (relational, data warehouse, semi- structured, etc.), application development, and advanced data querying skills.

· Relevant years of hands-on experience with Database objects like tables, views, indexes, partitions, CTEs, statistics, etc. and data warehousing concepts.

· Relevant years of hands-on experience with any one or more Databases or data warehouses like SQL Server, Oracle, Teradata, Hadoop, Snowflake, Azure Synapse, ADLS, AWS Redshift, etc.

· Relevant years of programming experience in SQL and should have experience with writing SQL Joins, SET operations, Filters, aggregate functions, window functions, etc.

· Relevant years of programming experience in any of the coding languages, preferably Python, Scala, Java, etc.

· Effective familiarity with Software Development Life Cycle (SDLC) processes and workflow.

· Effective familiarity with any one of the Cloud platforms like Azure, AWS or Google Cloud and its ecosystem (Azure – Preferred).

· Solid experience with writing, optimizing, and data pipelines.

Desired Skills and Abilities:

· Relevant years of hands-on experience with ETL / ELT concepts (like Slowly Changing Dimensions and its types, etc.), and processes.

· Relevant years of hands-on experience with any one or more ETL tools like Azure Data Factory, AWS Glue, Microsoft SQL Server Integration Services (SSIS), Informatica PowerCenter, etc.

· Relevant years of hands-on experience with code versioning tools like Git, GitHub, etc. and build management.

· Distinctive problem-solving and analytical skills combined with outstanding business acumen.

· Understanding of Microservice Architecture, System Integration, and Agile development methodology.

· Solid experience writing, optimizing / performance tuning, and analyzing SQL, with outstanding capability to interpret complex data requirements and build solutions.

· Experience with Databricks, and PySpark is a plus.

· Experience with Microsoft Azure Synapse, and Azure Data Lake Storage is a plus.

· Experience with Power BI is a plus.

· Existing knowledge of Large Commercial Insurance businesses is a plus.

· Passion for data and experience working within a data-driven organization.

· You care about what you do, and what we do.

FIND your future

AXA XL, the P&C and speciality risk division of AXA, is known for solving complex risks. For mid-sized companies, multinationals and even some inspirational individuals we don’t just provide re/insurance, we reinvent it.

How? By combining a comprehensive and efficient capital platform, data-driven insights, leading technology, and the best talent in an agile and inclusive workspace, we are empowered to deliver top client service across all our lines of business − property, casualty, professional, financial lines and speciality.

With an innovative and flexible approach to risk solutions, we partner with those who move the world forward.

Learn more at axaxl.com

Inclusion & Diversity

AXA XL is committed to equal employment opportunity and will consider applicants regardless of gender, sexual orientation, age, ethnicity and origins, marital status, religion, disability, or any other protected characteristic.

At AXA XL, we know that an inclusive culture and a diverse workforce enable business growth and are critical to our success. That’s why we have made a strategic commitment to attract, develop, advance and retain the most diverse workforce possible, and create an inclusive culture where everyone can bring their full selves to work and reach their highest potential. It’s about helping one another — and our business — to move forward and succeed.

Five Business Resource Groups focused on gender, LGBTQ+, ethnicity and origins, disability and inclusion with 20 Chapters around the globe

Robust support for Flexible Working Arrangements

Enhanced family-friendly leave benefits

Named to the Diversity Best Practices Index

Signatory to the UK Women in Finance Charter

Learn more at axaxl.com/about-us/inclusion-and-diversity. AXA XL is an Equal Opportunity Employer.

Sustainability

At AXA XL, Sustainability is integral to our business strategy. In an ever-changing world, AXA XL protects what matters most for our clients and communities. We know that sustainability is at the root of a more resilient future. Our 2023-26 Sustainability strategy, called “Roots of resilience”, focuses on protecting natural ecosystems, addressing climate change, and embedding sustainable practices across our operations.

Our Pillars:

Valuing nature: How we impact nature affects how nature impacts us. Resilient ecosystems - the foundation of a sustainable planet and society – are essential to our future. We’re committed to protecting and restoring nature – from mangrove forests to the bees in our backyard – by increasing biodiversity awareness and inspiring clients and colleagues to put nature at the heart of their plans.

Addressing climate change: The effects of a changing climate are far-reaching and significant. Unpredictable weather, increasing temperatures, and rising sea levels cause both social inequalities and environmental disruption. We're building a net zero strategy, developing insurance products and services, and mobilising to advance thought leadership and investment in societal-led solutions.

Integrating ESG: All companies have a role to play in building a more resilient future. Incorporating ESG considerations into our internal processes and practices builds resilience from the roots of our business. We’re training our colleagues, engaging our external partners, and evolving our sustainability governance and reporting.

AXA Hearts in Action: We have established volunteering and charitable giving programs to help colleagues support causes that matter most to them, known as AXA XL’s “Hearts in Action” programs. These include our Matching Gifts program, Volunteering Leave, and our annual volunteering day – the Global Day of Giving.

For more information, please see axaxl.com/sustainability.

Schedule: Full-time