About the Role
This newly created role will support the future growth of the Wealth and Asset Management (WAM) Engineering organization, specifically within the Wealth & Advice Solutions (WAS) business. As a seasoned, hands-on Senior Data Engineer, you will enable consistent, predictable, high-quality delivery by implementing best practices, tools, metrics, and automation frameworks. You will deliver high-quality solutions that meet business objectives in a flexible, collaborative, and rapidly changing environment, playing a critical role in supporting key stakeholders across the WAS organization.
Responsibilities
- Define and maintain conceptual, logical, and physical database models by working with business stakeholders and identifying optimal database specifications.
- Ensure 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 increasing application performance.
- Enhance and recommend solutions/processes for downstream impact analysis associated with data and/or model changes.
- Support, maintain, and enhance applications written with ETL tools such as Informatica, Airflow, Snowflake, and custom ingestion and transformation processes.
- Collaborate with enterprise stakeholders to implement and adhere to data storage standards and maintain catalogs for consistent data management practices.
- Establish data quality metrics and monitoring processes to proactively identify and resolve data quality issues.
- Work with various IT departments to perform preventive and corrective maintenance and incident management measures.
- Ensure database integrity, availability, and restorability by working with enterprise operational excellence teams.
- Evaluate the integration of new tools or technologies based on existing infrastructure capabilities.
- Recommend solutions and assist with functional and performance testing needs, including mock data, test environments, and data refresh processes.
- Coordinate the planning for installation of operating systems, databases, applications, development upgrades, and new releases.
- Follow and develop database standards, guidelines, and best practices.
- Establish standards, controls, and procedures to ensure data integrity and security.
- Perform capacity planning and projection for future growth.
- 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 of development experience.
- 3+ years of experience with Postgres database management.
- Experience with Oracle, SQL Server, MySQL, and/or Mongo DB.
- Experience working 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 writing scripts.
- Provide database technical support for Technology and Application Delivery projects.
- Excellent written and verbal communication 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.
- Familiarity with Agile Methodologies, such as Scrum.
- 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 visualization tools such as Tableau.
- Exposure to ETL tools such as Informatica Intelligent Cloud Solutions.
- Excellent judgment, organizational, and problem-solving skills.
Skills
- Informatica
- Airflow
- Snowflake
- SQL
- PL/SQL
- No SQL
- Unix scripting
- Postgres
- Oracle
- SQL Server
- MySQL
- Mongo DB
- Tableau
- Jira
- Confluence
- HipChat
- Bamboo
- Bitbucket
Location
- Remote
Work Type
- Full-time
Experience Level
- Senior
Education Level
- Bachelor of Science in Computer Science or a related field
About the Company
- 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.
