Data Engineering Lead

Charles Schwab

Chicago, IL

JOB DETAILS
SKILLS
Access Control, Amazon Web Services (AWS), Apache, Apache Spark, Application Programming Interface (API), Architectural Analysis, Architectural Services, Artificial Intelligence (AI), Asset Management, Benchmarking, Business Intelligence, Cloud Computing, Code Reviews, Computer Science, Contract Management, Data Analysis, Data Management, Data Modeling, Data Quality, Data Sets, Data Warehousing, Database Extract Transform and Load (ETL), Ecosystems, Finance, GCP (Good Clinical Practices), Hubs, Integrated Circuits (ICs), Investment Management, Knowledge Modeling, Machine Learning, Mentoring, Metadata, Metrics, Mutual Funds, Operational Support, Performance Tuning/Optimization, Problem Solving Skills, Product Management, Python Programming/Scripting Language, Quality Metrics, Reconciliation, Regulations, Regulatory Compliance, SQL (Structured Query Language), Scalable System Development, Securities, Service Level Agreement (SLA), Snowflake Schema, Software Engineering, Technical Leadership, Technical/Engineering Design, Training Data Sets, Use Cases
LOCATION
Chicago, IL
POSTED
1 day ago

At Schwab, you’re empowered to make an impact on your career. Here, innovative thought meets creative problem solving, helping us “challenge the status quo” and transform the finance industry together.

Schwab Asset Management (SAM) is a leading asset manager supporting mutual funds, ETFs, and managed account products governed under stringent regulatory and compliance requirements. SAM operates in a multi-cloud, multi-custodian, multi-vendor ecosystem, relying on a diverse set of external platforms such as Vestmark, Aladdin, Eagle, and others to serve its investment, operational, and regulatory functions.

We are seeking a Lead Data Engineer to drive the design and development of the cloud-native Data Platform for Schwab Asset Management (SAM). In this role, you will design and deliver end-to-end data solutions, not just pipelines—spanning raw data ingestion, curated data layers, enterprise data hubs, and the APIs and services that power downstream applications and analytics. You will work across a modern cloud data stack built on Snowflake and Google Cloud Platform (GCP to build scalable, resilient, and reusable platform capabilities.

Key Responsibilities:

Cloud-Native Data Engineering & Data Warehousing

• Design, build, and operate cloud-native data pipelines using GCP and/or AWS.

• Lead development of scalable ELT/ETL workflows supporting investment, operational, regulatory, and analytics use cases.

• Serve as a Snowflake subject-matter expert, designing advanced data models, transformations, and performance-optimized workloads.

• Engineer and curate data within cloud data warehouses and cloud-native data platforms, ensuring data is analytics-ready and AI-ready.

• Design data hubs and domain data products that serve as authoritative sources for shared datasets, reducing duplication and ensuring consistent enterprise-wide data usage.

• Optimize data solutions for performance, scalability, reliability, and cost efficiency.

Modern Data Architecture

• Design and implement medallion data architectures (Bronze / Silver / Gold).

• Build and evolve semantic data layers that provide consistent, reusable business metrics.

• Design and curate AI-ready datasets to support advanced analytics, machine learning, and generative-AI use cases.

• Leverage Snowflake’s AI capabilities, including Snowflake Cortex and native Snowflake AI solutions, as part of the modern data architecture to enable intelligent data access, enrichment, and downstream AI workflows.

• Ensure architectural alignment between curated data, semantic layers, and AI-enabled consumption patterns.

Data Modeling, Quality & Governance (Investment Domain Focus)

• Lead complex data-modeling efforts across investment domains, including holdings, positions, transactions, securities, portfolios, benchmarks, performance, and reference data.

• Apply investment domain knowledge to ensure models accurately represent real-world investment behavior and lifecycle events.

• Define, implement, and enforce data quality standards, including validation rules, completeness checks, reconciliations, and anomaly detection.

• Apply data governance principles, including metadata management, lineage, access controls, and policy enforcement.

• Design and implement data contracts to define schema expectations, ownership, SLAs, and change-management between data producers and consumers.

Technical Leadership (IC Role)

• Act as a technical lead for complex data-engineering initiatives and investment-domain data products.

• Drive architecture discussions, design reviews, and technical decision-making.

• Mentor junior and mid-level engineers through code reviews and technical guidance.

• Partner closely with platform engineering, architecture, analytics, and business stakeholders.

What you have

Required Qualifications:

• Bachelor’s degree in computer science, Engineering, or related field (or equivalent practical experience).

• 6–8+ years of experience in cloud-native data engineering.

• Strong experience working on modern cloud data stacks using GCP and/or AWS.

• Deep, hands-on experience with cloud data warehouses (Snowflake preferred) and Apache Spark based data pipeline development

• Strong experience in data pipeline orchestration leveraging platforms like Apache Airflow

• Proven experience designing and delivering:

• Medallion data architectures

• Semantic data layers

• Analytics-ready and AI-ready datasets

• Expert-level SQL and strong Python skills.

• Ability to operate independently and lead technically without formal authority.

Preferred Qualifications:

• Hands-on experience modeling investment data domains and building curated Investments data products for consumption across Investments management business functions.

• Designing and enforcing data quality frameworks at scale.

• Implementing data governance capabilities, including metadata, lineage, and controlled access.

• Defining and managing data contracts between upstream producers and downstream consumers.

• Supporting analytics, BI, and AI / ML workloads.

• Acting as a technical lead on complex data initiatives.

About the Company

C

Charles Schwab

The Charles Schwab Corporation is a leading provider of financial services, with more than 300 offices. Through its operating subsidiaries, the company provides a full range of securities brokerage, banking, money management and financial advisory services to individual investors and independent investment advisors. Named "Highest in Investor Satisfaction with Self-Directed Services" by J.D. Power and Associates in 2009, its broker-dealer subsidiary, Charles Schwab & Co., Inc. (member SIPC) affiliates offer a complete range of investment services and products including an extensive selection of mutual funds; financial planning and investment advice; retirement plan and equity compensation plan services; referrals to independent fee-based investment advisors; and custodial, operational and trading support for independent, fee-based investment advisors through Schwab Advisor Services.

The Charles Schwab Bank (member FDIC) provides banking and mortgage services and products. To meet the needs of our clients, we are actively recruiting people with the desire, drive and creativity to find solutions that help meet our clients' needs; who want the chance to learn, grow with the company and explore their career opportunities; who will strive for excellence in achieving our clients' and our company's goals; who have the highest ethical standards - individuals who take pride in making a difference in people's lives.
COMPANY SIZE
1,000 to 1,499 employees
INDUSTRY
Security and Surveillance
FOUNDED
1971
WEBSITE
http://www.aboutschwab.com/careers