Senior Data Engineer (multiple positions) in San Francisco, CA.

US Bank • San Francisco, CA

294d • $143,790 - $194,500 • Remote

About The Position

U.S. Bank is seeking the position of Senior Data Engineer (multiple positions) in San Francisco, CA. This role involves designing and developing data models, data ingestion architecture, and transformation pipelines for data warehouse. The position also requires reworking existing ETL pipelines and related data infrastructure to improve reliability and scalability, implementing data quality monitoring checks, and promoting operational excellence best practices. Additionally, the role includes designing, analyzing, and creating complex SQL queries, as well as developing new customer requirements in collaboration with cross-functional business teams.

Requirements

• Master's degree in Computer Science, Information Systems, or a related field.
• 2 years of experience as a Data Warehousing Specialist, or in a related occupation.
• 2 years of experience with constructing Java-based data pipelines.
• 2 years of experience writing SQL queries.
• 2 years of experience building cloud-based AWS infrastructure.
• 2 years of experience developing Apache Spark based pipelines for ETL and business reporting.
• 2 years of experience with Apache Oozie, Hadoop, Process Orchestration, and Python.
• 2 years of experience with data migration using PostgreSQL.
• 2 years of experience building dashboards using Druid.

Responsibilities

• Design and develop data models, data ingestion architecture, and transformation pipelines for data warehouse.
• Rework existing ETL pipelines and related data infrastructure to improve reliability and scalability.
• Implement data quality monitoring checks and promote operational excellence best practices.
• Design, analyze, and create complex SQL queries.
• Develop new customer requirements in collaboration with cross-functional business teams.
• Construct SQL data models needed to actualize the business strategies.

Benefits

• Healthcare (medical, dental, vision)
• Basic term and optional term life insurance
• Short-term and long-term disability
• Pregnancy disability and parental leave
• 401(k) and employer-funded retirement plan
• Paid vacation (from two to five weeks depending on salary grade and tenure)
• Up to 11 paid holiday opportunities
• Adoption assistance
• Sick and Safe Leave accruals of one hour for every 30 worked, up to 80 hours per calendar year unless otherwise provided by law

What This Job Offers

• Career Level: Mid Level
• Industry: Credit Intermediation and Related Activities
• Education Level: Master's degree