Engineer-Data Warehousing

Location

Gurgaon | India

Job description

AXA XL recognizes digital, data, and information assets are critical for the business, both in terms of managing risk and enabling new business opportunities. Data Science and Applied AI assets should not only be high quality but also drive a sustained dynamic advantage deliver an excellent experience to our internal, and external customers, and improve efficiency. Our Innovation, Data & Analytics (IDA) function is focused on driving innovation by optimizing how we leverage digital, data, and AI to drive strategy and differentiate ourselves from the competition.

As we develop an enterprise-wide data and digital strategy that moves us toward a greater focus on the use of data and strengthen our digital, AI capabilities, we are seeking a Scientist for Data Platform Optimization. In this role, you will research and apply engineering best practices and the latest technology to lead physical design for data layers and evolve ways of working to support rapid growth in data inventory as well as the variety and number of deployed data science applications. The platform is expected to enable scalable data acquisition and transformation, BI and web app serving, insight generation, full data, and ML engineering lifecycle including controlled deployment to production and ongoing monitoring and operations.

Our tech stack continues to evolve: Azure Data Factory, Azure Data Lake, Azure Synapse, DBT, Power BI, Collibra, Databricks, Pyspark, Harness CI/CD, OpenShift, GitHub, JIRA

DISCOVER your opportunity What will your essential responsibilities include

. Act as a data engineering expert and partner to Global Technology and data consumers in controlling the complexity and cost of the data platform, whilst enabling performance, governance, and maintainability of the estate.

. Understand current and future data consumption patterns, and architecture (granular level), and partner with Architects to ensure optimal design of data layers.

. Apply best practices in Data architecture. For example, the balance between materialization and virtualization, the optimal level of de-normalization, caching, and partitioning strategies, choice of storage and querying technology, and performance tuning.

. Leading and hands-on execution of research into new technologies. Formulating frameworks for assessment of new technology vs. business benefit, implications for data consumers.

. Act as a best practice expert, and blueprint creator of ways of working such as testing, logging, CI/CD, observability, and release, enabling rapid growth in data inventory and utilization of Data Science Platform.

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

In this role, you will report to the Data Platform Optimization 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.

. Extensive work experience in various data engineering & and modeling techniques (relational, data warehouse, semi-structured, etc.), application development, and advanced data querying skills.

. Relevant experience in programming experience in SQL.

. Couple of years of experience in programming in PySpark with Databricks.

. Experience with DBT is a plus.

. Solid experience writing, optimizing, and analyzing SQL and data pipelines, with robust capability to interpret complex data requirements and architect solutions.

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

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

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

. Knowledge of Azure cloud computing platform with Azure Synapse, ADLS, and ADF.

. Familiarity with Python or Scala is a plus.

. Familiarity with Reporting software - MicroStrategy and Power BI 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 specialty 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, empowered to deliver top client service across all our lines of business property, casualty, professional, financial lines, and specialty.

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

Learn more at

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.

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

Job tags

Salary