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.

Semiconductor Equipment Integration Engineer

New Iron is seeking a talented and driven entry level  Engineer to support the deployment and configuration of semiconductor tools supporting a new manufacturing operation. 

This position focuses on configuring semiconductor equipment and being a liaison between the equipment technical engineers and software engineers.

The ideal candidate has knowledge of front end wafer semiconductor manufacturing, programming experience and an Electrical Engineering degree.

Job function may include:

• Configure Equipment Automation (EA) solutions integrated with factory and business systems for customers.

• Collaborate with Lead Engineer on the configuration and programming of new Semiconductor tools.

• Work closely with software engineers and hardware technicians to ensure consistency across the integration of new tools.

• Develop and deliver training materials and demonstrations for EA applications.

• Perform software installations.

• Respond to customer requests for implementation and integration support.

Should Have: 

• Proficient in programming languages: we are open to a range of languages

• Familiarity with Semiconductor Industry

• Experience as a developer in semiconductor, solar, display, or PCB manufacturing.

• Previous experience working within the Semiconductor industry.

This is an onsite contract position for a client based in the US. Principals only. Recruiters please do not contact this job poster.