Data Engineering

Responsibilities

• 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.
• 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 wareho

Additional Information

Pay range: USD $91,800.00 - $204,100.00 / Year 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.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at Charles Schwab? Share your experience