IT - Database Developer - Mid-Level

Role Overview

We are 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 a cloud environment. The role will also help maintain an existing digital marketing data mart that supports business intelligence and analytics.

Key Responsibilities

• Design and build scalable AEO data marts and automated data pipelines in Google Cloud Platform (GCP).
• Develop reusable API integrations, extraction processes, and data-transformation components using Python.
• 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.
• Maintain, troubleshoot, and enhance an existing digital marketing data mart.
• Support data models containing clickstream and web-traffic data integrated with core business information.
• Establish data-quality checks, reconciliation processes, and monitoring.
• Create clear technical documentation for data marts, pipelines, and analytical datasets.
• Collaborate with technology, security, architecture, and production-support teams.

Required Qualifications

• Professional experience in data engineering, analytics engineering, software engineering, or a related technical field.
• Advanced SQL skills, with the ability to write complex SQL from scratch.
• Proficiency in Python for API integration, data extraction, automation, and transformation.
• Hands-on experience designing and building data pipelines and analytical data models.
• Experience integrating data from REST APIs or other third-party interfaces.
• Hands-on experience with Google Cloud Platform and cloud-based data services.
• Experience building data marts or other curated analytical data products.
• Knowledge of dimensional modeling, data grain, and transformation logic.
• Experience with data-quality testing, validation, logging, and monitoring.
• Familiarity with source control and collaborative development practices.
• Strong technical documentation and communication skills.

Preferred Qualifications

• Experience building data products for Answer Engine Optimization, search analytics, or content intelligence.
• Experience working with third-party marketing or analytics vendor APIs.
• Experience with clickstream data, web-traffic data, or other event-level digital behavioral data.
• Experience integrating digital marketing data with client, account, product, or campaign information.
• Experience with modern analytics-engineering technologies, including dbt, dlt, and DuckDB.
• Working knowledge of modern AI capabilities, such as LLM-based applications and retrieval-augmented generation.
• Experience with business intelligence platforms such as Tableau, Looker, or Power BI.
• Familiarity with GitHub, pull requests, CI/CD, and DevOps practices.
• Experience using Jira or a similar work-management platform.
• Previous experience in financial services or another regulated industry.

Benefits

• Supplemental benefits including medical, dental, vision, life, disability, and other insurance plans.
• ESPP (employee stock purchase program).
• 401K program with company match after 12 months of tenure.
• HSA (Health Savings Account on the HDHP plan).
• SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions.
• Corporate discount savings program and other discounts.
• On-demand training program.
• Access to certification prep and a library of technical and leadership courses/books/seminars after 6+ months of tenure.
• Certification discounts and perks to associations including CompTIA and IIBA.
• Dedicated customer service team for consultants to address benefits and resource questions.
• Certified Career Coach.