Data Engineering

The Charles Schwab Corporation; Westlake (TX); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

401(k) match

PTO + volunteering

Sabbatical after 5 years of service

Parental leave

Tuition reimbursement

Health, dental, and vision insurance

Job summary

Schwab Advisor Services, a division of The Charles Schwab Corporation, is seeking a hands-on Data Engineer to build scalable data pipelines and data marts that power reporting and analytics for RIAs. You will collaborate with business and tech teams to translate requirements into robust data solutions and help shape a future-state data platform.

The role emphasizes data quality, reliability, and operational excellence, with opportunities to lead engineering practices, monitor jobs, and optimize

Qualifications

• Expertise in ETL/ELT development and data engineering best practices.
• Strong understanding of data pipelines, data mart design, and warehousing concepts.
• Experience with Google Cloud technologies, BigQuery and Cloud Storage.
• Business analysis to translate requirements into data mappings and metrics.
• Minimum of 3 years hands-on data engineering experience.
• Knowledge of metadata management, governance, and data retention strategies.

Responsibilities

• Build and maintain data mart solutions for reporting and analytics use cases.
• Design end-to-end data pipelines for ingesting and transforming large data volumes.
• Develop dimensional data models and manage slowly changing dimensions.
• Define data retention/history strategies balancing analytical value and performance.
• Implement data quality controls, testing, and monitoring.
• Provide production support and deployment artifacts.
• Collaborate with stakeholders to translate needs into scalable technical solutions.
• Lead data pipeline development and promote engineering best practices.
• Navigate cross-functional communication to maintain alignment.
• Identify risks and enforce data governance and metadata management.

Skills

ETL/ELT development

SQL

Data pipelines design

Data quality

Testing & monitoring

Cross-functional collaboration

Communication

Python

Power BI

Tableau

Financial services experience

AI in development

Version control

Education

Bachelor’s or Master’s in Computer Science, IT, or related field

Tools

BigQuery

Cloud Storage

Job description

Your Opportunity

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.

We believe in the importance of in-office collaboration and fully intend for the selected candidate for this role to work on site in the specified location(s).

Schwab Advisor Services, a division of Charles Schwab & Co., Inc. is the leading provider of custody, trading, technology, and practice management to registered investment advisors (RIAs). Schwab Advisor Services serves over 16,000 independent advisory firms who custody over $5 trillion of assets with Schwab.

This individual will be a part of the Offer Development, Delivery and Analytics department within Advisor Services. Specific to the analytics function, the department delivers data-driven insights and enables accountability through the tracking and reporting of key metrics.

What you will do:

Success in this role means delivering reliable, scalable data solutions that enable timely decision-making, while proactively improving data quality, platform performance, and engineering practices.

The Manager, Data Engineering is an individual contributor role. This role supports the creation, maintenance, and operational support of business-unit data assets, data mart solutions, reporting, and analytics that enable business leaders to make decisions and drive continuous process improvement. The role works across business and technical teams to define requirements, metric logic, and data definitions; develop and troubleshoot ETL/ELT logic using SQL and team tooling; complete testing; and provide ongoing maintenance and operational support for code, workflows, and utilities, including job monitoring, issue resolution, and user support.

We’re looking for a hands‑on data engineer with strong technical and business acumen who performs well in a structured, fast‑paced environment and is passionate about building high‑quality, high‑performance, and scalable solutions. This role is well suited for someone who is motivated to learn and understand corporate systems, reinforce engineering best practices, streamline existing processes, and contribute to a future‑state data platform that improves client‑centricity, speed to market, scale, and efficiency. The ideal candidate is comfortable creating structure, working through ambiguity, and adapting to change.

Responsibilities include:

Data Engineering & Architecture

• Build and maintain data mart solutions that support reporting and analytics use cases.
• Design, implement, and optimize end‑to‑end data pipelines for ingesting, processing, and transforming large volumes of structured and unstructured data. Develop and troubleshoot ETL/ELT logic using SQL and team tooling.
• Design and build dimensional data models, including facts and dimensions, determine appropriate table grain, and implement slowly changing dimensions where historical tracking is required.
• Define and implement practical data retention and history strategies that preserve analytical value without overloading downstream reporting tools.

Data Quality, Reliability & Operations

• Implement and maintain data quality controls, reconciliation checks, testing, and monitoring to ensure data accuracy, consistency, and reliability.
• Support production reliability through job monitoring, issue resolution, root‑cause analysis, operational support, and documentation.
• Create and maintain production support and deployment artifacts.

Collaboration & Delivery

• Collaborate with business stakeholders and technical teams to translate business needs into scalable technical solutions, including metric logic, and data definitions.
• Work closely with development partners, product owners, and team members to design features, decompose stories, and prioritize delivery.
• Share technical knowledge and support team success through collaboration, documentation, and guidance.

Leadership & Influence

• Provide technical leadership for data pipeline development and engineering practices.
• Navigate cross‑functional communication effectively to maintain alignment across teams.
• Use data‑driven reasoning to constructively challenge decisions, align on outcomes, and execute once direction is set.

Risk, Governance, & Continuous Improvement

• Identify technology risks and dependencies early and help establish mitigation plans.
• Implement data security, governance, and metadata management practices to protect sensitive information.
• Contribute to a culture of open feedback, accountability, and continuous improvement.

What you have

Required Qualifications:

• Expertise in ETL/ELT development, SQL, and data engineering best quality practices including data quality, testing, monitoring, and exception handling.
• Strong understanding of data pipelines, data mart design, and common engineering patterns.
• Strong understanding of data warehouse concepts, including star schema, fact and dimension modeling, table grain, slowly changing dimensions, and operational data stores.
• Experience with Google Cloud technologies, including BigQuery and Cloud Storage.
• Business analysis experience to translate business requirements into data mappings, metric logic, and data definitions, and to perform data analysis.
• Minimum of 3 years of hands‑on data engineering experience.
• Solid understanding of the data lifecycle, metadata management, and governance standards.
• Ability to recommend practical data retention and history strategies that balance analytical value with reporting performance.
• Strong cross‑functional collaboration skills with leadership, colleagues, and stakeholders.
• Strong communication and stakeholder management skills across technical and non‑technical audiences.
• Willingness to learn new skills and adapt to evolving technologies to meet future business needs.
• Proficiency with development tools including version control (for example, GitHub), project management software (for example, JIRA), and orchestration tools (for example, Control‑M, SQL Server Integration Services, Informatica, or similar).
• Bachelor’s or master’s degree in computer science, information technology, or a related field, or equivalent practical experience.

Preferred Competencies:

• 5+ years of experience with reporting and data visualization tools (Power BI, Tableau)
• 5+ years of experience with data management tools and coding languages (Python)
• 3+ years of experience in the financial services industry and/or a B2B environment
• Experience leveraging AI in development lifecycle, and enabling AI‑ready data environments

What’s in it for you

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