at Actalent in Kansas City, Missouri, United States
Job Description
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
What we’re looking for
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 industriesSkills
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
Additional Skills & Qualifications
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
Experience Level
Expert Level
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