Data Engineer

Charles Schwab; Austin (TX); Hybrid; USD 110,000 - 160,000; Full time

Benefits offered by this job

401(k) match

Sabbatical after 5 years

Parental leave

Tuition reimbursement

Health, dental, and vision insurance

Hybrid work model

Job summary

Charles Schwab is seeking a data-focused analyst/ETL developer to design and develop data solutions for analytics and reporting within the Schwab Technology Services Insights team. You will lead use-case analysis, map data requirements, and collaborate with onshore/offshore teams to deliver scalable data ingestion and integration workflows.

The role emphasizes strong SQL, data warehousing concepts, and experience with tools like Teradata, Hadoop, and Informatica.

Qualifications

• 5-10 years of experience in business analysis, systems analysis, or data analysis on data integration, data warehouse, or analytics initiatives.
• 5-7 years of experience working with data warehouse platforms such as Teradata, or with Hadoop and other large-scale data environments.
• 2+ years of experience working with cloud data platforms.
• Demonstrated experience eliciting, analyzing, and documenting business requirements, business rules, data definitions, and process flows.
• Demonstrated experience creating or reviewing source-to-target data mappings, transformation rules, and data-quality requirements.
• Strong SQL skills for exploring, profiling, reconciling, and validating data, and for communicating findings.
• Strong knowledge of data warehousing and data integration concepts, including schemas, fact and dimension data, data quality, and operational data exchanges or stores.
• Experience translating business needs into features or user stories, acceptance criteria, and delivery-ready requirements.
• Experience defining or supporting data-validation and user-acceptance testing, including documenting results and coordinating issue resolution.
• Experience with Erwin, or similar data modeling platform for database design, cataloguing, and modelling.
• Experience in schema design and proven ability to work with complex data structures and enterprise-scale datasets.
• Experience working in Agile delivery teams and managing requirements or stories with Jira, Rally, or similar tools.
• Understanding of the software development lifecycle, release readiness, and production implementation practices.
• Demonstrated ability to collaborate across business, technology, QA, vendor, and geographically distributed teams.
• Strong analytical, facilitation, written and verbal communication, prioritization, and problem-solving skills.
• Ability to work independently in a fast-paced environment with competing priorities and deadlines.

Responsibilities

• Lead discovery with business and technical stakeholders to understand business capability enabled, use cases, data needs, business rules, and desired outcomes.
• Analyze source data and business rules; translate findings into clear business capability use cases, functional requirements, data definitions, source-to-target mappings, transformation rules, and data-quality expectations.
• Decompose business needs into well-defined features and stories, including acceptance criteria, dependencies, and traceability from requirements through delivery.
• Facilitate requirements, mapping, and solution reviews with business partners, product owners, developers, QA, and support teams; resolve gaps and confirm shared understanding.
• Create data warehouse models and produce ETL design patterns to support enterprise data engineering projects.
• Assist in the design and development of scalable enterprise data ingestion and integration workflows across batch, near-real time, and real-time patterns.
• Partner with engineers to evaluate solution options and clarify implementation details, ensuring that delivered data integrations meet business needs.
• Define data-validation and user-acceptance scenarios, coordinate stakeholder reviews, and document results, defects, and outstanding issues.
• Maintain requirements, mappings, decisions, and other analysis artifacts throughout the delivery lifecycle.
• Help product owners and delivery teams assess scope, prioritize work, identify dependencies, and manage changes to requirements.
• Support implementation readiness and production triage by clarifying expected business behavior, assessing data discrepancies, and coordinating follow-up.
• Use SQL and data-analysis techniques to investigate source data, validate mappings, reconcile results, and communicate findings.
• Contribute to technical artifacts or development activities when needed, while focusing primarily on business analysis and delivery alignment.
• Identify delivery, data, and technology risks early and work with stakeholders to define mitigation plans.
• Collaborate with onshore and offshore teams and shared functions to improve handoffs, support processes, and delivery practices.
• Promote clear communication, constructive feedback, accountability, and continuous improvement across the team.

Skills

SQL

Data analysis

Data warehousing

ETL design patterns

Agile tools

Tools

Teradata

Hadoop

Erwin

Informatica PowerCenter/IICS

Job description

Your opportunity

At Schwab, you are 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.

