Data Architect

29 Jul 2022

Your Opportunity

Workplace Flexibility Program: We're proud to support our employees in a working approach that allows you to bring your best self to work - whether that's in the office or remote.

  • Most Schwabbies have the opportunity to voluntarily work in the office or at home based on their preference
  • When the firm is ready to fully return to the office, employees will have the flexibility of a hybrid work environment, spending some time working remote and some time in the office.
  • Employees and managers can discuss and decide what works best for them, with additional flexibility available based on their role, business needs, and individual circumstances.

Subject to change as Schwab is continually evaluating the current environment in order to best care for the safety and well-being of our employees.

Charles Schwab's Wealth Asset Management (WAM) Engineering is part of the Schwab Technology Services (STS) organization which is responsible for the company's use of information technology including all telecommunications, operations and client and business applications.

WAM Engineering is aligned to support the technology needs of Wealth & Asset Management, a group that unites all of Schwab's money management, research, and asset management platforms to help clients manage their wealth.

What you are good at

This is a senior data architect role designing and implementing end to end data integration solutions.

The role will lead our sales data integration efforts as the Senior Data Architect, which includes formulating the sales data strategy, including standards of data quality, the flow of data within the environment, and security of data. This role will facilitate data modeling sessions with business and technical users, identifying and profiling data sources, analyzing the business and technical requirements, and creating data models to meet Sales business needs. This individual must be an experienced, strong data architect and be focused on assessing our environment and requirements to design data integrations in conformance to best practices.

This role will also lead the design of a new data strategy based on a migration to the public cloud for our data sources and our own environment and technology stack.

What you have

This role requires a highly motivated and experienced Data Architect who has designed and implemented cross enterprise data platforms both cloud-based and on-premises. The individual will have pride of ownership reflected through well documented architecture design, the ability to review existing state and offer alternative solutions and a disciplined software development approach. The candidate will be expected to help build a robust data engineering and architecture practice, dedicating time to mentoring and training of data engineers within the team. The individual will need to display thought leadership through understanding the key business objectives and strategically providing data integration solutions to support the Sales data domain within the larger data strategy of the organization.

Qualifications & Experience
  • A university degree from a well-respected academic institution; advanced degrees in Information management, Computer Science, Business Administration and/or other professional certifications are a plus
  • 12+ years of experience in a data engineering / architecture role
  • 5+ years of experience working in an investment management firm
  • Experience participating in Agile Scrum development teams
  • Experience with data modeling of relational and dimensional databases, metadata management, data lineage and data governance
  • Experience with SQL Server, T-SQL; proficiency with advanced SQL concepts, designing ETL and ELT pipelines to support Enterprise Data Warehouses and Data Marts, with a strong understanding of data lake, data fabric and semantic layer design concepts and the Kimball Dimensional Modeling methodology
  • Experience with virtual data platforms like Denodo or similar technologies
  • Deep understanding of data ingestion pipelines and data lineage tracking using Google Cloud Platform products such as Data Catalog, Cloud Pub/Sub, Cloud Dataflow, Cloud Data Fusion, and BigQuery.
  • Understand and develop strategies for data modeling, design, and implementation to meet stated requirements for metadata management, data integration, data marts and Extract Transform Load environments.
  • Experience designing and building large Cloud-ready highly scalable and distributed software.
  • Experience or knowledge of Continuous Integration and Continuous Delivery.
  • Strong understanding of modern information security design and best practices
  • Familiar with predictive analysis and data visualization techniques using relevant tools (e.g. Tableau, Python)
Personal Characteristics
  • Ability to build consensus among business and IT constituents and influence the changes in behavior and beliefs necessary to drive a successful data strategy
  • Ability to consistently deliver results across shifting priorities and deadlines in fast paced environment
  • Ability to communicate effectively with various user groups at all levels of business and IT - excellent written and oral communication skills.
  • Inquisitive, analytical, a strategic thinker, proactive and solutions-oriented
  • High-energy, positive, entrepreneurial in spirit while goal-oriented and results-driven
  • Self-starter; takes initiative and can work independently
  • Well-organized and disciplined with high attention to detail
  • Flexible and adaptable working with various business domains
  • Direct, plain-spoken; conveys a genuine/authentic demeanor

Colorado Compensation

Target Total Compensation: 121,000 - 242,000

Your actual pay will be based on your skills and experience talk with your recruiter to learn more.

Why work for us?

Own Your Tomorrow embodies everything we do! We are committed to helping our employees ignite their potential and achieve their dreams. Our employees get to play a central role in reinventing a multi-trillion-dollar industry, creating a better, more modern way to build and manage wealth.

Benefits: A competitive and flexible package designed to empower you for today and tomorrow. We offer a competitive and flexible package designed to help you make the most of your life at work and at home-today and in the future. Explore further .

Schwab is committed to building a diverse and inclusive workplace where everyone feels valued. As an Equal Opportunity Employer, our policy is to provide equal employment opportunities to all employees and applicants without regard to any status that is protected by law. Please click here to see the policy.

Schwab is an affirmative action employer, focused on advancing women, racial and ethnic minorities, veterans, and individuals with disabilities in the workplace. If you have a disability and require reasonable accommodations in the application process, contact Human Resources at or call .

TD Ameritrade, a subsidiary of Charles Schwab, is an Equal Opportunity Employer. At TD Ameritrade we believe People Matter. We value diversity and believe that it goes beyond all protected classes, thoughts, ideas, and perspectives.

  • ID: #44466992
  • State: Colorado Lonetree 80124 Lonetree USA
  • City: Lonetree
  • Salary: USD TBD TBD
  • Job type: Permanent
  • Showed: 2022-07-29
  • Deadline: 2022-09-26
  • Category: Et cetera