Your opportunity At Schwab, youre empowered to make an impact on your career. Here, innovative thought meets creative problem solving, helping us challenge the status quo and transform the finance industry together. We believe in the importance of in-office collaboration and fully intend for the selected candidate for this role to work on site in the specified location. At Schwab, the Analytical Data Platform Engineering (ADPE) organization governs the strategy and implementation of the enterprise data warehouse and emerging data platforms. Our mission is to drive activation of data solutions, engagement technology (Sales, Marketing and Service) to achieve targeted business outcomes, address data risk and safeguard competitive edge. We help Digital, Brokerage, HR, Marketing, Finance, Risk and executive leadership make fact-based decisions by integrating and analyzing data. As Sr Specialist Data Engineering, 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 Informatica IICS and BigQuery. You 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 work with 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 techniques Developing data ingestion workflows across wide variety of data sources and data ingestion patterns such as batch, near real-time and real time Leading projects for successful delivery Working with business analysts to understand business/new data requirements and use cases Crafting and updating ETL specifications and supporting documentation Working with technical directors, Data Modelers and cross-functional teams to ensure an accurate and efficient implementation of requirements and following standards Defining and executing quality assurance and test scripts Guiding the ETL delivery team with technical expertise Reviewing ETL delivery from 3rd party vendor teams Advocating for agile practices to increase delivery efficiency Ensuring consistency with published development, coding, and testing standards To ensure that we have fulfilled our promise of 'challenging the status quo,' this role has specific qualifications that successful candidates should have. Required Qualifications Demonstrated ability as an ETL Developer with a track record of delivering code with minimal defects 5-6 years hands-on experience with Google Cloud Platform, BigQuery, Informatica Power Center and Informatica Intelligent Cloud Services (IICS) or similar tools. 5-6 years in Data Warehouse platforms such as Teradata (or similar databases), BigData/Hadoop (or similar technologies), BigQuery At least 3-5 years of experience in data modeling (logical and/or physical) 3-5 years of hands-on experience working with near real-time and/or real-time data ingestion techniques, AVRO, KAFKA, Rabbit MQ Expertise in schema design and proven ability to work with complex data is required Strong SQL experience with the ability to develop, tune and debug complex SQL applications is required 1-2 years experience with scheduling tools (Control M, ESP) Proven experience in working in large environments such as RDBMS, EDW, NoSQL, BigData etc. is preferred Prior experience interfacing with various partners, including vendors, offshore development teams and internal groups Ability to quickly learn & become proficient with new technologies Strong analytical, problem-solving, influencing, prioritization, decision-making and conflict resolution skills Exceptional interpersonal skills, including teamwork, communication, and negotiation. In addition to the salary range, this role is also eligible for bonus or incentive opportunities Whats in it for you At Schwab, were committed to empowering our employees personal and professional success. Our purpose-driven, supportive culture, and focus on your development means youll 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 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

#J-18808-Ljbffr