Data Engineer
Job Description
Charles Schwab Technology Services is hiring a Data Engineer to build and validate ETL pipelines that enable accurate data migration between systems.
Responsibilities
- Develop, test, and maintain data pipelines supporting accurate data migration across source and target systems
- Apply data engineering fundamentals using SQL, Informatica, and problem-solving skills to implement transformations
- Validate data accuracy and perform data quality assurance as part of pipeline delivery
- Collaborate with technical leads and peers to review mapping specifications, refine solutions, and deliver high-quality data outcomes
- Support scalable, secure, and trusted technology solutions through high-quality data delivery
Requirements
- 3+ years of hands-on experience in ETL development
- Experience building mappings, tasks, and task flows using ETL tools
- Strong SQL experience, including:
- Writing queries
- Creating and altering tables
- Joins and aggregations
- Data validation scripts
- Experience with staging tables, lookup tables, reference tables, and mapping configurations
- Ability to read technical mapping specifications and implement source-to-target transformation logic
- Experience performing unit testing to validate data accuracy and transformation logic
- Open-source scripting using Python for data processing
Technologies
- SQL
- Informatica
- Python
Preferred Qualifications
- Experience with RDBMS (Oracle, MS SQL Server) and database objects used in data migration or data integration
- Ability to apply data engineering fundamentals to build reliable, compliant, and scalable data pipelines
- Strong attention to detail when validating data, reviewing specifications, and preparing work for quality assurance
- Ability to troubleshoot moderately complex data issues by analyzing patterns, identifying root causes, and recommending practical solutions
- Experience participating in peer reviews and providing feedback to improve delivery quality
- Strong collaboration and communication skills across technical teams
Compensation & Location
- Location: Southlake, TX (onsite)
- Pay: USD 43 - 52 per hourly
- Minimum Experience: 3 years
Benefits
- 401(k) with company match
- Employee stock purchase plan
- Paid time for vacation and volunteering
- 28-day sabbatical after every 5 years of service for eligible positions
- Paid parental leave
- Family building benefits
- Tuition reimbursement
- Health, dental, and vision insurance
- Bonus or incentive opportunities
Eligible Schwabbies Receive
- Medical, dental and vision benefits
- 401(k) and employee stock purchase plans
- Tuition reimbursement to keep developing your career
- Paid parental leave and adoption/family building benefits
- Sabbatical leave available after five years of employment