CareerPlan

Lead Data Warehouse Engineer

Los Angeles, California, USFull-time$140k–$199k2026-11-03 → 2026-11-19
Hybrid · United StatesNo visa sponsorship

Core

Architecting and maintaining Operational data stores, Enterprise Data Warehouse, data lakes, and data marts while designing performance data movement pipelines for large-scale cloud data platforms.

Role type

Senior Lead Data Warehouse Engineer

Builds

Next-gen cloud hosted data platform, ETL pipelines, data intelligence environments

Domain

Financial Technology / Cloud Data Engineering

Required skills

Cloud data warehouse platforms (Azure/AWS Databricks, Redshift, Snowflake), Informatica IDMC, Relational DBs (SQL Server, PostgreSQL, Oracle), Python/Unix Shell scripting, OLAP data modeling, Performance tuning, Distributed systems design

Preferred skills

Financial technology domain knowledge, NoSQL DBs (MongoDB, Cassandra, Azure Cosmos DB), Cloud certifications

Technologies

Informatica, Databricks, Apache Kafka, Azure Event Hub, SQL Packages, MS SQL Server, PostgreSQL, Oracle, Python, Unix Shell

Responsibilities

Architecting and maintaining ODS, EDW, data lakes, and data marts; Designing and implementing performance data movement pipelines using ETL tools; Developing scalable frameworks for structured and semi-structured data ingestion; Gathering business requirements and translating them into logical and physical data models; Conducting design reviews and communicating artifacts with stakeholders; Creating source to Target data mappings; Optimizing database features for performance and scalability; Delivering proofs of concept to stakeholders; Leading Master Data Management, Data Quality & Data Governance initiatives; Resolving critical production issues and errors.

Seniority

Senior, hands-on IC with leadership responsibilities