Data Engineer (Contractor)

On-Site role

Job Description:

• Data Engineer (Contractor)
• Client is seeking a Data Engineer (Contract) to design, build, and maintain the data pipelines and models powering our Manufacturing Intelligence datI have coa lakehouse. 
• This is an onsite contract position based at our headquarters in Foster City, CA.
• You'll bring manufacturing data from on-prem databases, SAP MES, SAP HANA, test and diagnostics systems, etc. into the MOPS lakehouse, and shape it into trusted tables for KPIs, dashboards and AI use cases.
• About 80% of the role is hands-on data engineering.
• The other 20% keeps the pipelines deployable, observable and cost efficient: CI/CD, AWS ingestion infrastructure, and MOPS-scoped Databricks configuration.
• You'll also work on our migration from Redshift to Databricks, and partner closely with the Data Engineering, Data Analytics, Manufacturing Operations and Databricks platform team.

Responsibilities:

• Build batch and streaming ingestion into Delta Lake using Auto Loader, Lakeflow Declarative Pipelines, Lakeflow Connect or Structured Streaming, including CDC feeds from AWS DMS and SAP SLT.
• Design and maintain bronze, silver and gold (medallion) layers that follow MOPS naming conventions and data dictionary standards.
• Build incremental dbt models on Databricks (dbt-databricks), using MERGE and upsert patterns, SCD Type 2, and handling for late or out-of-order records.
• Model manufacturing data for analytics, such as a single source of truth per unit (SFC), work orders, nonconformances, station results and first-pass yield, and feed the semantic layer used by analysts.
• Process large and semi-structured data, such as JSON test payloads, using PySpark and Databricks SQL.
• Tune pipeline performance and cost through liquid clustering or partitioning, OPTIMIZE, VACUUM, file sizing and right-sized job compute.
• Own data quality with dbt tests, Lakeflow expectations and Lakehouse Monitoring, including freshness SLAs and alerting.
• Orchestrate workloads with Databricks Workflows or Airflow.
• Migrate existing Redshift models and pipelines to Databricks: translate SQL, run in parallel, reconcile results and cut over.
• Partner with analysts and manufacturing stakeholders on requirements, and document lineage, data contracts and table definitions in Unity Catalog.
• Build and maintain CI/CD for MOPS jobs, pipelines and dbt models with Databricks Asset Bundles and GitHub Actions, across dev, staging and prod.
• Manage MOPS-owned catalogs, schemas, volumes and grants in Unity Catalog, following the central platform team's governance model.
• Configure job compute and SQL warehouses within central cluster policies; manage MOPS service principals, secret scopes and OAuth machine-to-machine auth for Airflow and dbt.
• Configure and troubleshoot the AWS ingestion layer that feeds the lakehouse (DMS, Kinesis, S3 landing buckets, IAM roles), partnering with infrastructure owners on provisioning through Terraform.
• Monitor job health and DBU spend using system tables and tagging, and set up alerting for failures and SLA misses.
• Document pipelines, runbooks and operational procedures, and take part in incident response and root cause analysis for data pipeline issues.

Minimum Qualifications:

• Bachelor's degree in Computer Science, Information Systems, Engineering or a related field, or equivalent practical experience, plus 6+ years in data engineering.
• Strong SQL and Python, including PySpark.
• Hands-on production experience on Databricks: Delta Lake, Unity Catalog permissions, Workflows or jobs, and Spark performance tuning.
• Production experience with dbt, including incremental models and tests.
• Solid grasp of dimensional modeling, the medallion pattern, and CDC and incremental loading.
• Experience deploying data code through Git-based workflows and CI/CD (e.g., GitHub Actions, Databricks Asset Bundles or similar).
• Working knowledge of AWS data services (S3, IAM, DMS or Kinesis) and infrastructure as code (e.g., Terraform).

Preferred Qualifications:

• Databricks Certified Data Engineer Associate or Professional, AWS certification (e.g., Solutions Architect Associate) a plus.
• Experience preparing data for Databricks AI/BI dashboards, Genie, or ML and LLM use cases.
• Background in manufacturing or industrial data, such as quality, yield, traceability or MES.
• Understanding of data governance and compliance as they relate to data pipelines.

About us:
At our organization, we take our mission and values to heart! We are on a mission to offer more and better jobs all over the world! Our goal is to care for you while you care for our clients and get you paid the highest pay possible. All our associates working with us are expected to embrace our RACE values: R - Results Matter, A- Approachable, C - Care, and E - Emergency i.e. work with a sense of urgency.

For more relevant job opportunities please visit our website: Denken Solutions Careers