Senior Data Engineer

Emery Sapp & Sons, Inc.

. Own data pipelines, including automated replication and ingestion into the warehouse .

Posted 9/29/2026full-timeColumbia • Missouri • United StatesSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates strong data engineering fundamentals with expertise in SQL and Python, alongside hands-on experience in building and operating production data pipelines within cloud data warehouse environments. Capable of translating business needs into scalable data solutions while ensuring data quality and transparency.

Highest-signal resume keywords

Data Pipeline OwnershipCloud Data Warehouse ExperienceDimensional Modeling ExpertiseSQL and Python ProficiencyELT/Data Replication Tools Experience

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLPythonDimensional ModelingData Pipeline DevelopmentData Quality ChecksData Lineage MaintenanceCloud Data WarehouseTransformation FrameworksCost-Efficiency PracticesSchema Management

Soft Skills

Independent Decision-MakingStakeholder CommunicationCollaboration with Non-Technical Stakeholders

Tools & Technologies

BigQuerySnowflakeRedshiftDbtFivetranGoogle Cloud PlatformCloud RunCloud SQL/PostgreSQLPub/SubCloud Scheduler

Industry Keywords

ERP IntegrationHCM PlatformsConstruction IndustryEngineering IndustryOperations-Heavy Industries

Tech Stack

Tools & technologies

Amazon RedshiftBigQueryCloudERPGoogle Cloud PlatformPostgresPythonSQL

About the role

Key responsibilities & impact

Own data pipelines, including automated replication and ingestion into the warehouse
Monitor performance, troubleshoot failures, handle schema changes, and add new data sources
Maintain and evolve cloud warehouse architecture
Define layering, naming conventions, performance standards, and cost-efficiency practices
Ensure scalability across multiple subsidiaries
Design and maintain dimensional models, including facts and dimensions
Partner with Finance, HR, and Operations leaders to translate business needs into data structures
Build models supporting accurate, decision-ready reporting
Implement testing, documentation, and data quality checks
Maintain clear data lineage and transparency
Ensure stakeholders trust reporting accuracy

Requirements

What you’ll need

Candidates must be within driving distance of Columbia, MO or Kansas City, MO and able to work in-office regularly
Strong data engineering fundamentals, including clean, maintainable SQL and Python
Experience building and operating production data pipelines
Hands-on experience with a cloud data warehouse; BigQuery preferred, with Snowflake, Redshift, or similar acceptable
Experience with transformation frameworks, especially dbt, and layered data architecture (raw → staging → modeled)
Solid understanding of dimensional modeling, including facts, dimensions, and star schema design
Experience with ELT/data replication tools such as Fivetran
Ability to translate business needs into scalable data solutions with non-technical stakeholders
Comfortable owning decisions and operating independently
Nice to have: Google Cloud Platform experience, including Cloud Run, Cloud SQL/PostgreSQL, Pub/Sub, Cloud Scheduler, and Secret Manager
Nice to have: ERP integration experience, such as Viewpoint Vista, and HCM platform experience, such as Workday
Nice to have: CI/CD-driven data workflows and version-controlled transformations
Nice to have: warehouse cost optimization experience
Nice to have: background in construction, engineering, or operations-heavy industries