Job
Description
Gurgaon/ Bangalore, 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 industrious advantage. Our Chief Data Office also known as our Innovation, Data Intelligence & Analytics team (IDA) 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 Scientist for our Data Engineering team. The role will support the team’s efforts towards creating, enhancing, and stabilizing the Enterprise data lake through the development of the data pipelines. This role requires a person who is a team player and can work well with team members from other disciplines to deliver data in an efficient and strategic manner. What You’ll Be DOING What will your essential responsibilities include? Relevant years of extensive work experience in various data engineering & modeling techniques (relational, data warehouse, semi-structured, etc.), application development, advanced data querying skills. Relevant years of programming experience using Databricks. Relevant years of experience using Microsoft Azure suite of products (ADF, synapse and ADLS). Solid knowledge on network and firewall concepts. Provide technical guidance and mentorship to junior and mid-level developers. Lead design discussions and code reviews to ensure high-quality development. Utilize SQL to query and manipulate data from various sources, ensuring data accuracy and integrity. Develop and maintain data pipelines using DBT, Databricks to facilitate data processing and transformation. Skilled professional with extensive experience in SQL performance tuning and a proven track record in writing complex SQL queries. Demonstrated ability to optimize database performance, enhance data retrieval efficiency, and ensure the integrity and security of data across various applications. Collaborate with project managers to define project scope, timelines, and deliverables. Oversee the development process, ensuring projects are delivered on time and meet quality standards. Assist in deploying and managing data solutions on Azure Cloud, ensuring optimal performance and security. Create and maintain documentation for data processes, data models, and system architecture. Participate in data quality checks and troubleshooting to resolve data-related issues. Maintain integrity and quality across all pipelines and environments. Participate in the architectural design and decision-making processes for new projects and enhancements. Bring ideas to the tables that help to streamline and rationalize BTL jobs. Leads small team strategic partner/vendor team members. Works with business users and tries to bring closure to the request. You will report to Lead Scientist. What You Will BRING We’re looking for someone who has these abilities and skills: Required Skills And Abilities Proficiency in SQL & experience with DBT is essential. Bachelor’s degree in computer science, Mathematics, Statistics, Finance, related technical field, or equivalent work experience. Proficiency in SQL for database querying and management. Excellent programming skills in Python, with experience in data manipulation and analysis. Must have hands-on experience in designing and developing ETL Pipelines. Relevant years of exposure and good proficiency in data warehousing concepts. Proficient in SQL and database Design concepts. Good knowledge of unit testing, documentation - low-level design's Desired Skills And Abilities Understanding of the Azure cloud computing platform, specifically Azure Synapse and Azure Data Lake Storage (ADLS), is a plus. Experience with Databricks, Azure Data Factory (ADF), and PySpark is must. A passion for data and experience in a data-driven organizational environment. A commitment to excellence and a genuine care for both your work and the overall mission of the organization. Knowledge of GitHub and build management practices is an added advantage. Who WE are 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 axaxl.com What we OFFER Inclusion 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 enables business growth and is critical to our success. That’s why we have made a strategic commitment to attract, develop, advance and retain the most inclusive workforce possible, and create a 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. Total Rewards AXA XL’s Reward program is designed to take care of what matters most to you, covering the full picture of your health, wellbeing, lifestyle and financial security. It provides competitive compensation and personalized, inclusive benefits that evolve as you do. We’re committed to rewarding your contribution for the long term, so you can be your best self today and look forward to the future with confidence. 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. Show more Show less
