> Markdown version of [/jobs/ext/1818709-senior-data-engineer](https://www.wearedevelopers.com/jobs/ext/1818709-senior-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Data Engineer - **Company:** Ess Inc - **Location:** Columbia, MO, United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Sql Data Warehouse, BigQuery, Cloud Computing, Continuous Integration, Data Architecture, Data Validation, Information Engineering, Data Structures, Dimensional Modeling, Python (Programming Language), PostgreSQL, Operational Databases, SQL Databases, Systems Integration, Google Cloud, Snowflake, Data Lineage, Performance Monitor, Star Schema, Database Replication, Data Pipelines, Workday - **Published:** July 4, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=fd62b8e1edffefb2 ## About the Role * 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 ## Description 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 ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Destigmatizing the Workplace: Building Real Inclusion](https://www.wearedevelopers.com/videos/1492-destigmatizing-the-workplace-building-real-inclusion) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)