Data Engineer

Actalent
Kansas City, United States of America
6 days ago

Role details

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

Job location

Kansas City, United States of America

Tech stack

Sql Data Warehouse
Computing Platforms
Google BigQuery
Data Architecture
Data Validation
Information Engineering
Data Infrastructure
Data Structures
Data Systems
Dimensional Modeling
Python
Performance Tuning
SQL Databases
Data Ingestion
Snowflake
Data Lineage
Star Schema
Data Pipelines

Job description

We are seeking a highly motivated Data Engineer to take ownership of a growing data platform within an innovative, engineering-focused organization. This is a unique opportunity to step into a high-impact role where you will design, build, and scale modern data infrastructure from the ground up. This position offers significant autonomy-ideal for someone who thrives in an environment where they can make decisions, take initiative, and directly influence the future of data architecture and analytics.

What You'll Do

Own the Data Pipelines

  • Manage automated data ingestion and replication into the cloud data warehouse

  • Monitor pipeline performance, troubleshoot issues, and handle schema evolution

  • Integrate new data sources as business needs grow

Own the Platform Architecture

  • Design, maintain, and evolve cloud-based data warehouse architecture

  • Establish best practices for data layering (raw staging modeled), naming conventions, and performance optimization

  • Ensure scalability across multiple business units

Own the Data Modeling

  • Design and maintain dimensional models (fact and dimension tables, star schemas)

  • Partner with Finance, HR, and Operations stakeholders to translate business requirements into scalable data solutions

  • Deliver high-quality data structures that support accurate, decision-ready reporting

Ensure Data Trust & Reliability

  • Implement data quality checks, testing, and validation frameworks

  • Maintain clear documentation and data lineage

  • Ensure stakeholders have confidence in reporting accuracy

Requirements

  • Strong data engineering fundamentals, including SQL and Python

  • Experience building and maintaining production-grade data pipelines

  • Hands-on experience with a cloud data warehouse (BigQuery preferred; Snowflake, Redshift, or similar acceptable)

  • Experience with dbt or similar transformation frameworks

  • Understanding of layered data architectures (raw, staging, modeled)

  • Knowledge of dimensional modeling and star schema design

  • Experience with ELT/replication tools (e.g., Fivetran or similar)

  • Ability to collaborate with non-technical stakeholders and translate business needs into data solutions

  • Comfortable working independently and owning technical decisions

Apply for this position