Overview
On Site
USD 152,000.00 - 168,000.00 per year
Full Time
Skills
Creative Problem Solving
Asset Management
Software Asset Management
Finance
Research
Wealth Management
Software Development
Testing
.NET
Retail
Database Design
Query Optimization
Impact Analysis
Snow Flake Schema
Data Storage
Data Management
Corrective Maintenance
Incident Management
Operational Excellence
Performance Testing
Data Quality
Collaboration
Operating Systems
Application Development
Data Integrity
Capacity Management
Science
Computer Science
Data Engineering
PostgreSQL
Database Administration
Semantics
Optimization
PL/SQL
SQL
Performance Tuning
Disaster Recovery
Replication
Backup
Recovery
Scripting
Unix
Technical Support
Multitasking
Agile
Scrum
Innovation
Atlassian
JIRA
Confluence
HipChat
Bamboo
Bitbucket
Database
Oracle
MongoDB
Microsoft SQL Server
MySQL
Tableau
Extract
Transform
Load
Informatica
Cloud Computing
Problem Solving
Conflict Resolution
Job Details
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 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
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 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
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.