at Actalent in Kansas City, Missouri, United States
Job Description
Data Engineer
Location: Columbia, MO or Kansas City (Onsite)
Schedule: Full-time, Monday-Friday (9-5)
About the Role
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
What We’re Looking For
Required Qualifications
+ 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
Nice-to-Have Skills
+ Experience with Google Cloud Platform (Cloud Run, Cloud SQL, Pub/Sub, Cloud Scheduler, Secret Manager)
+ Experience integrating ERP systems (e.g., Viewpoint Vista) and HCM platforms (e.g., Workday)
+ Familiarity with CI/CD pipelines and version-controlled data workflows
+ Experience optimizing data warehouse cost and performance
+ Experience in construction, engineering, or operations-driven industries
Why Join Us
+ Be an early contributor to building data and AI-driven solutions in a high-impact industry
+ Take full ownership of a modern data platform with real decision-making authority
+ Work closely with business leaders to deliver meaningful, real-world outcomes
+ Join a team focused on improving safety, efficiency, and innovation through data
Work Environment
+ Onsite, collaborative team environment in Columbia, MO or Kansas City
+ Standard business hours with a strong focus on teamwork and ownership
Job Type & Location
This is a Permanent position based out of Kansas City, MO.
Pay and Benefits
The pay range for this position is $110000.00 – $145000.00/yr.
Health, Vision, Dental, ESOP
Workplace Type
This is a fully onsite position in Kansas City,MO.
Application Deadline
This position is anticipated to close on Jun 26, 2026.
About Actalent
Actalent is a global leader in engineering and sciences services and talent solutions. We help visionary companies advance their engineering and science initiatives through access to specialized experts who drive scale, innovation and speed to market. With a network of almost 20,000 consultants and 5,000 clients across the U.S., Canada, Asia and Europe, Actalent serves many of the Fortune 500. We are proud to be an Engineering News-Record (ENR) Top 500 Design Firm for our engineering design services and a ClearlyRated Best of Staffing® winner for both client and talent service.
The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law. If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please email actalentaccommodation@actalentservices.com for other accommodation options. San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records. Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability. Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools. To view full details and how to apply, please login or create a Job Seeker account