Senior Data Engineer

Ess Inc

Columbia, MO, United States

about 1 month ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Working hours

Regular working hours

Job source

www.indeed.com

Tech stack

Sql Data Warehouse BigQuery Cloud Computing Continuous Integration Data Architecture Data Validation Information Engineering Data Structures Dimensional Modeling Python (Programming Language) PostgreSQL Operational Databases

+10 more

SQL Databases Systems Integration Google Cloud Snowflake Data Lineage Performance Monitor Star Schema Database Replication Data Pipelines Workday

Job description

It’s a broad role with real ownership, which is both the appeal and the challenge: there isn’t a senior engineer above you reviewing every decision. We’re looking for someone ready to own the whole platform and confident enough to ask questions when needed.

What you’ll do:

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 business needs evolve

Own the platform architecture

Maintain and evolve the cloud warehouse architecture
Define layering, naming conventions, performance standards, and cost efficiency
Ensure scalability across multiple subsidiaries

Own the data modeling

Design and maintain dimensional models (facts and dimensions)
Partner directly with Finance, HR, and Operations leaders to translate business needs into data structures
Build models that support accurate, decision-ready reporting

Ensure data trust and reliability

Build in testing, documentation, and data quality checks
Maintain clear data lineage and transparency
Ensure stakeholders trust the accuracy of reporting

Requirements

Strong data engineering fundamentals - clean, maintainable SQL and Python
Experience building and operating production data pipelines
Hands-on experience with a cloud data warehouse (BigQuery preferred; Snowflake, Redshift, or similar 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
Comfortable owning decisions and operating independently, * Experience with Google Cloud Platform (Cloud Run, Cloud SQL/PostgreSQL, Pub/Sub, Cloud Scheduler, Secret Manager)
Experience integrating ERP systems (Viewpoint Vista or similar) and HCM platforms (Workday)
Familiarity with CI/CD-driven data workflows and version-controlled transformations
Experience managing warehouse cost optimization
Background in construction, engineering, or operations-heavy industries