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
