Senior Data Engineer — Own the Data Platform (On-Site)

ESS Companies; Missouri; On-site; USD 110,000 - 170,000; Full time

Job summary

ESS Companies in Columbia, MO or Kansas City, MO is seeking a Senior Data Engineer to own the data pipelines, platform architecture, and data modeling. You will manage ingestion into the warehouse, monitor performance, and add new data sources as business needs evolve. You will collaborate with Finance, HR, and Operations to translate needs into scalable data solutions, implement data quality checks, and ensure trusted reporting for stakeholders.

Qualifications

• Proficient in building scalable data pipelines.
• Strong SQL and Python fundamentals.
• Experience with cloud data warehouses.
• Ability to translate business needs into data models.

Responsibilities

• Own the data pipelines from ingestion to warehouse.
• Own the platform architecture and cost-efficient design.
• Own the data modeling and dimensional designs.
• Ensure data trust with testing, lineage, and quality checks.

Skills

SQL

Python

Data pipelines

Dimensional modeling

ELT

dbt

Stakeholder collaboration

Tools

BigQuery

Snowflake

Redshift

dbt

Fivetran

GCP

Airflow

Job description

ESS Companies in Columbia, MO or Kansas City, MO is seeking a Senior Data Engineer to own the data pipelines, platform architecture, and data modeling. You will manage ingestion into the warehouse, monitor performance, and add new data sources as business needs evolve. You will collaborate with Finance, HR, and Operations to translate needs into scalable data solutions, implement data quality checks, and ensure trusted reporting for stakeholders.