Business Systems Analyst/Data Modeler

company banner
Charles Schwab & Co., Inc.
Full Time
Work from home not available Travel not required

Job Description


Westlake - TX, TX2050R, 2050 Roanoke Road, 76262-9616
Jeanie Lynn Bannon

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 Business System Analyst/Data Modeler, you will work closely with business partners to understand the data and business challenges to propose new functionality into the enterprise data warehouse.   You will analyze data using SQL, identify and propose alternative questions, and design a data model and/or application data flow to deliver the business capability.  You will be required to quickly learn Schwab’s business model, business vision and the associated analytical/reporting requirements.   A successful candidate will be curious about the business and the data that enables it.  A successful candidate will also be passionate about partnering with our business teams and exploring data to find the best solutions. 

What you’ll do:

  • Analyzing source system data, profiling data (using SQL and Hive QL) and arranging service level agreements with data providers
  • Designing conceptual and logical data models (using ERwin), creating metadata definitions, and creating source-to-target mapping
  • Acting as requirements coordinator for 1-2 medium to large projects, capturing usage requirements and designing the semantic/information layer
  • Participating on small projects in preparing and managing the project plans, and recommending solutions
  • Partnering with business users and acting as a liaison between business and technical teams
  • Coordinating data model review and handoff with the ETL development team
  • Building deep understanding of the warehouse data and capabilities

What you have:

  • At least 3-5 years of experience as a technical business analyst with a track record of delivering well-documented data requirements
  • Substantial experience in Data Warehousing / Information Management preferably using Teradata database platform
  • Expert level SQL skills
  • Experience in data modeling (logical and/or physical) with solid understanding of 3NF, Star Schemas and performance concerns
  • Experience using Erwin
  • Familiarity with Informatica, Hive and Teradata preferred.
  • Experience /knowledge of Project Management with the ability to drive projects to successful completion
  • Experience in Agile development methodology
  • Prior experience interfacing with various partners, including vendors, offshore development teams, and internal groups
  • Strong interpersonal, analytical, problem-solving, influencing, prioritization, decision- making and conflict resolution skills
  • Excellent written/verbal communication skills
  • Strong knowledge of MS Project, Excel, MS Word and Visio Drawing tool along with general familiarity with Outlook and other MS Office applications is also required 

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-Other Specialty Engineering-2-5 yrs, IT-DBA-2-5 yrs
Position Located In:TX - Westlake
Job Type:Full Time

Category:Information Technology
Activation Date: Monday, May 13, 2019
Expiration Date: Sunday, September 1, 2019
Apply Here

Company Information

At Schwab, we inspire the driven; individuals who want to take ownership of their career and their future. You are appreciated for your work, respected for your unique strengths and rewarded for the possibilities you create for our clients. Working in Schwab Technology is not just a job; it's an opportunity to do the best work of your life. This team drives Schwab's mission to harness the power of data to deliver the next gen client experience. They relentlessly pursue simplification and modernization, laying the foundation for the digital enterprise. They act boldly together to provide security for our clients and enterprise, safeguarding client trust all while delivering on their core commitments to availability, capacity and project execution with excellence and efficiency. If you are looking to be challenged with projects that stretch and grow your abilities, and push you towards further developing your expertise, apply to one of our openings today.
Dice Id : 10228622
Position Id : 0513-48602

Similar Positions at Charles Schwab & Co., Inc.

Sr. Manager, Business Systems Analyst
  • Fort Worth, TX
  • 16 hours ago
Sr Manager Data Engineering
  • Westlake, TX
  • 16 hours ago
IAM Security Analyst
  • Westlake, TX
  • 16 hours ago
Sr. Security Analyst - IAM
  • Westlake, TX
  • 16 hours ago
Staff IAM Operations Security Analyst
  • Westlake, TX
  • 16 hours ago
DevOps Engineer
  • Westlake, TX
  • 16 hours ago
Sr. Web Developer
  • Westlake, TX
  • 16 hours ago
Business Systems Analyst
  • Lone Tree, CO
  • 16 hours ago
Sr. Release Manager
  • Fort Worth, TX
  • 16 hours ago