Engineer, Data Modeling

0 years

0 Lacs

Posted:2 weeks ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Gurgaon/Bangalore, IndiaAXA 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. At AXA XL, we view individuals holistically through their People, Business, and Technical Skills. We’re interested in what you bring, how you think, and your potential for growth. We value diverse perspectives, recognizing that each person contributes uniquely to our team's success. We welcome candidates with relevant education and experience in a related field, as well as those with diverse educational backgrounds or equivalent experience.

What You’ll Be DOING

What will your essential responsibilities include?

Data Modeling & Engineering Expertise

  • Demonstrates proficiency in data modeling techniques across relational databases, data warehouses, and semi-structured data formats.
  • Develops and optimizes scalable data pipelines and applications leveraging various data engineering methodologies.
  • Relevant years of extensive experience in data engineering, modeling, and application development.

Programming & Platform Skills

  • Possesses advanced programming skills in Databricks, with extensive experience in building and maintaining data solutions.
  • Skilled in developing data workflows using Databricks notebooks and Spark environments.
  • Relevant years of hands-on programming experience with Databricks.

Cloud Platform & Tools Proficiency

  • Experienced in utilizing Microsoft Azure services such as Azure Data Factory (ADF), Azure Synapse Analytics, and Azure Data Lake Storage (ADLS) for data integration and storage.
  • Capable of deploying, managing, and optimizing data solutions on Azure Cloud, ensuring scalability and security.
  • Relevant years of experience working with Microsoft Azure suite of products.

Network & Security Knowledge

  • Applies foundational understanding of network concepts, firewalls, and security best practices to ensure protected data access and transfer.
  • Practical knowledge of network and security configurations.

Technical Leadership & Mentorship

  • Provides guidance, mentorship, and technical support to junior developers, fostering team skill growth.
  • Leads design discussions and conducts code reviews to uphold high development standards.
  • Proven ability to mentor and lead small teams or vendor partners.

SQL & Data Querying Skills

  • Expert in writing, optimizing, and troubleshooting complex SQL queries to ensure efficient data retrieval.
  • Ensures data accuracy, consistency, and integrity across multiple sources.
  • Extensive experience in SQL development, performance tuning, and complex query writing.

Data Pipeline Development & Maintenance

  • Develops and maintains robust data pipelines using tools like DBT and Databricks, supporting data transformation and processing needs.
  • Implements best practices for pipeline reliability, performance, and security.
  • Proven track record of building and maintaining data pipelines.

Performance Tuning & Optimization

  • Applies SQL performance tuning techniques to enhance query speed and database efficiency.
  • Continuously monitors and optimizes data systems for peak performance.
  • Demonstrated expertise in SQL performance optimization.

Project Collaboration & Delivery

  • Works closely with project managers to define scope, timelines, and deliverables.
  • Oversees development processes to ensure timely delivery of high-quality data solutions.
  • Experience managing or contributing to end-to-end data projects.

Deployment & Operations

  • Assists in deploying, configuring, and managing data solutions on Azure Cloud, maintaining optimal performance and security.
  • Participates in data quality checks and troubleshooting to resolve issues promptly.
  • Hands-on experience in deploying and operating cloud-based data solutions.

Documentation & Data Governance

  • Creates comprehensive documentation for data processes, models, and system architecture.
  • Maintains data integrity, security, and compliance across all environments.
  • Experience establishing and maintaining data governance standards.

Architectural & Strategic Input

  • Participates in architectural design discussions and decision-making for new projects and enhancements.
  • Contributes innovative ideas to streamline data jobs and improve processing efficiency.
  • Involvement in architectural planning and strategic data initiatives.

Team & Stakeholder Collaboration

  • Leads small team efforts or vendor collaborations, providing strategic guidance.
  • Engages with business users to understand requirements and facilitate resolution of data-related requests.
  • Proven ability to collaborate effectively with cross-functional teams and stakeholders.
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

  • Data Analytics: Proficient in analyzing data to derive insights and support decision-making.
  • Data Warehousing & Design: Excellent understanding of data warehousing concepts, database design, and data modeling.
  • Troubleshooting & Debugging: Skilled in identifying, diagnosing, and resolving issues within data pipelines and systems.
  • SQL & Database Management: Proficiency in SQL for querying, managing, and optimizing databases.
  • Programming & Data Manipulation: Excellent programming skills in Python, with experience in data manipulation and analysis.
  • ETL Pipeline Development: Hands-on experience designing and developing ETL pipelines for data integration.
  • Cloud Computing (Preferred): Understanding of Azure cloud platform, specifically Azure Synapse, Azure Data Lake Storage (ADLS), with familiarity in Databricks, Azure Data Factory (ADF), and PySpark.
  • Data Modeling & Schema Design: Knowledge of database schema design, normalization, and best practices.
  • Version Control & Build Management: Familiarity with GitHub, CI/CD pipelines, and build management practices.
  • Testing & Documentation: Experience with unit testing, low-level design documentation, and maintaining high-quality code standards.
  • Educational Background: Bachelor’s degree in computer science, Mathematics, Statistics, Finance, or a related technical field; or equivalent work experience.
  • Professional Experience: Relevant years of experience in data engineering, data warehousing, ETL development, or related technical roles.

Desired Skills And Abilities

  • Customer Centricity: Demonstrates a genuine care for delivering value to users and stakeholders through data solutions.
  • Cross-Functional Collaboration: Effectively collaborates with multidisciplinary teams including data, engineering, business, and product stakeholders.
  • Analytical & Strategic Mindset: Applies analytical thinking to solve complex problems and aligns data initiatives with strategic organizational goals.
  • Resilience: Maintains focus and adaptability in a fast-paced, evolving data environment, overcoming challenges efficiently.
  • Growth Mindset: Demonstrates eagerness to learn new tools, technologies, and methodologies to continuously improve skills and outputs.
  • Performance Excellence: Strives for high-quality deliverables, continuous improvement, and operational efficiency.
  • Business & Insurance Acumen: Understands core business processes and insurance domain knowledge to develop relevant data solutions.
  • Digital Literacy: Familiarity with digital tools, platforms, and the organizational digital ecosystem to leverage data effectively.
  • Stakeholder Management: Engages with stakeholders to gather requirements, communicate insights, and ensure solutions meet organizational needs.
  • Hands-on experience with Azure Synapse Analytics, Azure Data Lake Storage (ADLS), Databricks, Azure Data Factory (ADF), and PySpark.
  • Knowledge of CI/CD practices, build management, and version control systems like GitHub.
  • Familiarity with low-code/no-code data tools and deployment pipelines.

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.

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now

RecommendedJobs for You

bengaluru east, karnataka, india

bengaluru east, karnataka, india