On-Site Senior Data Engineer - Own Data Platform

ESS Companies; Columbia Township (MO); On-site; USD 120,000 - 180,000; Full time

Job summary

ESS Companies is seeking an on-site Data Engineer based in Columbia, MO or Kansas City, MO. You will own data pipelines, architect the cloud data warehouse, and design dimensional models that support accurate, decision-ready reporting.

You will collaborate with Finance, HR, and Operations to translate business needs into scalable data solutions and ensure data trust and reliability across the organization.

Qualifications

• Strong data engineering fundamentals with clean, maintainable SQL and Python.
• Experience building and operating production data pipelines.
• Hands-on experience with a cloud data warehouse (BigQuery preferred; Snowflake or Redshift acceptable).
• Experience with transformation frameworks (dbt strongly preferred) and layered data architecture (raw → staging → modeled).
• Solid understanding of dimensional modeling (facts vs. dimensions, star schema design).
• Experience with ELT / data replication tools (Fivetran or similar).
• Ability to partner with non-technical stakeholders and translate business needs into scalable data solutions.

Responsibilities

• Own the data pipelines, manage automated replication and ingestion into the warehouse.
• Monitor performance, troubleshoot failures, and handle schema changes; add new data sources as needed.
• Own the platform architecture: maintain cloud warehouse architecture, define standards, ensure cost efficiency.
• Own the data modeling: design dimensional models, translate business needs into data structures; support reporting.

Skills

SQL

Python

Data pipelines

BigQuery

dbt

ETL/ELT

Dimensional modeling

Fivetran

Tools

Snowflake

Redshift

BigQuery

dbt

Job description

ESS Companies is seeking an on-site Data Engineer based in Columbia, MO or Kansas City, MO. You will own data pipelines, architect the cloud data warehouse, and design dimensional models that support accurate, decision-ready reporting.

You will collaborate with Finance, HR, and Operations to translate business needs into scalable data solutions and ensure data trust and reliability across the organization.