Data Reporting Analyst Client Integration

Charles Schwab; Westlake (TX); On-site; USD 95,000 - 125,000; Full time

Benefits offered by this job

401(k) with company match and Employee

Stock purchase plan

Job summary

Charles Schwab in Westlake, TX is seeking a hands-on Business Systems Analyst to bridge business and technology teams. You will gather requirements, design data-driven solutions, and support testing and production releases in an Agile environment.

Responsibilities include extracting and reconciling data with SQL, Excel, and Power BI; creating documentation and dashboards; collaborating with clients, vendors, and stakeholders to deliver actionable insights and reliable interfaces.

Qualifications

• 3+ years of business analysis experience, including requirements gathering and process analysis.
• 3+ years of experience monitoring file transmissions, interfaces, or data exchanges.
• 2+ years in an Agile environment with experience using JIRA or similar tools.
• 3+ years of data analytics, BI, or data management including extracting, cleansing, and reconciling data.
• Ability to learn complex systems, think logically, and manage multiple priorities in a fast-paced setting.
• Excellent written, verbal, organizational, and cross-functional collaboration skills.

Responsibilities

• Serve in a client-facing capacity, partnering with clients, technology teams, vendors, and stakeholders.
• Facilitate meetings, requirements discussions, and presentations; communicate needs, risks, issues, status, and recommendations.
• Create and maintain business and technical documentation such as requirements, flows, procedures, tests, and production support materials.
• Work in an Agile environment with backlog refinement, sprints, testing, demos, and release readiness.
• Monitor file transmissions and system interfaces; investigate data or processing issues and coordinate resolutions.
• Support testing and production releases, including functional, integration, and regression testing.

Skills

SQL

Excel

Power BI

Python

R

Alteryx

JIRA

Agile

Data analytics

Data visualization

Education

Bachelor's degree in a relevant field

Tools

Tableau

Snowflake

Databricks

Relational databases

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.

Applicants must be authorized to work in the United States on a full-time basis without employer sponsorship, now or in the future.

We believe in the importance of in-office collaboration and fully intend for the selected candidate to work on site 4 days per week in one of the specified locations.

Personal Choice Investment Services (PCIS), within Workplace Services (WS), provides the industry-leading Personal Choice Retirement Account (PCRA) and Health Savings Brokerage Account (HSBA), and is growing rapidly by serving Schwab Retirement Plan Services and the broader retirement and health savings industries.

PCIS aims to deliver competitive products and services to its intermediaries, which requires a strong understanding of the retirement market and our clients’ business needs. The Digital Product Management team onboards new PCRA and Health Savings Account (HSA) clients onto Schwab’s Brokerage platform and handles data analytics and production support.

You will be comfortable working across business and technology teams to facilitate discussions with internal and external clients, analyze data and trends, monitor file transmissions and interfaces, document requirements and processes, and support testing and production releases.

Business Systems Analysis responsibilities

• Serve in a client-facing capacity, partnering with clients, technology teams, vendors, and stakeholders.
• Facilitate meetings, requirements discussions, and presentations, communicating needs, risks, issues, status, and recommendations.
• Create and maintain business and technical documentation, such as requirements, process flows, procedures, test artifacts, and production support materials.
• Work effectively within an Agile environment, supporting requirements, backlog refinement, sprints, testing, demos, and release readiness.
• Monitor file transmissions and system interfaces, investigate data or processing issues, and coordinate resolution across teams.
• Support testing and production releases, including functional, integration, regression, and production validation, while managing multiple priorities and deadlines.

Data Analysis responsibilities

• Extract and consolidate data from multiple sources for analysis, reconciliation, investigation, and reporting.
• Completed advanced SQL tasks, including complex queries, joins, CTEs, aggregations, validation, reconciliation, and large-dataset analysis
• Translate business questions into data requirements, analytical approaches, metrics, and actionable insights.
• Explain complex data and findings to Product, Strategy, Operations, and senior business leaders.
• Use Excel, SQL, Power BI, or similar tools for analysis, reconciliation, and validation.

What you have

To ensure that we fulfill our promise of 'challenging the status quo,' this role has specific qualifications that successful candidates should have.

Required Qualifications:

• 3+ years of business analysis experience, including requirements gathering, process analysis, root-cause analysis, and translating business needs into user stories, acceptance criteria, process flows, and test scenarios.
• 3+ years of experience monitoring file transmissions, interfaces, batch processes, or system-to-system data exchanges, including investigation and resolution of processing issues.
• 2+ years in an Agile environment, familiar with ceremonies, JIRA/Rally project management tool experience, supporting testing, production releases, incident investigation, and release validation.
• 3+ years of data analytics, business intelligence, or data management experience, including extracting, cleansing, validating, reconciling, and analyzing data to identify trends, anomalies, and actionable business insights.
• Proven ability to learn complex systems, think logically, solve problems, and manage multiple competing priorities in a fast-paced environment.
• Excellent written, verbal, organizational, and cross-functional collaboration skills, with the ability to work effectively across business, technology, operations, and external partners.

Preferred Qualifications:

• 3+ years of broker-dealer trading systems experience, with knowledge of brokerage/trading processes, systems, workflows, and data
• Advanced proficiency in SQL, Tableau, and relational databases, including complex analysis, data modeling, dashboards, KPI reporting, and visualization.
• Minimum 2 years with Python, R, Alteryx, Power BI, Snowflake, Databricks, or comparable analytics/data platforms.

In addition to the salary range, this role is also eligible for bonuses or incentive opportunities.

#workplacejobs

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