Database Developer - Mid-Level

Charles Schwab & Co., Inc.
Lone Tree, United States of America
4 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate

Job location

Lone Tree, United States of America

Tech stack

Adobe Analytics
API
Artificial Intelligence
Data analysis
Cloud Database
Databases
Data Integration
Data Mart
Data Mining
Python
Power BI
SQL Databases
Tableau
Google Cloud Platform
Sql Optimization
Delivery Pipeline
Build Management
Data Analytics
REST
Looker Analytics
Data Pipelines
Api Management

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. This role focuses on designing and building Answer Engine Optimization (AEO) data marts and supporting data pipelines in Google Cloud Platform, as well as maintaining an existing digital marketing data mart for business intelligence and analytics.

Database Developer - Mid-Level - 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 from scratch to transform, integrate, validate, and prepare AEO data.
  • Maintain, troubleshoot, and enhance the digital marketing data mart.
  • Develop reusable datasets that support BI dashboards, recurring reporting, and ad hoc analytics.
  • Create clear technical documentation for data marts, pipelines, APIs, and analytical datasets.

Requirements

  • 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 integrating data from REST APIs or other third-party interfaces.
  • Experience building data marts or other curated analytical data products.
  • Strong technical documentation and communication skills.
  • Ability to work independently and manage priorities across multiple related initiatives.

Database Developer - Mid-Level - Nice-to-Have Skills:

  • Experience building data products for Answer Engine Optimization or related areas.
  • Experience with Adobe Analytics, clickstream data, or other event-level digital behavioral data.
  • Experience with modern analytics-engineering technologies, including dbt, dlt, and DuckDB.
  • Experience with business intelligence and analytics platforms such as Tableau, Looker, or Power BI.
  • Previous experience in financial services or another highly regulated industry.

Apply for this position