Position Type: Regular Your opportunity
Do you want to be part of an enterprise data solutions team managing over 4 petabytes of data and building the next-generation analytics platform for a leading financial firm with over $8 trillion in assets under management? At Schwab, the Data & Rep Technology (DaRT) organization owns the strategy, implementation, delivery, and support of the enterprise data warehouse and emerging data platforms.
At Schwab, the Strategic Financial Analytics and Data (SFAD) organization governs the strategy and implementation of the enterprise data warehouse, Data Lake, and emerging data platforms such as Cloud Data Warehouse. Our mission is to drive activation of data solutions, rep engagement technology (Sales, Marketing and Service) and client intelligence to achieve targeted business outcomes, address data risk and safeguard competitive edge. We help Marketing, Finance, Risk and executive leadership make fact-based decisions by integrating and analyzing data.
As part of the Business Data Delivery team, you will partner with our Business stakeholders and Data Engineering teams to design and develop dev engineering framework/reusable solutions for data engineering and ETL developers. 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 work with large teams, including onshore and offshore developers, using best-in-class technologies including BigQuery, Informatica, Python and Talend. You will be a tech lead for the dev engineering team that will design, develop and implement enterprise data integration solutions with 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.
We are looking for someone who has a passion for data and comes with a data engineering background. Someone who has experience designing and coding batch and real-time ETL (and ELT) and wants to be part of the Dev Engineering team that is actively designing and implementing the Enterprise Data solution frameworks. Someone who wants to be challenged every day and has a passion for keeping up to date on new technologies in the Data Engineering space set new standards for Schwab’s hundreds of ETL developers and collaborates with the team members along the way.

• You will be a Sr. Data Engineer in a horizontal Dev Engineering team that includes onshore and offshore developers using best-in-class Google Cloud relational Data warehouse technologies, including Informatica Big Query, IICS, Talend, Python etc.
• You will be prototyping data solutions to enable faster access to data for the analytics use case developers.
• You will be developing re-usable data solution patterns to enable quick-to-market data assets.
• You will be analyzing & profiling business data on relational and Big Data environments.
• You’ll have the opportunity to grow in responsibility, work on exciting and challenging projects, train on emerging technologies and help set the future of the Data Solutions Delivery teams.
• Manage day-to-day re-usable framework development activities for new data solutions and troubleshooting existing solutions.
• Partner with product owners and directors to lead technical discussions and resolve technical issues
• Design and publish best practices of data integration for data quality and automation for dev teams
• Partner with the product vendors to identify and manage open product issues
• Solve complex data integration problems
• Work with project development teams and technology partners to develop high-level designs and cost and effort estimates for new framework development efforts.
• Architect, design, and develop solutions and provide supporting documentation.
• Develop and maintain code for data ingestion and curation using Informatica IICS, Talend, Python, Spark, Kafka, etc.

What you have
Required:

• Must have Schwab Technology Domain experience gained as a Schwab Contractor for at least 18 months
• Minimum 10 years of hands-on development experience using parallel processing databases like Teradata.
• Must have 3 years’ experience in Big Query, Data Proc on Google Cloud Platform, and Informatica IICS
• Expert-level hands-on development experience using Informatica IICS or any enterprise-class ETL tool
• Experience in data streaming technologies like Kafka
• Experience with all aspects of data systems, including database design, ETL, aggregation strategy, performance optimization
• Expertise in schema design, developing data models, and proven ability to work with complex data is required
• Hands-on experience with programming language Java/Python/Spark
• Hands-on experience with Linux and shell scripting
• Hands-on experience with CI/CD tools like Bamboo, Jenkins, Bitbucket, etc.

Preferred:

• Experience setting best practices for building and designing ETL code and strong SQL experience to develop, tune, and debug complex SQL applications

What’s in it for you
At Schwab, we’re committed to empowering our employees’ personal and professional success. Our purpose-driven, supportive culture, and focus on your development means you’ll get the tools you need to make a positive difference in the finance industry. Our 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 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