Charles Schwab Snr. SQL Data Analyst in Lone Tree, Colorado
We believe that , when done right, investing liberates people to create their own destiny. We are driven by our purpose to champion every client’s goals with passion and integrity. We respect and appreciate the diversity of our employees, our clients, and the communities we serve. We challenge conventions strategically to create value for our clients, our firm and the world. We live and bring to life the concept of ‘own your tomorrow’ every day. We champion our employee strengths, guide their development, and invest in their long-term success. We hire optimistic, results-oriented, curious, innovative, and adaptable people with the desire to help our clients and one another succeed.
As a company, we were established by Chuck at http://www.aboutschwab.com/about/leadership/charles_schwab over 40 years ago to champion Main Street over Wall Street, and to help Americans transform themselves from earners to owners. Through advocacy and innovation, we work to make investing more affordable, accessible and understandable for all. As we enter our fifth decade, we are looking for talented, innovative and driven people who believe they can help themselves, and our clients, create a better future.
The Snr. SQL Data Analyst will be a key part of our team, working with technical and business teams to deploy quality code within our financial analysis portfolio of applications. Within our transaction monitoring platforms, we need a strong technical leader to ensure we are driving best practices, new technology and approaches to delivering value with more velocity and quality. This role will have a collaborative and hands on approach to contributing new code to our monitoring platforms. Within our case management and reporting platforms, this position will drive new technology, process and data quality architectures, working closely with our development team to transform our approach to data and integrations across applications.
What you’ll do:
Utilize Oracle (PL SQL) and Microsoft (MS SQL) and technologies to architect and develop data transformation and manipulations systems.
Understand, plan and transform data models and application capabilities, working with development teams to drive effective and efficient changes
Mentor BSA and Development staff to improve team knowledge, quality, capacity and throughput. Perform code review and drive continual improvement
Research and investigate data discrepancies and provide data validation reports and understand system processes
Support our agile project work working with business and technical teams to define roadmaps, manage backlog, prioritize and ensure accountability within the portfolio
Build complex SQL queries, and other data analysis techniques to create or improve the alerts produced by the monitoring system
Learn implementation and configuration options for the vendor solution in detail, including the steps involved in applying and testing changes
Analyze requirements, recommended design approaches and solution options
Perform rigorous testing to assess the quality and accuracy of data in the system, support ideas and methodologies to ensure data quality
Identify opportunities to improve our use of data in testing and environment automation
Support User Acceptance Testing and coordinate issue analysis / resolution
What you have:
BA/BS or higher degree, preferably in an analytical or technical discipline
Excellent skills with PL/SQL and Oracle Server Application Development. Exposure and experience with T-SQL a plus
7+ years of related experience, with a focus on data integration, reporting, and analysis
Adept at translating business requirements into technical specifications
Excellent written/verbal communication skills
Familiarity with the financial services domain or a strong desire to learn about the industry
Strong interpersonal, problem-solving, prioritization, organization, and decision-making skills
Experience performing quantitative analysis for risk assessments a plus
Experience working with big data technologies a plus
What you’ll get:
Everyday Wellness: Healthy Rewards, Onsite Fitness Classes, Healthy Choices, Wellness Champions
Financial Fitness: 401k Match, Employee Discounts, Personalized advice, Brokerage discounts
Work/Life Balance: Sabbatical, New Mothers returning to work Program, Tuition Reimbursement Programs, Time off to volunteer
Inclusion: Employee Resource Groups, Commitment to diversity, Strategic partnerships
Not just a job, but a career, with an opportunity to do the best work of your life
Learn more about Life@Schwab at http://www.aboutschwab.com/careers/lifeatschwab/" .
Charles Schwab & Co., Inc. is an equal opportunity and affirmative action employer committed to diversifying its workforce. It is Schwab's policy to provide equal employment opportunities to all employees and applicants without regard to race, color, religion, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), gender identity or expression, national origin, ancestry, age, disability, legally protected medical condition, genetic information, marital status, sexual orientation, protected veteran status, military status, citizenship status or any other status that is protected by law.
Position Located In: CO - Lone Tree