As part of the Schwab Technology Services Insights team, you will partner with our internal Business stakeholders and Data Engineering team to design and develop data solutions for data science, analytics and reporting. We are a team of passionate data engineers and SMEs who bring a lot of energy, focus and fresh ideas that support our mission to provide value by seeing the world “Through Clients' Eyes”. ETL Developers and Data Analysts work with large teams, including onshore and offshore developers, using best-in-class technologies including BigQuery and Informatica. You will lead the use case analysis, design, solutioning for our enterprise data integrations that enable insights for our internal technology leadership. In this role you will have opportunities to grow in responsibility, work on exciting and challenging projects, train on new technologies and lead other developers to set the future of the Data Warehouse.

Key Responsibilities

• Lead discovery with business and technical stakeholders to understand business capability enabled, use cases, data needs, business rules, and desired outcomes.
• Analyze source data and business rules; translate findings into clear business capability use cases, functional requirements, data definitions, source-to-target mappings, transformation rules, and data-quality expectations.
• Decompose business needs into well-defined features and stories, including acceptance criteria, dependencies, and traceability from requirements through delivery.
• Facilitate requirements, mapping, and solution reviews with business partners, product owners, developers, QA, and support teams; resolve gaps and confirm shared understanding.
• Create data warehouse models and produce ETL design patterns to support enterprise data engineering projects.
• Assist in the design and development of scalable enterprise data ingestion and integration workflows across batch, near-real time, and real-time patterns.
• Partner with engineers to evaluate solution options and clarify implementation details, ensuring that delivered data integrations meet business needs.
• Define data-validation and user-acceptance scenarios, coordinate stakeholder reviews, and document results, defects, and outstanding issues.
• Maintain requirements, mappings, decisions, and other analysis artifacts throughout the delivery lifecycle.
• Help product owners and delivery teams assess scope, prioritize work, identify dependencies, and manage changes to requirements.
• Support implementation readiness and production triage by clarifying expected business behavior, assessing data discrepancies, and coordinating follow-up.
• Use SQL and data-analysis techniques to investigate source data, validate mappings, reconcile results, and communicate findings.
• Contribute to technical artifacts or development activities when needed, while focusing primarily on business analysis and delivery alignment.
• Identify delivery, data, and technology risks early and work with stakeholders to define mitigation plans.
• Collaborate with onshore and offshore teams and shared functions to improve handoffs, support processes, and delivery practices.
• Promote clear communication, constructive feedback, accountability, and continuous improvement across the team.

What you have

• 5 - 10 years of experience in business analysis, systems analysis, or data analysis on data integration, data warehouse, or analytics initiatives.
• 5 - 7 years of experience working with data warehouse platforms such as Teradata, or with Hadoop and other large-scale data environments.
• 2+ years of experience working with cloud data platforms
• Demonstrated experience eliciting, analyzing, and documenting business requirements, business rules, data definitions, and process flows.
• Demonstrated experience creating or reviewing source-to-target data mappings, transformation rules, and data-quality requirements.
• Strong SQL skills for exploring, profiling, reconciling, and validating data, and for communicating findings to technical and non-technical partners.
• Strong knowledge of data warehousing and data integration concepts, including schemas, fact and dimension data, data quality, and operational data exchanges or stores.
• Experience translating business needs into features or user stories, acceptance criteria, and delivery-ready requirements.
• Experience defining or supporting data-validation and user-acceptance testing, including documenting results and coordinating issue resolution.
• Experience with Erwin, or similar data modeling platform for database design, cataloguing, and modeling.
• Experience in schema design and proven ability to work with complex data structures and enterprise-scale datasets.
• Experience working in Agile delivery teams and managing requirements or stories with Jira, Rally, or similar tools.
• Understanding of the software development lifecycle, release readiness, and production implementation practices.
• Demonstrated ability to collaborate across business, technology, QA, vendor, and geographically distributed teams.
• Strong analytical, facilitation, written and verbal communication, prioritization, and problem-solving skills.
• Ability to work independently in a fast-paced environment with competing priorities and deadlines.

Preferred

• Experience working with Google Cloud Platform
• Familiarity with enterprise data integration tools such as Informatica PowerCenter, IICS, or similar platforms.
• Experience analyzing data from corporate systems such such Workday, BMC Remedy Helix, Jira, or Rally.
• Familiarity with data pipelines, batch and near-real-time integration patterns, and common data-quality controls.
• Experience with scheduling, deployment, or delivery tools such as Control-M, ESP, GitHub, Bamboo, Liquibase, or GitHub Actions.
• Familiarity with Unix environments, shell scripting, or Python.
• Experience providing guidance to technical staff, coordinating work across a matrixed team, or supporting delivery across multiple priorities.

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

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