Your opportunity

At Schwab, the Data and Rep Technology (DaRT) organization governs the strategy and implementation of the enterprise data warehouse, Data Lake, and emerging data platforms. 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 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 work with large teams, including onshore and offshore developers, using best-in-class technologies including BigQuery, Teradata, Informatica, and Hadoop. You will design, development 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.

What you are good at

Designing, Developing and implementing new data ingestion workflows by practical application of existing and new data engineering techniquesLeading large projects or multiple projects for successful deliveryDeveloping data ingestion workflows across wide variety of data sources and data ingestion patterns such as batch, near real-time and real timeWorking with business analysts to understand business/new data requirements and use casesCrafting and updating ETL specifications and supporting documentationWorking with technical directors, Data Modelers and cross-functional teams to ensure an accurate and efficient implementation of requirements and following standardsDefining and executing quality assurance and test scriptsGuiding the ETL delivery team with technical expertiseReviewing ETL delivery from 3rd party vendor teamsAdvocating for agile practices to increase delivery efficiencyEnsuring consistency with published development, coding and testing standardsApplying data integration best practices for data quality and automationWorking with product vendors to identify and manage open product issuesWhat you have
Demonstrated ability as an ETL lead with a track record of delivering projects with minimal defectsMust have Technology Domain experience gained as a Schwab as a contractor for at least 1 year5-7 years of hands-on experience with data integration tools such as Informatica Power Center and IICS5-7 years in Data Warehouse platforms such as Teradata and BigData/Hadoop2 years of experience in Google Cloud Platform (Big Query)1-2 years of Schwab technology domain experience as a current or recent contractor or employeeAt least 4 years of experience in data modeling (logical and/or physical)At least 4 years of hands-on experience working with near real-time and/or real-time data ingestion techniquesExpertise in schema design and proven ability to work with complex data is requiredStrong SQL experience with the ability to develop, tune and debug complex SQL applications is requiredExperience with Google Cloud Platform, BigQuery and Informatica Intelligent Cloud Services (IICS) highly desirable and Attunity Change Data Capture toolExperience with scheduling tools (eg. Control M, ESP)Proven experience in working in large environments such as RDBMS, EDW, NoSQL, BigData etc. is preferredPrior experience interfacing with various partners, including vendors, offshore development teams and internal groupsAbility to quickly learn & become proficient with new technologiesStrong analytical, problem-solving, influencing, prioritization, decision-making and conflict resolution skillsExceptional interpersonal skills, including teamwork, communication, and negotiationAbility to help drive processes, manage projects and solve highly complex problems using innovative solutionsAbility to work independently with little instruction on day-to-day work and lead multiple projects requiring cross-team and external collaborationAbility to coach and mentor individuals on technical matters by sharing knowledgeExperience with Schwab Applications for 3-5 years

Schwab is committed to building a diverse and inclusive workplace where everyone feels valued. As an Equal Opportunity Employer, our policy is to provide equal employment opportunities to all employees and applicants without regard to any status that is protected by law. Please click here to see the policy.

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 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 planPaid time for vacation, volunteering, and 28-day sabbatical after every 5 years of service for eligible positionsPaid parental leave and family building benefitsTuition reimbursementHealth, dental, and vision insurance Apply Save job