Senior DBT Data Engineer

We need a highly technical Senior Data Engineer to build and optimize production ETL pipelines in a Databricks environment. Working within an agile Scrum team, you will take high-level table designs and SQL transformation sketches from the Data Modeling team and implement them into robust, production-grade systems using DBT.

Core Responsibilities:

• Develop, deploy, and maintain robust data pipelines using DBT in a Databricks ecosystem.
• Translate data models and preliminary SQL sketches into scalable production code.
• Build and maintain DBT macros, libraries, and modular code.
• Collaborate within a team-based Git workflow for version control and deployment.

Must-Haves:

• Deep, hands-on expertise with DBT and Databricks.
• Advanced to expert-level SQL skills.
• Strong experience with GitLab and modern team-based CI/CD development practices.
• Strong foundational knowledge of Python.

Applicants must be authorized to work for any employer in the U.S. Our client is unable to sponsor or take over sponsorship of an employment visa at this time. Principals only.

Senior Data Modeler (Databricks / Kimball)

Project: Internal Databricks System

Overview: We are seeking a true Data Modeler who specializes in Kimball dimensional modeling to drive the architecture for our client’s platform. This is a hands-on modeling role (80% modeling, 20% ETL/Transformation) where you will be the resident Kimball expert. You will not be responsible for production ingestion or building DBT pipelines; instead, you will architect star schemas, write the complex SQL transformations to validate the business logic in Databricks, and hand off the validated logic to the ETL engineering team.

Core Responsibilities:

• Architect and design star schemas utilizing the Kimball methodology.
• Work directly in Databricks/Spark notebooks to explore data, mock up tables, and write advanced SQL to transform source data into dimensional models.
• Act as a mentor and coach to internal team members transitioning to dimensional modeling.
• Partner with the central data engineering team, providing them with validated SQL and table sketches to deploy into production via DBT.

Must-Haves:

• Expert-level mastery of dimensional modeling (Kimball methodology, Star Schemas).
• Strong hands-on SQL skills specifically for data transformation (We are not looking for someone who only draws ERDs in ERwin. You must be able to write the SQL to populate your models).
• Experience in a Databricks/Spark environment (Highly preferred. Exceptional relational modelers with advanced SQL will be considered if willing to learn Databricks quickly).

Nice-to-Haves:

• Python experience.
• Familiarity with SAP HANA source systems.
• Experience in the manufacturing domain.

Applicants must be authorized to work for any employer in the U.S. Our client is unable to sponsor or take over sponsorship of an employment visa at this time. Principals only.