Apply Now

Senior Data Engineer

Columbia, MO, US • Posted 4 days ago • Updated 4 hours ago

Full Time

On-site

Fitment

Dice Job Match Score™

🫥 Flibbertigibetting...

Job Details

Skills

Scalability
Data Modeling
Data Structure
Testing
Documentation
Data Quality
Reporting
Data Engineering
Python
Data Warehouse
Snow Flake Schema
Amazon Redshift
Data Architecture
Dimensional Modeling
Star Schema
ELT
Replication
Google Cloud
Google Cloud Platform
SQL
PostgreSQL
Cloud Computing
Enterprise Resource Planning
Microsoft Windows Vista
HR Management
Workday
Continuous Integration
Continuous Delivery
Workflow
Management
Warehouse
Optimization
Marketing Operations
Finance
Legal

Scalability
Data Modeling
Data Structure
Testing
Documentation
Data Quality
Reporting
Data Engineering
Python
Data Warehouse
Snow Flake Schema
Amazon Redshift
Data Architecture
Dimensional Modeling
Star Schema
ELT
Replication
Google Cloud
Google Cloud Platform
SQL
PostgreSQL
Cloud Computing
Enterprise Resource Planning
Microsoft Windows Vista
HR Management
Workday
Continuous Integration
Continuous Delivery
Workflow
Management
Warehouse
Optimization
Marketing Operations
Finance
Legal

Summary

This is an on-site role based in Columbia, MO or Kansas City, MO.
Candidates must be within driving distance and able to work in-office regularly. Remote work is not available for this position.

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

What we're looking for

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

Nice to have

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

Reminders:

This is strictly an on-site role
Must be located within driving distance of Columbia, MO or Kansas City, MO
No remote or hybrid work options available

Who Thrives Here:
The person who does well here likes owning the whole thing rather than a corner of it, cares more about whether the numbers are right than whether the pipeline is clever, and would rather ship a model the finance team actually uses than a perfect one nobody asked for. You're comfortable being the person who knows how the data fits together, and you treat "the business owner doesn't quite know what they want yet" as part of the job rather than a blocker.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 80184942
Position Id: b45893b653c98bdcfe04c7b1fe402544
Posted 4 days ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Senior Data Engineer

Remote

•

Today

We inspire purpose-filled living that brings joy to the modern home. With a team of more than 8,000 associates spanning 130 store and distribution locations across the U.S. and Canada, we achieve together, drive results and innovate to inspire. Drawn together by a shared passion for our customers and a spirit of fun, we deliver high-quality home furnishings that are expertly designed, responsibly sourced and bring beauty and function to people's homes. From the day we opened our first store in C

Full-time

Data Analyst / Engineer (5 to 10 Years Experience) | W-2 Opportunities

Remote

•

2d ago

Data Engineer (5 to 10 Years Experience) | W-2 Opportunities Location: Multiple Locations Across the United States (Remote, Hybrid & On-site opportunities based on client requirements) We are currently seeking experienced Data Engineers interested in W-2 employment for current and upcoming client projects. Required Skills 5 10 years of experience in Data Engineering.Strong proficiency in SQL and Python.Hands-on experience with ETL/ELT development and data pipeline design.Experience with cloud da

Easy Apply

Contract

$80,000 - $100,000

Senior Data Integration Engineer

Remote

•

Today

We are seeking a highly skilled, solution-oriented Senior Data Integration Engineer with deep expertise in modern data engineering, cloud-native architectures, and robust pipeline development. In this role, you will be a senior technical driver in creating, optimizing, and modernizing advanced data integration systems. You will collaborate closely with product, engineering, and architecture teams to bridge raw source environments and analytical databases. If you excel in cloud ecosystems, thrive

Full-time

Sr Cloud ETL Developer

No location provided

•

Today

Job Description A Senior ETL Developer specializing in Google Cloud Platform (Google Cloud Platform) and BigQuery designs, builds, and optimizes large-scale data pipelines. This role requires advanced SQL, Python, orchestration (Airflow), and data warehousing skills to deliver scalable, reliable data solutions. This role focuses on cloud-native data architecture on Google Cloud Platform (Google Cloud Platform) while integrating enterprise reporting tools including MicroStrategy and cloud-based

Full-time

USD 111,525.00 - 146,744.00 per year

Search all similar jobs

More jobs at Emery Sapp and Sons, Inc. in Columbia, MO