Database Developer - Senior

job summary:
Your Opportunity

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 contract position is to design and build Answer Engine Optimization (AEO) data marts and supporting data pipelines in Google Cloud Platform. The role will also help maintain the team's existing digital marketing data mart supporting business intelligence and analytics.

This role is ideal for someone who combines strong data-engineering fundamentals with practical experience in cloud platforms, SQL, Python and APIs. The successful candidate will be able to build technical solutions while also creating documentation, collaborating with technology partners, and sharing reusable practices with the broader analytics organization.

 
location: Lone Tree, Colorado
job type: Contract
salary: $58.62 - 61.62 per hour
work hours: 8am to 5pm
education: Bachelors

responsibilities:
1. Build AEO Data Marts and Pipelines in GCP - Primary Priority

The contractor's primary responsibility will be developing the data foundation for the team's Answer Engine Optimization initiatives.

- 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.

- Manage API authentication, pagination, response processing, error handling, and logging.

- Create well-structured analytical data models that support reporting, analysis, and future AI use cases.

- Write complex SQL from scratch to transform, integrate, validate, and prepare AEO data.

- Integrate AEO vendor data with relevant digital marketing and core business datasets.

- Establish appropriate data-quality checks, reconciliation processes, and monitoring.

- Document source structures, business rules, data grain, refresh frequency, dependencies, and transformation logic.

- Partner with Client Technology Services and other internal technology teams to prepare AEO pipelines and data products for production.

- Design solutions that are maintainable, reusable, observable, and aligned with enterprise technology standards.

- Support downstream consumption of AEO data through business intelligence platforms, analytical workflows, and AI-enabled applications.

2. Maintain the Digital Marketing Data Mart for BI and Analytics - Second Priority

The third priority will be maintaining and enhancing the existing digital marketing data mart used for reporting, business intelligence, and analytics.

- Maintain, troubleshoot, and enhance the digital marketing data mart.

- Support data models containing Adobe Analytics clickstream and web-traffic data integrated with core business data.

- Write, review, troubleshoot, and optimize complex SQL from scratch.

- Develop reusable datasets that support BI dashboards, recurring reporting, and ad hoc analytics.

- Evaluate source data, joins, table grain, business rules, refresh schedules, and downstream dependencies.

- Monitor data quality and resolve completeness, consistency, performance, and refresh issues.

- Update data models as reporting and analytical requirements evolve.

- Apply established standards for table design, column naming, audit fields, retention, and technical documentation.

- Partner with BI developers and analysts to ensure datasets are understandable, trusted, and fit for purpose.

- Help improve the maintainability and scalability of existing SQL and data-processing workflows.

qualifications:
.

skills:
Adobe Analytics,APIs,API,AI-enabled,AI,design and build,cloud-based data,code reviews,CI/CD,analytical data,analytics capabilities,integrating data,logging,data marts,data mart,data extraction,data pipelines,building data pipelines,data flows,DevOps practices,data assets,dimensional modeling,GitHub Copilot,GitHub,Google Cloud Platform,Jira,LLM-based,Looker,Visual Studio Code,Power BI,Python,Proficiency in Python,REST APIs,retrieval-augmented generation,SQL,vector search,software engineering,version control,source control,Advanced SQL skills,Tableau,quality testing,traffic data,Communicate,communication skills,issue resolution,Ability to work independently,architecture,AI-assisted development,automation,automated,engineering fundamentals,behavioral data,business intelligence and analytics,business rules,change-management,presenting,demonstrations,API integration,digital marketing,data products,collaborative development,campaign,financial services,marketing,proof of concept,risks,security,Engine Optimization,exception handling,solution architecture,technical documentation,testing,creating documentation,documentation

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact View email address on us.fitly.work.




Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).

This posting is open for thirty (30) days.