Hiring For Lead Data Engineer @ Jersey City, Nj (Day 1 Onsite)

Job Title: Lead Data Engineer
Location: Jersey City, NJ (Day 1 Onsite)
Experience: 10+ years (mandatory)

Client: EXL Services

Key Skills

Snowflake, SQL, Python, PySpark, Spark, AWS (Glue, EMR, S3, Aurora, RDS), Apache Iceberg, Big Data Concepts, CI/CD

Responsibilities

• Lead the design, development, and implementation of scalable data solutions using AWS and Snowflake.
• Collaborate with business, analytics, and insurance domain stakeholders to understand requirements and translate them into robust technical solutions.
• Design and maintain end-to-end data pipelines supporting large-scale insurance data (claims, loss, policy, exposure), ensuring data quality, integrity, security, and compliance.
• Optimize data storage, ingestion, and retrieval to support enterprise data warehousing, reporting, and advanced analytics use cases.
• Apply insurance domain knowledge—especially claims processing, loss data, reserving, and financial reporting—to build meaningful, business-driven data models.
• Provide technical leadership and mentorship to a team of 8–10+ data engineers.
• Partner with stakeholders to deliver data-driven insights aligned with insurance business KPIs.
• Ensure adherence to industry standards, data governance, and best practices in data engineering.
• Support release planning, change management, training, knowledge transfer (KT), and L2/L3 production support.

Must Have

• Strong Snowflake expertise (hands-on + architectural):
  • Ability to explain challenging data-related or implementation-related scenarios, including problems faced and solutions delivered.
• ETL / Data Management mastery, including:
  • Query optimization, performance tuning, data quality frameworks
  • RBAC, row-level & column-level security
  • CDC, Incremental vs Batch processing
  • Unix commands, job scheduling, CI/CD pipelines
• Insurance domain experience is mandatory:
  • Hands-on experience with insurance data, preferably claims and loss data
  • Understanding of insurance data flows, regulatory considerations, and reporting needs
• Proven team leadership (8–10+ members) with end-to-end project ownership
• Strong experience handling complex data challenges, clearly articulating problem statements and solutions
• Excellent communication and stakeholder management skills
• Strong knowledge of:
  • Data quality checks, data profiling, STTM
  • Data integration from multiple heterogeneous sources
  • Reusable data engineering frameworks
• Experience with Apache Iceberg and AWS Glue
• 10+ years of experience in Data Engineering and Big Data concepts
• Strong hands-on experience with SQL, Python, PySpark
• Deep understanding of data ingestion and processing frameworks
• Experience in AWS architecture (Glue, EMR, S3, Aurora, RDS)
• Ability to code, debug, tune performance, and deploy applications to Production
• Experience working in Agile methodology
• Strong analytical mindset, problem-solving skills, and ownership mentality

Requirements

• Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field.
• Proven experience as a Lead Data Engineer with a strong focus on AWS and Snowflake.
• Strong understanding of data warehousing concepts and best practices.
• Prior experience in the Insurance industry is required, with clear exposure to:
  • Claims processing systems
  • Loss data, reserves, financial or actuarial data (preferred)
• Proficiency in SQL, Python, PySpark, and related technologies.
• Excellent communication skills with the ability to explain complex technical concepts to non-technical stakeholders.
• Strong problem-solving skills and attention to detail.
• Ability to work independently and collaboratively in a fast-paced environment.