Senior Data Engineer

parts source; Jersey City (KY, NJ); Hybrid; USD 90,000 - 110,000; Full time

Benefits offered by this job

Competitive compensation package

Career and professional development

Hybrid culture with flexible workspaces

Inclusive community of professionals

Job summary

PartsSource is on a quest for a Senior Data Engineer in Kentucky who will lead the modernization of our enterprise data platform. This role requires expertise in ETL/ELT development, particularly using SQL and Databricks, to deliver reliable data solutions across the organization.

Ideal candidates should have over 5 years of experience in data engineering, strong SQL skills, and proficiency in Python. Join a collaborative team dedicated to ensuring healthcare is always on.

Qualifications

• 5+ years of experience in data engineering, data warehousing, or enterprise ETL/ELT development.
• Hands-on experience with Databricks — Lakehouse architecture, Unity Catalog, Delta Lake.
• Strong data modeling, query optimization, and performance tuning skills.

Responsibilities

• Design, develop, and optimize ETL/ELT pipelines using SQL, Python, Talend, and Databricks.
• Lead migration of data systems from DB2/SQL Server to Databricks.
• Guide phased replacement of Talend with Databricks-native processes.

Skills

SQL

Python

Databricks

Data modeling

Performance tuning

Education

5+ years of experience in data engineering

Tools

DB2

Git/GitHub

AWS

Talend

Job description

PartsSource is the leading technology and software platform for managing mission-critical healthcare equipment. Trusted by over 5,000 US hospitals and 15,000 clinical sites, PartsSource empowers providers and service organizations to maximize clinical availability for patient care and automates the procurement of parts, services and training through a unique digital experience.

PartsSource team members are deeply committed to our mission of Ensuring Healthcare is Always On®, which is foundational to our success and growth. Our vibrant culture is built upon aligned values, shared ownership, mutual respect, and a passion for collaborating to solve complex customer problems.

About the Job Opportunity

The Senior Data Engineer plays a leading role in modernizing our enterprise data platform as we transition from legacy systems (DB2, Talend) to a cloud-native stack built on AWS and Databricks. This is a hands‑on individual contributor role responsible for designing and building scalable pipelines, setting best practices, and mentoring peers — while working closely with Analytics, Product, and business stakeholders to deliver reliable, well‑governed data across the organization.

What You'll Do

• Design, develop, and optimize ETL/ELT pipelines using SQL, Python, Talend, and Databricks to support analytics, reporting, and operational data needs.
• Lead and support migration of data systems from DB2/SQL Server to Databricks, including performance benchmarking, validation, and pipeline refactoring.
• Guide the phased replacement of Talend with Databricks‑native processes; assist in evaluating and implementing emerging tools and frameworks.
• Establish and enforce data quality, observability, and lineage standards — including monitoring and alerting for key pipelines.
• Design data models and schemas for reporting and analytics use cases, applying normalization and denormalization best practices.
• Act as a technical thought partner in data architecture discussions, aligning platform decisions with business growth and governance objectives.
• Contribute to internal engineering standards: version control (GitHub), CI/CD, infrastructure as code (IaC), and documentation.
• Mentor junior data engineers and serve as a technical resource across the team.

What You'll Bring

Required

• 5+ years of experience in data engineering, data warehousing, or enterprise ETL/ELT development.
• Advanced SQL and experience with relational databases including SQL Server and DB2.
• Hands‑on experience with Databricks — Lakehouse architecture, Unity Catalog, Delta Lake, S3, and IAM.
• Proficiency in Python for pipeline development, automation, and data processing.
• Strong data modeling, query optimization, and performance tuning skills.
• Experience with Git/GitHub and collaborative development workflows.

Preferred

• Experience with Semarchy or similar MDM platforms; knowledge of Kafka or real‑time streaming.
• Proficiency with IaC tooling (Terraform, OpenTofu); AWS or Databricks certification a plus.
• Prior experience in a lead or mentoring role within a data team.

Who We Want to Meet

Act Like an Owner

• You own the reliability of what you build — you monitor it, fix it, and document it without being asked. Accountability & Execution, Results Driven

Serve with Purpose

• You understand that clean, reliable data drives every decision at PartsSource. You partner across teams with patience and clarity because you know the downstream stakes. Clear & Critical Thinking, Relationship Management

Adapt to Thrive

• You pick up new platforms and patterns quickly, stay effective through platform migrations, and apply feedback to keep improving. Learning Agility, Resilience

Collaborate to Win

• You elevate the team through code reviews, shared documentation, and proactive knowledge transfer — not just your individual output. Team Orientation, Alignment & Cohesion

Challenge the Status Quo

• You ask why when existing patterns create complexity, and you bring improvement proposals with engineering context — not just complaints. Curiosity & Problem Solving, Continuous Improvement

Benefits & Perks

• Competitive compensation package with salary, incentives, company ownership/equity, and comprehensive benefits (401k match, health, college debt reduction, and more!)
• Career and professional development through training, coaching and new experiences.
• Hybrid culture with new & beautiful workspaces that balance flexibility, collaboration, and productivity.
• Inclusive and diverse community of passionate professionals learning and growing together.

EEO

PartsSource, Inc., and its affiliates and subsidiaries, provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

Legal authorization to work in the U.S. is required.