Database Developer - Mid-Level

Charles Schwab & Co., Inc.

Lone Tree, CO, United States

6 days ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Working hours

Regular working hours

Job source

portal.procomservices.com

Tech stack

Adobe Analytics Application Programming Interfaces (APIs) Artificial Intelligence Data Analysis Cloud Database Databases Data Integration Data Mart Data Mining Python (Programming Language) Power BI SQL Databases

+10 more

Tableau (Software) Google Cloud Sql Optimization Delivery Pipeline Build Management Data Analytics Restful APIs 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.