Senior Data Engineer at Charles Schwab Inc. | US | Rezi

Senior Data Engineer at Charles Schwab Inc.

Senior Data Engineer

Charles Schwab Inc. · US

Today

Senior Data Engineer

Charles Schwab Inc. · US

5 hours ago
Resume preview

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

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.