• Assess the current data and BI architecture • Organize and standardize datasets within the Data Lake • Define standardized data models • Implement data governance best practices • Build data ingestion and transformation pipelines • Structure analytical layers (raw, curated, analytics) • Improve BI query performance and quality • Work with business teams to ensure consistency of metrics • Document data structures and models used • Support the evolution of the company's data architecture

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

• Design, build, and maintain scalable, robust, and automatable data pipelines to support ingestion and processing across structured, unstructured, and media data types (including audio, text, and video). • Partner with product, data science, and business stakeholders to translate business goals and customer needs into engineering requirements — starting with the desired outcome and working backwards into concrete, scalable solutions. • Improve data quality, observability, lineage, and reliability across our modular processing pipeline architecture. • Build and maintain core data infrastructure components (e.g., ingestion APIs, metadata services, observability tooling) that support parallel processing, microservices, and config-driven workflows. • Help evolve our approach to handling time-series and media content at scale, optimizing for throughput, cost efficiency, and real-world performance. • Collaborate across teams to validate production data flows, support onboarding of new datasets, and troubleshoot issues quickly and effectively.

• Design, build, and maintain scalable, production-grade ETL pipelines • Own and continuously improve data quality frameworks, validation rules, and monitoring • Ensure reliability of data pipelines (handling failures, inconsistencies, late data) • Deliver clear, actionable insights for both technical and non-technical stakeholders • Build and maintain dashboards, reporting systems, and alerting mechanisms • Investigate and resolve data issues with a focus on root cause and long-term stability • Evaluate and improve the data architecture and technology stack • Contribute to code quality, standards, and best practices within the team • Support DevOps-related processes where needed • Align technical solutions with product goals and customer needs