Senior Data Engineer-Databricks & Data Modeling

Winsupply

  • Moraine, OH
  • On-site
  • Senior level
  • 7+ yrs experience
  • Data Engineering
  • Visa: not specified

The role in 30 seconds

As a Senior Data Engineer at Winsupply, you will be responsible for developing, deploying, and maintaining production data pipelines and reusable data models within the Databricks lakehouse on Google Cloud. This role requires strong Databricks engineering skills combined with expertise in relational and dimensional modeling to transform complex source data into trusted Silver- and Gold-layer data products.

Is this role a fit for you?

The backgrounds this role is most likely to hire from, as RoleStack reads the posting.

Strong match

  • B2B enterprise platform / workflow software
  • Internal tooling / back-office systems
  • B2B infrastructure / API / developer tools
  • Growth-stage
  • Startup / greenfield

Workable stretch

  • B2C consumer-facing application
  • Creator / builder / self-serve tool
  • Marketplace / multi-sided platform
  • Data platform / ML pipeline
  • Enterprise-scale

Harder transition

  • Embedded systems / hardware-adjacent
  • Regulated environment

Industry: Horizontal Agnostic (with signals for Supply Chain/Logistics and Software/SaaS). See your personal match score

What they're really screening for

Must-haves

  • CORE 7+ years of related professional experience in data engineering, data warehousing, analytics engineering, or comparable roles.
  • CORE 3+ years of hands-on Databricks production experience with Delta Lake, Unity Catalog, Spark/PySpark, and Databricks SQL.
  • CORE 3+ years of meaningful relational or dimensional data modeling experience, including personally designing and deploying fact/dimension or integrated business models.
  • CORE Foundational understanding of core business processes and entities (e.g., Customer, Product, Vendor, Purchasing, Inventory, Sales, and Pricing), with the ability to validate relationships with business stakeholders and apply that context to data modeling and governance decisions.
  • CORE Experience building production ETL/ELT pipelines, implementing incremental processing, and supporting operational data quality and monitoring.
  • CORE Strong SQL and Python/PySpark skills, with hands-on Git, testing, code review, and CI/CD practices.
  • PLUS Associate degree in Computer Science, Information Systems, or a related field; equivalent professional experience or relevant technical certifications may be considered.
  • CORE Develop reusable, maintainable code with Git, peer reviews, unit/integration tests, CI/CD, and repeatable Databricks deployment practices.
  • CORE Tune Spark workloads, Databricks SQL queries, Delta table layouts, job configuration, and compute usage to improve performance, reliability, and cost efficiency.
  • CORE Translate core business processes and relationships among Customer, Product, Vendor, Purchasing, Inventory, Sales, and Pricing entities into accurate Silver-layer structures and reusable Gold-layer data products, working with Data Architecture leadership on complex model decisions.

Nice-to-haves

  • PLUS Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related discipline.
  • PLUS Databricks Certified Data Engineer Professional or comparable Databricks certification.
  • PLUS Experience with Databricks on Google Cloud, Lakeflow pipelines/jobs, Auto Loader, CDC, and Declarative Automation Bundles.
  • PLUS Kimball dimensional modeling, enterprise data governance, semantic modeling for Looker, or advanced Spark performance optimization.
  • PLUS Experience integrating IBM/mainframe, DB2, distribution/supply-chain, financial, or pricing data.

Résumé keywords for this role

Terms the posting stresses. Include the ones you can honestly back up.

Tools & technologies

  • Databricks
  • Delta Lake
  • Unity Catalog
  • Apache Spark
  • Python
  • PySpark
  • Databricks SQL
  • SQL
  • Git
  • CI/CD
  • ERP
  • API
  • Cloud Storage
  • CDC
  • ETL

Concepts & phrases

  • Senior Data Engineer
  • Databricks & Data Modeling
  • production data pipelines
  • reusable data models
  • Databricks lakehouse
  • Silver- and Gold-layer
  • data products
  • Data Architecture & Engineering
  • architectural standards
  • source ingestion
  • production support
  • production ingestion and transformation pipelines
  • Delta Lake
  • Unity Catalog
  • Apache Spark

Words that count as the same thing: "Databricks" ≈ Databricks Lakehouse, Delta Lake, Unity Catalog · "ETL/ELT" ≈ Data pipelines, Data ingestion, Data transformation · "dimensional modeling" ≈ fact tables, conformed dimensions, star schemas · "SCD Type 1/2" ≈ Slowly Changing Dimensions Type 1/2, History handling in dimensions · "CDC" ≈ Change Data Capture

Check my résumé against these keywords

Hiring at Winsupply

Open senior roles RoleStack tracks right now, posted in the last 30 days.

Full job description from Winsupply

From Winsupply's posting. View the original

Winsupply is in the business of creating and enabling entrepreneurs to achieve their dreams through wholesale distribution. Winsupply is a group of over 670 locally-owned companies that operate across a variety of industries, including HVAC, Plumbing, Electrical and more. The purpose of the support services campus is to eliminate obstacles and provide support to help our entrepreneurs succeed. Support service employees assist entrepreneurs in achieving their dreams through finance, accounting, IT, and other back-office operations.

Show full description Show less

Position Summary

