Senior Data Engineer

U.S. Bank • Hopkins, MN

7d • Onsite

About The Position

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. 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.

Requirements

• Bachelor’s degree, or equivalent work experience
• 5 + years of relevant experience
• Strong hands‑on experience with Microsoft SQL Server (SQL Server 2019/2022 preferred) in enterprise, high‑volume environments
• Proven ability to design and implement complex, high‑performance relational data structures, including metadata‑driven and workflow‑centric schemas
• Practical experience with SQL Service Broker, including queue usage and basic operational troubleshooting
• Working knowledge of Memory‑Optimized Tables (In‑Memory OLTP) and associated performance and concurrency considerations
• Medium‑level experience with .NET / C#, specifically for: Data access and persistence patterns, Efficient database interaction from applications, Debugging data‑access issues between application and database layers
• Demonstrated ability to debug and resolve production data issues, including: Query performance bottlenecks, Blocking and deadlocks, Failures in asynchronous or event‑driven processing
• Experience supporting reporting and analytics sourced from transactional systems
• Solid understanding of database operations and maintenance, including indexing, statistics, and capacity considerations
• Exposure to cloud‑managed SQL platforms (AWS RDS and/or Azure SQL) with awareness of differences from on‑prem SQL Server

Responsibilities

• 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.
• 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
• 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
• 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
• 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
• 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/DR and failover scenarios, Reduce repeat data‑layer incidents
• Participate in on‑call rotations or escalation coverage as appropriate for a senior‑level role
• Ensure new data‑layer implementations meet operability and supportability standards before release

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

• Job Type: Full-time
• Career Level: Senior
• Education Level: Associate degree