Senior Data Engineer

Job Description

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

• 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/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

• 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…