GCP Data Engineer — AEO Data Marts & Pipelines

Spectraforce Technologies; Lone Tree (CO); On-site; USD 83,000 - 152,000; Full time

Job summary

Spectraforce Technologies is seeking a hands-on Data Engineer to design and build AEO data marts and data pipelines in Google Cloud Platform for Intelligent Planning and Analytics. The role emphasizes SQL, Python, APIs, and producing maintainable, well-documented data products.

The contract position supports BI and analytics with a focus on data quality, automation, and collaboration with internal technology teams. Onsite work in Lone Tree, CO is required.

Qualifications

• Hands-on data engineering with advanced SQL and Python.
• Experience building data marts, pipelines, and models in GCP.
• Proficient in API integration and data extraction workflows.
• Ability to document architectures and data rules clearly.
• Experience with data quality, logging, and monitoring.
• Familiar with version control and collaborative development.

Responsibilities

• Build AEO data marts and pipelines in Google Cloud Platform.
• Develop automated pipelines ingesting data from third-party APIs.
• Use Python for API integrations and ETL components.
• Write complex SQL to transform and join data across datasets.
• Ensure data quality, reconciliation, and monitoring.
• Document source structures, rules, and transformation logic.
• Collaborate with technology partners to productionize pipelines.
• Support BI, analytics, and AI-enabled applications downstream.

Skills

Advanced SQL

Python

Data pipelines

Google Cloud Platform

APIs integration

Data modeling

Data quality/testing

Version control

Documentation

Communication

Independent work

Tools

dbt

DuckDB

DLT

GitHub Copilot

Job description

Spectraforce Technologies is seeking a hands-on Data Engineer to design and build AEO data marts and data pipelines in Google Cloud Platform for Intelligent Planning and Analytics. The role emphasizes SQL, Python, APIs, and producing maintainable, well-documented data products.

The contract position supports BI and analytics with a focus on data quality, automation, and collaboration with internal technology teams. Onsite work in Lone Tree, CO is required.