Data Engineer

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

• 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

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.