ETL Developer - Data Engineer

Charles Schwab Inc.•Southlake, TX

4d•$100,000 - $125,000

About The Position

Join Schwab’s high-impact Data Engineering organization to partner with business stakeholders and the Data Engineering team in designing and developing data solutions for data science, analytics, and reporting. ETL Developers work with large onshore and offshore teams and enterprise technologies including BigQuery, Teradata, Informatica, and Hadoop. The role designs, develops, and implements enterprise data integration solutions and offers opportunities to take on greater responsibility, work on challenging projects, train on new technologies, and lead other developers.

Requirements

5–10 years of overall technology experience, including significant hands-on ETL Developer or ETL Lead experience supporting data warehouse and enterprise data integration projects.
Demonstrated ability to lead ETL delivery efforts and deliver projects with minimal defects.
5–7 years of hands-on experience with data integration tools such as Informatica PowerCenter and/or Informatica Intelligent Cloud Services (IICS).
5–7 years of experience with data warehouse platforms such as Teradata and Big Data/Hadoop environments.
Experience with Google Cloud Platform, including BigQuery.
Strong SQL skills, including developing, tuning, troubleshooting, and debugging complex SQL applications.
Hands-on experience designing and developing data ingestion workflows across batch, near-real-time, and real-time patterns.
Strong understanding of data modeling concepts, including logical and/or physical data models.
Expertise in schema design and ability to work with complex data structures and enterprise-scale datasets.
Experience with scheduling tools such as Control-M or ESP.
Strong understanding of DevOps and CI/CD concepts, with hands-on experience using tools such as Bamboo, Bitbucket, GitHub, and GitHub Actions.
Experience working in Unix environments, including basic shell scripting.
Experience with Agile delivery frameworks and tools such as Jira or Rally.
Advanced understanding of the software development lifecycle (SDLC), development standards, and production implementation practices.
Ability to collaborate across business, technology, vendor, offshore, and cross-functional teams.
Strong analytical, problem-solving, influencing, prioritization, decision-making, negotiation, and troubleshooting skills.
Ability to work independently in a fast-paced environment with competing priorities, multiple projects, and strict deadlines.

Responsibilities

Design, develop, and implement scalable enterprise data ingestion and integration workflows for batch, near-real-time, and real-time patterns.
Work with business analysts, product owners, data modelers, technical directors, and cross-functional teams to translate business requirements into efficient ETL solutions.
Create, maintain, and update ETL specifications, technical documentation, data mappings, and implementation artifacts.
Develop, tune, debug, and optimize complex SQL and ETL processes across data warehouse and cloud platforms.
Build data solutions with technologies such as Informatica PowerCenter, IICS, Teradata, BigQuery, Hadoop, and related enterprise data platforms.
Apply data integration best practices for data quality, automation, performance, resiliency, and operational excellence.
Lead medium-sized ETL delivery efforts, coordinate onshore, offshore, and vendor teams, and ensure delivery with minimal defects.
Define and execute unit testing, data validation, quality checks, and implementation-readiness activities for ETL deliverables.
Support production implementations, issue triage, root cause analysis, and ongoing improvement of data integration processes.
Advocate for agile practices and process improvements that improve delivery efficiency and team effectiveness.