Senior Data Engineer
Role details
Job location
Tech stack
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., * 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
Requirements
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., * 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
Benefits & conditions
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.
The salary range reflects figures based on the primary location, which is listed first. The actual range for the role may differ based on the location of the role. In addition to salary, U.S. Bank offers a comprehensive benefits package, including incentive and recognition programs, equity stock purchase 401(k) contribution and pension (all benefits are subject to eligibility requirements). Pay Range: $119,765.00 - $140,900.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.