Data Engineer, ETL & Data Warehouse (Hybrid)

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

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.