Senior Data Analyst

Apply Now    
Job ID:
20170822-4314
Job Category:
Information Technology
Relevant Work Experience:
IT-DBA-6+ yrs
Current Licenses / Certifications:
None
Position Located In:
CO - Lone Tree
Education:
BA/BS
Job Type:
Full Time
Description:

Lone Tree - CO, DENR3, 9800 Schwab Way, 80124
Anders Bjerkhoel
20170822-4314

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 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.

Our Opportunity:

As a member of the CRM Retail Technology team, you will be immersed in a collaborative, innovative, and technically challenging environment. As a Senior Data Analyst you will be responsible for data analysis of Salesforce data, Informatica ETL development, data quality between source and target systems, and data modeling. We're looking for team members that are eager to learn and implement new technologies and provide outstanding database solutions. 

What you’ll do:

As a member of the CRM Retail Technology team, you will be immersed in a collaborative, innovative, and technically challenging environment. As a Senior Data Analyst you will be responsible for data analysis of Salesforce data, Informatica ETL development, data quality between source and target systems, and data modeling. We're looking for team members that are eager to learn and implement new technologies and provide outstanding database solutions.

As a Senior Data Analyst you will be responsible for helping to deliver quality technology and software initiatives by:
• Participating in data architecture and data integration design discussions
• Collaborating with business partners on data issues
• Partnering with application developers on designs, models and best in class implementation
• Interacting with experts from across Schwab in different support organizations and business groups
• Being a member of Agile team(s) that focuses on delivering what the client needs
• Leading design and development of data quality and data drift detection software
• Implementing data integration ETL in Informatica Power Center
• Using data quality analysis tools
• Providing production support for data issues, including data fixes across platforms
• Participating in planning for retirement of an older CRM platform and enabling migration of its data to Salesforce.com
• Leading efforts to analyze data models, data interfaces and dependencies of the older CRM platform; planning, specifying, and developing new data integrations and interfaces to enable retirement of the old platform
• Working closely with DBAs, data analysts, developers, and production support to identify and fix data issues that cross platforms 

What you have:

As a senior team member you will have the following skills and experience:

  • Strong foundational understanding of database concepts and development technologies
  • Excellent problem solving and troubleshooting skills, coupled with a desire to take on responsibilities; solutions oriented
  • Excellent written and verbal communication skills, including the ability to explain complex data issues in business terminology
  • Ability to effectively handle multiple, competing, high-priority projects with varying deadlines
  • Experience interfacing with business partners at various levels
  • Demonstrated ability to understand the business functions that data supports
  • Ability to work independently as a member of an Agile scrum team
  • Track record of being detailed oriented; a self-starter having deliverables with minimal defects
  • Demonstrated experience with data modeling and performance tuning of Oracle SQL queries
  • Must be able to quickly grasp complex concepts and learn new technologies
  • Experience supporting production operations in a high-availability environment
  • Be a role model and a leader on the team

 As a technical leader you will have the following skills and experience:

  • Bachelor degree in Computer Science, Information Technology, Engineering or a related field
  • Strong database development skills gained through 5+  years hands on experience with relational database development  using stored procedures, PL/SQL, and SQL primarily in Oracle
  • Experience working with a CRM system, like Salesforce.com or Siebel; knowledge of how those systems do object modeling; ability to query against a Salesforce org using SOQL. Salesforce Certified Admin preferred. Experience with Siebel a plus.
  • Extensive experience writing complex SQL to identify data quality and synchronization issues
  • Proficiency in performance tuning using explain plans and baselines
  • Prior experience with Informatica Power Center required.
  • Prior experience with Unix/Linux Shell scripting (Korn Shell (KSH), BASH, etc.) required
  • Prior experience with data quality tools like Informatica DVO or Oracle EDQ highly desired
  • Prior experience with job scheduling systems (ESP, Autosys, Cron, etc.) a plus
  • Prior experience with object oriented languages like Java or C# or Apex a plus
  • Prior experience with MongoDB and Hadoop a plus
  • Prior experience with Tableau and Splunk a plus
  • Prior Agile development experience highly desired
  • Prior exposure to the financial industry will set you apart 

What you’ll get:

  • Comprehensive Compensation and Benefits package
  • Financial Health: 401k Match, Employee Stock Purchase Plan, Employee Discounts, Personalized advice, Brokerage discounts
  • Work/Life Balance: Sabbatical, Paid Parental Leave, New Mothers returning to work Program, Tuition Reimbursement Programs, Time off to volunteer, Employee Matching Gifts Program
  • Everyday Wellness: Health and Lifestyle Wellness Rewards, Onsite Fitness Classes, Healthy Food Choices, Wellness Champions
  • 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.

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. Schwab also does not discriminate against applicants or employees because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. At Schwab, we believe that every employee, through their diverse abilities and experiences, can contribute to our growth, innovation and client loyalty. We embrace diversity and are committed to providing equal opportunity to all employees and applicants. If you have a disability, and require reasonable accommodations in the application process, call Human Resources at 800-725-3535. We will be happy to assist you. Schwab will only share your accommodation request with those individuals who have a specific need to know. The request for an accommodation will not affect Schwab's hiring decisions. All other submissions should be performed online.


Job Specifications
Relocation Offered?: No
Work Schedule: Days
Languages: English - spoken
Current Licenses / Certifications: None
Relevant Work Experience: IT-DBA-6+ yrs
Position Located In: CO - Lone Tree
Education: BA/BS
Job Type: Full Time

Category:Information Technology
Activation Date: Tuesday, January 16, 2018
Expiration Date: Tuesday, May 1, 2018
Apply Here
Apply Now    
Link for schema

Brokerage Products: Not FDIC Insured • No Bank Guarantee • May Lose Value

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. Schwab also does not discriminate against applicants or employees because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant.

At Schwab, we believe that every employee, through their diverse abilities and experiences, can contribute to our growth, innovation and client loyalty. We embrace diversity and are committed to providing equal opportunity to all employees and applicants. If you have a disability, and require reasonable accommodations in the application process, call Human Resources at 800-725-3535. We will be happy to assist you. Schwab will only share your accommodation request with those individuals who have a specific need to know. The request for an accommodation will not affect Schwab’s hiring decisions. All other submissions should be performed online.

The Charles Schwab Corporation provides a full range of securities, brokerage, banking, money management, and financial advisory services through its operating subsidiaries. Its broker-dealer subsidiary, Charles Schwab & Co., Inc. (“Schwab”), Member SIPC , offers investment services and products, including Schwab brokerage accounts. Its banking subsidiary, Charles Schwab Bank (member FDIC and an Equal Housing Lender), provides deposit and lending services and products.