Senior Data Engineer

The Charles Schwab Corp

Austin, TX

JOB DETAILS
SKILLS
Agile Programming Methodologies, Analysis Skills, Asset Management, Atlassian JIRA, Automation, Best Practices, Business Support, Capacity Management, Cloud Computing, Computer Science, Data Management, Data Modeling, Data Quality, Data Recovery, Data Storage, Data Visualization Tools, Database Administration, Database Backup, Database Design, Database Extract Transform and Load (ETL), Database Optimization, Database Programming, Database Recovery, Database Technology, Disaster Recovery, Engineering, Finance, Functional Testing, High Net Worth, Identify Issues, Incident Management, Informatica, Information/Data Security (InfoSec), Metrics, Microsoft SQL Server, MongoDB, Multitasking, MySQL, Network Operations Center, NoSQL, Oracle, Oracle Database, Oracle PL-SQL, Organizational Skills, Performance Management, Performance Testing, Performance Tuning/Optimization, PostgreSQL, Presentation/Verbal Skills, Preventative Maintenance, Problem Solving Skills, Quality Metrics, Quality Monitoring, Query Optimization, Replication and Remote Mirroring, Requirements Validation/Verification, Retail, SQL (Structured Query Language), Scrum Project Management and Software Development, Software Administration, Software Design, Software Development, Software Testing, Software Upgrades, Standards Development, System Validation, Systems Administration/Management, Tableau, Team Player, Technical Delivery, Technical Strategy, Technical Support, Unix Operating Systems, Unix Shell Programming, Wealth Management, Writing Skills
LOCATION
Austin, TX
POSTED
30+ days ago

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

Wealth and Asset Management (WAM) Engineering is an organization within Schwab Technology Services aligned to support the technology needs of Schwab Asset Management (SAM), Wealth & Advice Solutions (WAS), the Schwab Center for Financial Research (SCFR), and Third-Party Platform teams. Wealth Management Engineering (WME), an organization within WAM Engineering, is dedicated to providing support to WAS which is a growth area for Schwab.

This newly created role will support the future growth of the WAS business. As a seasoned, hands-on Senior Data Engineer, you will enable WME to achieve consistent, predictable, high-quality delivery by implementing best practices, tools, metrics, automation frameworks, and provide oversight in the areas of software development and testing. You'll serve as a strong and versatile hands-on technical engineer. You will deliver high-quality solutions that meet business objectives in a flexible, collaborative, and rapidly changing environment.

You will play a critical role in supporting key stakeholders across the WAS organization which is focused on high-net worth and ultra-high net worth retail investors. Supported business functions span Schwab's Wealth and Investment Solutions including Schwab Wealth Advisory. You will be working with a team of talented and highly motivated technologists that strive to make technology a strategic differentiator for Schwab's WAS business and their clients.

What you have

Define and maintain conceptual, logical, and physical database models by working with business stakeholders and identifying optimal database specifications. Ensures that database design and system capabilities meet validated user requirements. Work with application development teams designing, developing, and enhancing database schemas, creating database views, helping with query optimization, and figuring out ways to increase application performance. Enhance and recommend solutions / processes for downstream impact analysis associated with data and/or model changes. Support, maintain and enhance applications (when necessary) written with ETL tools such as Informatica, Airflow, Snowflake and additionally support teams using custom ingestion and transformation processes. Collaborate with enterprise stakeholders to implement and adhere to data storage standards and maintain catalogs to facilitate consistent data management practices. Establish data quality metrics and monitoring processes to proactively identify and resolve data quality issues. Work with various IT departments within Schwab to perform preventive and corrective maintenance and incident management measures. Ensure database integrity, availability, and restorability by working with enterprise operational excellence teams. Evaluates the integration of new tools or technologies based on the capabilities of the existing infrastructure. Recommend solutions and help with functional and performance testing needs (mock data, test environments, data refresh processes). Responsible for coordination of planning the installation of operating systems, databases, applications, development upgrades, and new releases. Follow and develop database standards, guidelines, and best practices. Establishes standards, controls, and procedures to ensure data integrity and security. Perform capacity planning and projection for future growth. And finally, be able to work in an Agile Scrum environment.

Required qualifications:

  • Bachelor of Science in Computer Science or a related field
  • The ideal candidate should have at least 7+ years of data engineering experience, 5+ years development experience and 3 years or more experience with Postgres database management. The candidate must additionally have experience with Oracle, SQL Server, MySQL, and/or Mongo DB.
  • Must have worked as alongside a business vertical to establish nomenclature, data catalogs, provenance, standards, semantics and usage of data.
  • Deep knowledge and experience with query development and optimization (SQL, PL/SQL, and No SQL)
  • Experience in performance-tuning database applications is a MUST.
  • Experience in multi-datacenter DB installations, disaster recovery, and replication techniques.
  • Advanced knowledge of database backup and recovery strategies
  • Ability to work in a Unix environment including an ability to write scripts in Unix.
  • Provide database technical support for Technology and Application Delivery projects.
  • Must have excellent written and verbal communications skills.
  • Ability to multitask and work well under pressure.
  • In-depth knowledge of troubleshooting skills and out-of-the-box thinking to overcome data obstacles.

Preferred qualifications:

  • Familiarity with Agile Methodologies, such as Scrum.
  • You are driven by innovation and a commitment to lifelong learning.
  • Experience or familiarity with Atlassian suite of products (Jira, Confluence, HipChat, Bamboo, Bitbucket)
  • Exposure to various flavors of databases Postgress, Oracle, Mongo, SQL Server, MySQL.
  • Exposure to data visualizations tools such as Tableau
  • Exposure to ETL tools such as Informatica Intelligent Cloud Solutions
  • Excellent judgment, organizational and problem-solving skills

About the Company

T

The Charles Schwab Corp

The Charles Schwab Corporation is a leading provider of financial services, with more than 300 offices. Through its operating subsidiaries, the company provides a full range of securities brokerage, banking, money management and financial advisory services to individual investors and independent investment advisors. Named "Highest in Investor Satisfaction with Self-Directed Services" by J.D. Power and Associates in 2009, its broker-dealer subsidiary, Charles Schwab & Co., Inc. (member SIPC) affiliates offer a complete range of investment services and products including an extensive selection of mutual funds; financial planning and investment advice; retirement plan and equity compensation plan services; referrals to independent fee-based investment advisors; and custodial, operational and trading support for independent, fee-based investment advisors through Schwab Advisor Services.

The Charles Schwab Bank (member FDIC) provides banking and mortgage services and products. To meet the needs of our clients, we are actively recruiting people with the desire, drive and creativity to find solutions that help meet our clients' needs; who want the chance to learn, grow with the company and explore their career opportunities; who will strive for excellence in achieving our clients' and our company's goals; who have the highest ethical standards - individuals who take pride in making a difference in people's lives.
COMPANY SIZE
1,000 to 1,499 employees
INDUSTRY
Security and Surveillance
FOUNDED
1971
WEBSITE
http://www.aboutschwab.com/careers