Data Engineer

Job Description

Data Engineer:
On behalf of our technology client, Procom is searching for a Data Engineer for a contract role. This position is a hybrid position with 4 days onsite at our client’s Lone Tree office.

Job Description:
The Intelligent Planning and Analytics team is seeking a hands-on Data Engineer to support the development of modern data products and AI-enabled analytics capabilities. The primary focus of this position is to design and build Answer Engine Optimization (AEO) data marts and supporting data pipelines in Google Cloud Platform.

Responsibilities:
• Design and build scalable AEO data marts in Google Cloud Platform.
• Develop automated pipelines that ingest data from third-party AEO vendor APIs.
• Use Python to build reusable API integrations, extraction processes, and data-transformation components.
• Write complex SQL to transform, integrate, validate, and prepare AEO data.
• Maintain and enhance the digital marketing data mart for reporting and analytics.
• Create well-structured analytical data models supporting reporting, analysis, and AI use cases.
• Document source structures, business rules, data grain, refresh frequency, dependencies, and transformation logic.

Mandatory Skills:
• Advanced SQL skills, including the ability to write complex SQL from scratch.
• Proficiency in Python for API integration, data extraction, automation, and transformation.
• Hands-on experience with Google Cloud Platform and cloud-based data services.
• Experience designing and building data pipelines and analytical data models.
• Experience integrating data from REST APIs or other third-party interfaces.
• Strong technical documentation and communication skills.
• Ability to work independently and manage priorities across multiple related initiatives.

Nice-to-Have Skills:
• Experience building data products for Answer Engine Optimization or related areas.
• Experience working with third-party marketing or analytics vendor APIs.
• Experience with Adobe Analytics, clickstream data, or web-traffic data.
• Experience developing AI agents from proof of concept into production.
• Familiarity with GitHub, pull requests, code reviews, CI/CD, and DevOps practices.

Assignment Length:
This is a contract position.

Start Date:
ASAP.

Assignment Location:
Lone Tree, Colorado, United States. This position is hybrid with 4 days in office.