Senior Data Engineer

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

Be a part of transformational change where integrity matters, success inspires and great teams collaborate and innovate. As the fifth-largest bank in the United States, we’re one of the country's most respected, innovative, ethical and successful financial institutions. We’re looking for people who want more than just a job – they want to make a difference! U.S. Bank is seeking a Software Engineer who will contribute toward the success of our technology initiatives in our digital transformation journey.  The Senior Data Engineer will be responsible for the analysis, design, testing, development and maintenance of best-in-class software experiences. The candidate is a self-motivated individual who can collaborate with a team and across the organization. The candidate takes responsibility of the software artifacts produced adhering to U.S. Bank standards to ensure minimal impact to the customer experience. The candidate will be adept with the agile software development lifecycle and DevOps principles.

The Senior Data Engineer is responsible for building, enhancing, and operating the MIR Data Platform in partnership with the MIR Technical Architect.

This role focuses on implementing high‑performance, relational data solutions, supporting event‑driven processing, enabling reporting and audit use cases, and contributing to the platform’s cloud‑readiness journey.

The ideal candidate is a hands‑on Senior Data Engineer with strong SQL Server expertise who is comfortable working in high‑volume, workflow‑driven environments, debugging complex data issues, and growing into deeper architectural ownership over time.

Key Responsibilities:

• Data Engineering & Modeling

• Design, implement, and maintain logical and physical data structures within the MIR Data Layer

• Build and evolve metadata‑driven schemas supporting:

  • Document metadata

  • Transaction and workflow state

  • Event based and audit data

• Reporting and analytics use cases

• Apply established MIR data patterns while contributing improvements over time.

• High‑Performance & Scalable Data Design

• Implement data solutions that support large‑scale, concurrent workloads

• Optimize schemas, indexes, and access patterns to improve throughput and latency

• Leverage Memory‑Optimized Tables (In‑Memory OLTP) for performance‑critical paths where appropriate, under architectural guidance

• Event driven & Asynchronous Processing

• Implement and support event‑driven data processing within the MIR Data Layer

• Work with SQL Service Broker queues and services, including:

  • Asynchronous processing

  • Status tracking and reconciliation

  • Retry and error‑handling patterns

• Help ensure event processing is idempotent, traceable, and operationally reliable

• Reporting & Audit Enablement

• Build data structures that enable enterprise reporting and analytics without impacting transactional workloads

• Support snapshotting and reporting‑friendly schemas for downstream consumers

• Assist in ensuring audit data is accurate, consistent, and compliant with regulatory expectations

• Cloud Migration & Modernization

• Contribute to cloud‑readiness efforts for the MIR Data Layer

• Support migration and proof‑of‑concept work targeting:

  • Amazon RDS for SQL Server

  • Azure SQL Database / Azure SQL Managed Instance

• Help adapt data designs to managed‑platform constraints while preserving performance and correctness

• Operational Expectations:

  • Participate in production readiness, stability, and incident resolution for the MIR Data Layer

• Debug and resolve complex production issues, including:

  • Performance degradation

  • Blocking, deadlocks, and resource contention

  • Event based or Service Broker processing failures

• Partner closely with DBAs, SRE, and platform teams to:

  • Improve monitoring and alerting

  • Support HA/