Data Engineer: AEO Data Marts & Google Cloud Pipelines

Apex Systems; Lone Tree (CO); On-site; USD 52,000 - 69,000; Full time

Benefits offered by this job

Medical insurance

401K matching

ESPP

HSA

EAP services

Job summary

Apex Systems in Lone Tree, CO is seeking a hands-on Data Engineer to design and build AEO data marts and pipelines in Google Cloud. The role includes maintaining the digital marketing data mart and partnering with security, architecture, and production teams.

You will develop API integrations using Python, write complex SQL, and ensure data quality with robust monitoring. Experience with REST APIs and cloud data services is required for this onsite role.

Qualifications

• Advanced SQL skills; write complex SQL from scratch.
• Proficiency in Python for API integration and data transformation.
• Hands-on experience designing and building data pipelines and analytical models.
• Experience with GCP and cloud-based data services.
• Experience building data marts or curated analytical data products.

Responsibilities

• Design and build scalable AEO data marts and automated pipelines in GCP.
• Develop reusable API integrations and data extraction components using Python.
• Write complex SQL for data transformation and integration.
• Maintain and enhance an existing digital marketing data mart.
• Create documentation for data marts, pipelines, and datasets.

Skills

Advanced SQL

Python

Data pipelines

Google Cloud Platform

Data marts

REST API integrations

Data quality checks

Tools

dbt

DuckDB

GitHub

Job description

Apex Systems in Lone Tree, CO is seeking a hands-on Data Engineer to design and build AEO data marts and pipelines in Google Cloud. The role includes maintaining the digital marketing data mart and partnering with security, architecture, and production teams.

You will develop API integrations using Python, write complex SQL, and ensure data quality with robust monitoring. Experience with REST APIs and cloud data services is required for this onsite role.