Senior Data Engineer Job at Charles Schwab (Southlake, TX)

Job Description

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.

Job Responsibility

Define and maintain conceptual, logical, and physical database models by working with business stakeholders
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
Be able to work in an Agile Scrum environment

Requirements

Bachelor of Science in Computer Science or a related field
At least 7+ years of data engineering experience
5+ years development experience
3 years or more experience with Postgres database management
Experience with Oracle, SQL Server, MySQL, and/or Mongo DB
Must have worked 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

Nice to have

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

What we offer

401(k) with company match and Employee stock purchase plan
Paid time for vacation, volunteering, and 28-day sabbatical after every 5 years of service for eligible positions
Paid parental leave and family building benefits
Tuition reimbursement
Health, dental, and vision insurance

Charles Schwab - All Job Offers

Select Country

Senior Data Engineer

Job Description

Job Responsibility

Requirements

Nice to have

What we offer

Looking for more opportunities?