Data Engineer

Actalent
Overland Park, United States of America
7 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Overland Park, United States of America

Tech stack

Sql Data Warehouse
Google BigQuery
Cloud Computing
Cloud Database
Continuous Integration
Data Architecture
Information Engineering
Data Structures
Dimensional Modeling
Python
PostgreSQL
Microsoft SQL Server
Operational Databases
SQL Databases
Systems Integration
Google Cloud Platform
Snowflake
Data Lineage
Google Cloud Functions
Performance Monitor
Star Schema
Database Replication
Data Pipelines
Workday
Redshift

Job 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

Requirements

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 Experience in construction, engineering, or operations-heavy industries

Skills

sql server, bigquery, cloud computing, ci/cd pipelines, erp system, Cloud Run, Cloud SQL, Snowflake, Redshift, data replication

Top Skills Details

sql server,bigquery,cloud computing

Apply for this position