Senior Data Engineer

PartsSource • Hudson, OH

5h • Hybrid

About The Position

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.

Requirements

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

Nice To Haves

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

Responsibilities

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

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed