Sr Data Warehouse Analyst

Us Bank; Englewood (CO); Hybrid; USD 105,000 - 124,000; Full time

Benefits offered by this job

Healthcare

Life Insurance

Disability

Parental Leave

401(k)

Paid Vacation

Paid Holidays

Adoption assistance

Sick Leave

Job summary

U.S. Bank is seeking a senior data engineer to design, develop, and maintain enterprise-scale data warehouse, data lake, and lakehouse solutions. You will optimize ETL/ELT pipelines, model data, and ensure governance across AWS/Azure/GCP environments.

Collaborate with stakeholders to enable BI, analytics, and AI initiatives, while monitoring performance and data quality in a large, regulated environment.

Qualifications

• Bachelor's degree or equivalent work experience.
• At least 5 years experience with tools, facilities and techniques for managing and administering data.

Responsibilities

• Design, develop, and maintain enterprise-scale Data Warehouse, Data Lake, and Lakehouse solutions.
• Build and enhance scalable data models, database architectures, and data storage frameworks.
• Develop, optimize, and support batch, streaming, and near real-time ETL/ELT pipelines.
• Integrate and manage data from multiple sources ensuring quality.
• Implement and support ETL/data integration platforms (Informatica, IBM DataStage, or similar).
• Partner with stakeholders to deliver scalable, high-performing data solutions.
• Enable BI, analytics, and AI/ML use cases by preparing datasets for enterprise use.
• Monitor and tune data platforms for availability and performance.
• Implement cloud-based data solutions on AWS, Azure, or GCP.
• Apply data governance, security, privacy, compliance, metadata management.

Skills

Data Engineering

Data Warehousing

ETL/ELT Development

Data Integration

Data Management

SQL

Python

Cloud Platforms

Apache Spark

Databricks

Airflow

Git

CI/CD

DevOps

AI Tools

Data Governance

Education

Bachelor's degree or equivalent

Tools

Informatica

IBM DataStage

AWS

Azure

GCP

Job description

At U.S. Bank, we’re on a journey to do our best. Helping the customers and businesses we serve to make better and smarter financial decisions and enabling the communities we support to grow and succeed. We believe it takes all of us to bring our shared ambition to life, and each person is unique in their potential. A career with U.S. Bank gives you a wide, ever-growing range of opportunities to discover what makes you thrive at every stage of your career. Try new things, learn new skills and discover what you excel at—all from Day One.

Job Description

Key Responsibilities

• Design, develop, and maintain enterprise-scale Data Warehouse, Data Lake, and Lakehouse solutions supporting operational reporting, analytics, and AI/ML initiatives.

• Build and enhance scalable data models, database architectures, and data storage frameworks to support business, analytical, and operational requirements.

• Develop, optimize, and support batch, streaming, and near real-time ETL/ELT pipelines using SQL, Python, cloud-native services, and modern data integration technologies.

• Integrate, transform, and manage structured, semi-structured, and unstructured data from multiple internal and external data sources while ensuring data quality and reliability.

• Implement and support enterprise data integration solutions utilizing Informatica, IBM DataStage, or similar ETL/data integration platforms.

• Partner with business stakeholders, analysts, architects, and application teams to gather requirements and deliver scalable, high-performing data solutions.

• Enable business intelligence, advanced analytics, and AI/ML use cases by preparing, optimizing, and governing datasets for enterprise consumption.

• Monitor, troubleshoot, and tune data platforms and pipelines to ensure high availability, performance, scalability, automation, and operational excellence.

• Implement and support cloud-based data solutions leveraging AWS, Microsoft Azure, or Google Cloud Platform (GCP) services.

• Apply enterprise standards for data governance, security, privacy, compliance, and metadata management to protect organizational data assets.

Basic Qualifications

-Bachelor's degree or equivalent work experience
-At least 5 years experience with tools, facilities and techniques for managing and administering data.

Preferred Skills/Experience

• Hands on experience in Data Engineering, Data Warehousing, ETL/ELT Development, Data Integration, or Data Management roles.

• Advanced proficiency in SQL with hands-on experience in data modeling, database design, query optimization, and performance tuning.

• Strong programming experience with Python for data processing, automation, orchestration, and engineering solutions.

• Experience designing and supporting modern Data Warehouse, Data Lake, Lakehouse, and distributed data architectures.

• Hands-on experience with at least one major cloud platform: AWS, Microsoft Azure, or Google Cloud Platform (GCP).

• Experience developing scalable ETL/ELT pipelines using SQL, Python, cloud-native services, and enterprise integration tools.

• Knowledge of modern big data and orchestration technologies such as Apache Spark, Databricks, Airflow, or related platforms.

• Experience with Git, GitHub, Azure DevOps, CI/CD pipelines, and DevOps best practices for data engineering.

• Understanding of data governance, data quality, security, privacy, compliance, and metadata management principles.

• Familiarity with AI-assisted development tools such as GitHub Copilot, ChatGPT, Claude, or similar productivity solutions, along with strong analytical, problem-solving, communication, and stakeholder management skills.

Location expectations

This role requires working from a U.S. Bank location three (3) or more days per week.

If there’s anything we can do to accommodate a disability during any portion of the application or hiring process, please refer to our disability accommodations for applicants.

Benefits:

Our approach to benefits and total rewards considers our team members’ whole selves and what may be needed to thrive in and outside work. That's why our benefits are designed to help you and your family boost your health, protect your financial security and give you peace of mind. Our benefits include the following:

• 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

Review our full benefits available by employment status here.

U.S. Bank is an equal opportunity employer. We consider all qualified applicants without regard to race, religion, color, sex, national origin, age, sexual orientation, gender identity, disability or veteran status, and other factors protected under applicable law.

E-Verify

U.S. Bank participates in the U.S. Department of Homeland Security E-Verify program in all facilities located in the United States and certain U.S. territories. The E-Verify program is an Internet-based employment eligibility verification system operated by the U.S. Citizenship and Immigration Services. Learn more about the E-Verify program.

Pay Range: $105,400.00 - $124,000.00

U.S. Bank will consider qualified applicants with arrest or conviction records for employment. U.S. Bank conducts background checks consistent with applicable local laws, including the Los Angeles County Fair Chance Ordinance and the California Fair Chance Act as well as the San Francisco Fair Chance Ordinance. U.S. Bank is subject to, and conducts background checks consistent with the requirements of Section 19 of the Federal Deposit Insurance Act (FDIA). In addition, certain positions may also be subject to the requirements of FINRA, NMLS registration, Reg Z, Reg G, OFAC, the NFA, the FCPA, the Bank Secrecy Act, the SAFE Act, and/or federal guidelines applicable to an agreement, such as those related to ethics, safety, or operational procedures.

Applicants must be able to comply with U.S. Bank policies and procedures including the Code of Ethics and Business Conduct and related workplace conduct and safety policies.

Posting may be closed earlier due to high volume of applicants.