Senior Data Engineer

Job TitleThis 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.Job DescriptionIt'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 DoOwn the data pipelinesManage automated replication and ingestion into the warehouseMonitor performance, troubleshoot failures, and handle schema changesAdd new data sources as business needs evolveOwn the platform architectureMaintain and evolve the cloud warehouse architectureDefine layering, naming conventions, performance standards, and cost efficiencyEnsure scalability across multiple subsidiariesOwn the data modelingDesign and maintain dimensional models (facts and dimensions)Partner directly with Finance, HR, and Operations leaders to translate business needs into data structuresBuild models that support accurate, decision-ready reportingEnsure data trust and reliabilityBuild in testing, documentation, and data quality checksMaintain clear data lineage and transparencyEnsure stakeholders trust the accuracy of reportingWhat We're Looking ForStrong data engineering fundamentals — clean, maintainable SQL and PythonExperience building and operating production data pipelinesHands-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 solutionsComfortable owning decisions and operating independentlyNice To HaveExperience 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 transformationsExperience managing warehouse cost optimizationBackground in construction, engineering, or operations-heavy industriesRemindersThis is strictly an on-site roleMust be located within driving distance of Columbia, MO or Kansas City, MONo remote or hybrid work options availableWho Thrives HereThe 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 DisabilitiesThe 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)