Senior Data Engineer

PartsSource Inc.; Hudson (OH); Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

Competitive compensation package

Career and professional development

Hybrid work culture

Inclusive and diverse community

Job summary

PartsSource Inc. in Hudson, Ohio is looking for a Senior Data Engineer to modernize their enterprise data platform. This hands-on role involves designing and building scalable data pipelines while collaborating with analytics and product teams.

The ideal candidate has over 5 years of data engineering experience, proficiency in SQL and Python, and hands-on expertise with Databricks. The position offers hybrid work arrangements and comprehensive benefits.

Qualifications

• 5+ years of experience in data engineering or enterprise ETL/ELT development.
• Advanced SQL and experience with relational databases.
• Hands-on experience with Databricks and Lakehouse architecture.

Responsibilities

• Design, develop, and optimize ETL/ELT pipelines.
• Lead migration of data systems to Databricks.
• Establish data quality and monitoring standards.

Skills

Data engineering

SQL

Python

Databricks

Data modeling

Version control (GitHub)

Tools

Talend

DB2

SQL Server

AWS

Terraform

Job description

PartsSource is the leading technology and software platform for managing mission‑critical healthcare equipment. Trusted by more than 5,000 U.S. 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.

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

• 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.

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.