New Iron

Role Description 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. - 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. Qualifications - 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. Requirements - 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.

Role Description 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. - 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. Qualifications - Expert-level mastery of dimensional modeling (Kimball methodology, Star Schemas). - Strong hands-on SQL skills specifically for data transformation. - Experience in a Databricks/Spark environment (Highly preferred). Requirements - 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. Company Description