Senior Data Engineer

Greetings!

We are looking for a hands-on Data Engineer who can work directly with complex data models and build reliable data pipelines that support reporting and analytic use cases. This role requires someone who is comfortable writing production-grade code, working with object-oriented data structures, and analyzing data through advanced SQL.

Location: Bethlehem PA OR Holmdel NJ

Duration: Long term contract

Client: One of the largest Insurance company in North America

Must have skills: SQL (Hands on), Python (Hands on), Pyspark, AWS and Databricks.

What You’ll Do

• Work with object-oriented data models and understand how they translate into physical structures.
• Write strong, optimized SQL to query, profile, and validate data across multiple sources.
• Build Python, PySpark, and SQL scripts to extract, transform, and load data into curated data assets.
• Support reporting, analytics, and cross-functional data use cases by delivering clean, well-structured datasets.
• Analyze data quality issues, troubleshoot pipeline failures, and recommend improvements.
• Collaborate with engineering, analytics, and product teams to understand data requirements and deliver scalable solutions.

What We’re Looking For

• Proven experience as a Data Engineer with hands-on development (not design-only or oversight-only).
• Strong SQL skills. Ability to write complex joins, window functions, aggregations, and performance-tuned queries.
• Proficiency in Python and PySpark for data extraction, transformation, and automation.
• Ability to read and work with object-oriented data models and understand entity relationships.
• Experience building data pipelines in distributed or cloud environments is a plus.
• Solid understanding of data validation, data quality checks, and debugging techniques.
• Ability to work independently, communicate clearly, and collaborate with technical and non-technical teams.

Best Regards,