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
- 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
- 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
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)
Skills Required
- Strong data engineering fundamentals, including clean and maintainable SQL and Python
- Experience building and operating production data pipelines
- Hands-on experience with a cloud data warehouse such as BigQuery, Snowflake, or Redshift
- Experience with transformation frameworks, preferably dbt, and layered data architecture
- Understanding of dimensional modeling, facts, dimensions, and star schema design
- Experience with ELT or data replication tools such as Fivetran
- Ability to partner with non-technical stakeholders and translate business needs into scalable data solutions
- Ability to own technical decisions and work independently
- Experience with Google Cloud Platform, including Cloud Run, Cloud SQL or PostgreSQL, Pub/Sub, Cloud Scheduler, and Secret Manager
- Experience integrating ERP systems such as Viewpoint Vista and HCM platforms such as Workday
- Familiarity with CI/CD-driven data workflows and version-controlled transformations
- Experience managing data warehouse cost optimization
- Background in construction, engineering, or operations-heavy industries
- Must be located within driving distance of Columbia, Missouri, or Kansas City, Missouri, and work on-site regularly
What We Do
Emery Sapp & Sons is a 100% employee-owned heavy civil contractor specializing in infrastructure projects such as excavation, grading, underground utilities, and bridge construction.
