Data Engineer

CareerCircle
Columbia, United States of America
2 days ago

Role details

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

Job location

Columbia, United States of America

Tech stack

Sql Data Warehouse
Artificial Intelligence
Computing Platforms
Google BigQuery
Cloud Computing
Cloud Database
Continuous Integration
Data Architecture
Data Validation
Information Engineering
Data Infrastructure
Data Structures
Data Systems
Data Warehousing
Dimensional Modeling
Python
PostgreSQL
Operational Databases
Performance Tuning
Salesforce
SQL Databases
Systems Integration
Google Cloud Platform
Data Ingestion
Snowflake
Data Lineage
Star Schema
Data Pipelines
Workday
Redshift

Job description

Workday (Software) Naming Conventions Data Infrastructure Dimensional Modeling Business Requirements Artificial Intelligence Construction Engineering SQL (Programming Language) Engineering Design Process Snowflake (Data Warehouse) Google Cloud Platform (GCP) Influencing Without Authority Troubleshooting (Problem Solving), 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, * 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, 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. Related Jobs Data Engineer Actalent Kansas City, MO*On-Site CI/CD Finance BigQuery Visionary Pipelines Operations Automation Innovation PostgreSQL Warehousing Scalability Star Schema Data Quality Data Lineage Cloud Computing Amazon Redshift Data Warehousing Data Engineering Inventory Staging Data Architecture Publish Subscribe Workday (Software) Naming Conventions Workflow Management Dimensional Modeling Operational Databases Artificial Intelligence Construction Engineering SQL (Programming Language) Engineering Design Process Snowflake (Data Warehouse) Google Cloud Platform (GCP) Enterprise Resource Planning Troubleshooting (Problem Solving) +0

Salesforce Developer Data Engineer Actalent Kansas City, MO*On-Site CI/CD Finance Teamwork BigQuery Visionary Pipelines Operations Automation Innovation Scalability Proactivity Star Schema Data Quality Collaboration Data Ingestion Self-Motivation Data Structures Decision Making Amazon Redshift Data Warehousing Data Engineering Inventory Staging Data Architecture Publish Subscribe Influencing Skills Workday (Software) Naming Conventions Data Infrastructure Dimensional Modeling Business Requirements Artificial Intelligence Construction Engineering SQL (Programming Language) Engineering Design Process Snowflake (Data Warehouse) Google Cloud Platform (GCP) Influencing Without Authority Troubleshooting (Problem Solving) +0

Requirements

Finance Teamwork BigQuery Visionary Pipelines Operations Automation Innovation Scalability Proactivity Star Schema Data Quality Collaboration Data Ingestion Self-Motivation Data Structures Decision Making Amazon Redshift Data Warehousing Data Engineering Inventory Staging Data Architecture, * 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

About the company

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.

Apply for this position