The Senior Data Engineer - Databricks & Data Modeling will develop, deploy, and maintain production data pipelines and reusable data models within Winsupply's Databricks lakehouse on Google Cloud. This hands-on role combines strong Databricks engineering skills with practical relational and dimensional modeling expertise to convert complex source data into trusted Silver- and Gold-layer data products. Working within the Data Architecture & Engineering team, this individual will implement approved architectural standards, collaborate with business stakeholders, Data Governance, and IT, and take ownership of reliable, efficient delivery from source ingestion through production support.

Accountabilities/Responsibilities

• Build, test, deploy, and support production ingestion and transformation pipelines using Databricks, Delta Lake, Unity Catalog, Apache Spark, Python/PySpark, and Databricks SQL.
• Independently design and implement relational and dimensional data models for assigned data products, including fact tables, conformed dimensions, star schemas, and slowly changing dimensions (SCD Type 1/2).
• Translate core business processes and relationships among Customer, Product, Vendor, Purchasing, Inventory, Sales, and Pricing entities into accurate Silver-layer structures and reusable Gold-layer data products, working with Data Architecture leadership on complex model decisions.
• Ingest and integrate batch and streaming data from ERP, relational, legacy/mainframe, fixed-width or delimited files, APIs, and cloud storage; handle schema changes, incremental loads, and CDC as appropriate.
• Implement business keys, table grain, joins, deduplication, history handling, and source-to-target mappings that produce repeatable, traceable results.
• Create and automate data quality checks, reconciliation, pipeline monitoring, alerting, exception handling, and recovery procedures for production operations.
• Tune Spark workloads, Databricks SQL queries, Delta table layouts, job configuration, and compute usage to improve performance, reliability, and cost efficiency.
• Develop reusable, maintainable code with Git, peer reviews, unit/integration tests, CI/CD, and repeatable Databricks deployment practices.
• Partner with business process owners and Data Governance to understand operational workflows, validate entity definitions and business rules, and use that context to inform sound data modeling, quality, lineage, and access decisions.
• Document pipelines, models, transformation logic, dependencies, and runbooks so solutions can be maintained and supported by the broader team.
• Troubleshoot data defects and pipeline failures, identify root causes, and drive fixes through production with appropriate communication and ownership.
• Collaborate with the architecture team, DaaS, IT, and delivery partners; contribute practical recommendations and mentor peers while supporting approved technical direction.

Competencies for Success

• Has delivered and supported Databricks pipelines and data products in production from raw ingestion through trusted analytical outputs.
• Demonstrates strong modeling judgment grounded in business process knowledge: understands core entities, grain, keys, relationships, SCD Type 1/2, fact/dimension design, and reporting impacts.
• Troubleshoots distributed data processing, data-quality discrepancies, and performance issues with a structured, evidence-based approach.
• Communicates clearly, challenges proposed solutions constructively, and collaborates across technical and business teams.
• Takes ownership of code quality, documentation, reliability, cost awareness, and delivery commitments. Qualifications/Experience

Minimum Qualifications

• 7+ years of related professional experience in data engineering, data warehousing, analytics engineering, or comparable roles.
• 3+ years of hands-on Databricks production experience with Delta Lake, Unity Catalog, Spark/PySpark, and Databricks SQL.
• 3+ years of meaningful relational or dimensional data modeling experience, including personally designing and deploying fact/dimension or integrated business models.
• Foundational understanding of core business processes and entities (e.g., Customer, Product, Vendor, Purchasing, Inventory, Sales, and Pricing), with the ability to validate relationships with business stakeholders and apply that context to data modeling and governance decisions.
• Experience building production ETL/ELT pipelines, implementing incremental processing, and supporting operational data quality and monitoring.
• Strong SQL and Python/PySpark skills, with hands-on Git, testing, code review, and CI/CD practices.
• Associate degree in Computer Science, Information Systems, or a related field; equivalent professional experience or relevant technical certifications may be considered.

Preferred Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related discipline.
• Databricks Certified Data Engineer Professional or comparable Databricks certification.
• Experience with Databricks on Google Cloud, Lakeflow pipelines/jobs, Auto Loader, CDC, and Declarative Automation Bundles.
• Kimball dimensional modeling, enterprise data governance, semantic modeling for Looker, or advanced Spark performance optimization.
• Experience integrating IBM/mainframe, DB2, distribution/supply-chain, financial, or pricing data.

Physical Demands

The physical demands here are representative of those that must be met to successfully perform the essential job functions with or without reasonable accommodations:

• Sitting for extended periods of time
• Dexterity of hands and fingers to operate a computer keyboard, mouse, power tools, and other computer components
• Lifting and transporting of moderately heavy objects, such as computers and peripherals
• Occasional travel to interact with local companies, regional offices and/or support implementation of solutions

We are committed to inclusion, diversity, and equal employment opportunity, regardless of race, color, ancestry, religion, sex, gender, national origin, sexual orientation, age, citizenship, marital status, disability, veteran status, or any other factor protected by applicable federal, state, or local laws.

FAQ

How much experience do you need?

The posting asks for 7+ years in data engineering. It is a senior-level role.

Does Winsupply sponsor visas for this role?

The posting does not say whether visa sponsorship is available. Ask the recruiter before you apply.

Is this role remote?

It is an on-site role.

What tools and technologies does the posting mention?

Databricks, Delta Lake, Unity Catalog, Apache Spark, Python, PySpark, Databricks SQL, SQL, Git, CI/CD, ERP, API, Cloud Storage, CDC, ETL.