Job Description
Position Type: RegularYour opportunity At Schwab, you’re 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. Stock Plan Services focuses on supporting equity compensation for our B2B clients. We have multiple applications that support this effort, and our mission is to launch a consolidated platform of microsites to combine these segregated applications into a holistic user experience. While executing this goal we strive to maintain excellent customer support and deliver on sustaining engineering objectives. We are fueled by a diverse team of talented team-members who continuously raise the bar on delivering best-in-class products and services to people all over the world. Essential Functions: Analyze complex T-SQL and PL/SQL code to gain insight on performance improvement opportunities Design and implement data models for scalable and performance solutions with large data volumes Use Oracle Data Integrator to manage and maintain data integrations between interconnect databases Identify&address application data issues that affect application integrity Ensure that the database design fulfills functional&technical requirements, including design-for-performance Develop, analyze, and maintain technical documentation for database patterns, common used functions, and other critical areas of the databases Work effectively with Technical leads, Architects and Database Developers to create and maintain the overall data architecture, priorities, and success measures for the enterprise Review the deliverables throughout development to ensure quality&traceability to requirements and adherence to all quality management plans&standards What you have Required Qualifications: 7 years in a developing, modeling, and deploying enterprise solutions with Oracle database focus 5 years of experience with ODI and OBIEE 5 years of experience with data modeling, ETL design and ETL tools 5 years of experience with PL/SQL programming, including creating packages, functions, stored procedures and views 5 years of experience writing and deciphering complex SQL queries 5 years of experience with Unix/Shell scripting Experience with Linux/Unix operating system Experience with creating a scalable and performing solution with large data volumes in the Oracle DB Experience with complex data models Experience using Oracle Data Visualizer 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 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