What are the responsibilities and job description for the Cloud Data Platform Engineer position at Charles Schwab?
Your opportunity
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.
This role sits directly within SAM Data team, the team responsible for designing, building, operating, and enhancing SAM Data products , platform capabilities underpinning SAM Data platform.
About The Role
The SAMDA Data Engineering team builds and enhances cloud‑native data pipelines and data‑platform capabilities that support Schwab Asset Management’s analytical, operational, and regulatory data needs. As a Sr. Specialist (Level 56), you will take on expanded ownership of data pipeline design, cloud data engineering patterns, and the development of scalable data solutions across Snowflake and Google Cloud Platform (GCP).
Engineers at this level operate with greater independence, take lead roles in technical problem‑solving, and contribute to shaping best practices for data engineering within SAMDA.
What You Will Do (Responsibilities)
Design & Build Investment Data Pipelines
Required Qualifications
At Schwab, you’re empowered to shape your future. We champion your growth through meaningful work, continuous learning, and a culture of trust and collaboration—so you can build the skills to make a lasting impact. Our Hybrid Work and Flexibility approach balances our ongoing commitment to workplace flexibility, serving our clients, and our strong belief in the value of being together in person on a regular basis.
We offer a competitive benefits package that takes care of the whole you – both today and in the future:
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.
This role sits directly within SAM Data team, the team responsible for designing, building, operating, and enhancing SAM Data products , platform capabilities underpinning SAM Data platform.
About The Role
The SAMDA Data Engineering team builds and enhances cloud‑native data pipelines and data‑platform capabilities that support Schwab Asset Management’s analytical, operational, and regulatory data needs. As a Sr. Specialist (Level 56), you will take on expanded ownership of data pipeline design, cloud data engineering patterns, and the development of scalable data solutions across Snowflake and Google Cloud Platform (GCP).
Engineers at this level operate with greater independence, take lead roles in technical problem‑solving, and contribute to shaping best practices for data engineering within SAMDA.
What You Will Do (Responsibilities)
Design & Build Investment Data Pipelines
- Design, develop, and optimize investment data pipelines using ETL/ELT patterns.
- Integrate data from custodians, vendors, and internal platforms into curated datasets.
- Build reliable workflows using GCS, Dataproc, Cloud Dataflow, Composer (Airflow), and Pub/Sub.
- Implement scalable transformations in Snowflake and other cloud data warehouses.
- Design portfolio, transaction, pricing, and performance data models aligned to investment use cases.
- Apply Kimball/star schema patterns and domain‑driven modeling for analytics and reporting.
- Optimize schemas for API consumption, dashboards, and quantitative analysis.
- Design and implement Investment Data APIs using Python
- Expose curated investment datasets (holdings, performance, risk metrics) via secure REST endpoints.
- Enable programmatic access for portfolio managers, analysts, and downstream applications.
- Apply authentication, authorization, and data‑entitlement controls consistent with regulated investment data.
- Build Python‑based dashboards and UI applications (Streamlit, Dash, Panel).
- Create interactive visualizations for portfolio views, performance trends, and risk insights using Plotly, Matplotlib, and Seaborn.
- Translate complex investment datasets into intuitive, self‑service analytical experiences.
- Optimize dashboard performance for large portfolios and time‑series data.
- Build data and application services using Cloud Run, Cloud Functions, and Cloud SQL.
- Apply distributed processing frameworks (Apache Spark, Beam, Flink) for large‑scale investment datasets.
- Package and deploy APIs and dashboards using Docker.
- Own CI/CD pipelines for data pipelines, investment data APIs, and Python UI applications.
- Use Git/Bitbucket/Bamboo, Jenkins, GitHub Actions, Maven, Nexus for build and release automation.
- Implement data quality checks specific to investment data (reconciliation, completeness, timeliness).
- Monitor pipelines, APIs, and dashboards to ensure reliable delivery of investment insights.
- Troubleshoot complex data issues impacting portfolio, performance, or risk reporting.
- Partner closely with Investment, Portfolio Management, Risk, and Operations teams.
- Provide mentorship and technical guidance to junior engineers.
- Clearly communicate investment data concepts to technical and non‑technical stakeholders.
Required Qualifications
- Bachelor’s degree in Computer Science, Information Technology, or equivalent experience.
- 3–5 years of experience building cloud‑based investment or financial data platforms.
- Hands‑on experience with Snowflake and GCP services (GCS, Cloud Run, Cloud Functions, Pub/Sub, Composer, Cloud SQL).
- Strong Python skills for data engineering, API development, and visualization.
- Experience building REST APIs using FastAPI, Flask, or similar frameworks.
- Experience building Python dashboards/UI (Streamlit, Dash, Panel).
- Experience with distributed processing frameworks (Spark, Beam, or Flink).
- Proficiency with CI/CD, Docker, and IaC (Terraform or GCP Deployment Manager).
- Experience with investment management data (portfolios, performance, risk, pricing).
- Familiarity with custodians, portfolio accounting, or market data vendors.
- Knowledge of data governance, entitlements, and controls in regulated investment environments.
- Ability to lead cross‑functional investment data initiatives.
- Strong documentation and communication skills.
At Schwab, you’re empowered to shape your future. We champion your growth through meaningful work, continuous learning, and a culture of trust and collaboration—so you can build the skills to make a lasting impact. Our Hybrid Work and Flexibility approach balances our ongoing commitment to workplace flexibility, serving our clients, and our strong belief in the value of being together in person on a regular basis.
We offer a competitive benefits package that takes care of the whole you – both today and in the future:
- 401(k) with company match and Employee stock purchase plan
- Paid time for vacation, volunteering, and 28-day sabbatical after every 5 years of service for eligible positions
- Paid parental leave and family building benefits
- Tuition reimbursement
- Health, dental, and vision insurance