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 DescriptionBe 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 & ModelingDesign, implement, and maintain logical and physical data structures within the MIR Data LayerBuild and evolve metadata‑driven schemas supporting:Document metadataTransaction and workflow stateEvent based and audit dataReporting and analytics use casesApply established MIR data patterns while contributing improvements over time.High‑Performance & Scalable Data DesignImplement data solutions that support large‑scale, concurrent workloadsOptimize schemas, indexes, and access patterns to improve throughput and latencyLeverage Memory‑Optimized Tables (In‑Memory OLTP) for performance‑critical paths where appropriate, under architectural guidanceEvent driven & Asynchronous ProcessingImplement and support event‑driven data processing within the MIR Data LayerWork with SQL Service Broker queues and services, including:Asynchronous processingStatus tracking and reconciliationRetry and error‑handling patternsHelp ensure event processing is idempotent, traceable, and operationally reliableReporting & Audit EnablementBuild data structures that enable enterprise reporting and analytics without impacting transactional workloadsSupport snapshotting and reporting‑friendly schemas for downstream consumersAssist in ensuring audit data is accurate, consistent, and compliant with regulatory expectationsCloud Migration & ModernizationContribute to cloud‑readiness efforts for the MIR Data LayerSupport migration and proof‑of‑concept work targeting:Amazon RDS for SQL ServerAzure SQL Database / Azure SQL Managed InstanceHelp adapt data designs to managed‑platform constraints while preserving performance and correctnessOperational Expectations:Participate in production readiness, stability, and incident resolution for the MIR Data LayerDebug and resolve complex production issues, including:Performance degradationBlocking, deadlocks, and resource contentionEvent based or Service Broker processing failuresPartner closely with DBAs, SRE, and platform teams to:Improve monitoring and alertingSupport HA/DR and failover scenariosReduce repeat data‑layer incidentsParticipate in on‑call rotations or escalation coverage as appropriate for a senior‑level roleEnsure new data‑layer implementations meet operability and supportability standards before releaseBasic Qualifications:Bachelor’s degree, or equivalent work experience5 + years of relevant experienceRequired Skills & Experience:Strong hands‑on experience with Microsoft SQL Server (SQL Server 2019/2022 preferred) in enterprise, high‑volume environmentsProven ability to design and implement complex, high‑performance relational data structures, including metadata‑driven and workflow‑centric schemasPractical experience with SQL Service Broker, including queue usage and basic operational troubleshootingWorking knowledge of Memory‑Optimized Tables (In‑Memory OLTP) and associated performance and concurrency considerationsMedium‑level experience with .NET / C#, specifically for:Data access and persistence patternsEfficient database interaction from applicationsDebugging data‑access issues between application and database layersDemonstrated ability to debug and resolve production data issues, including:Query performance bottlenecksBlocking and deadlocksFailures in asynchronous or event‑driven processingExperience supporting reporting and analytics sourced from transactional systemsSolid understanding of database operations and maintenance, including indexing, statistics, and capacity considerationsExposure to cloud‑managed SQL platforms (AWS RDS and/or Azure SQL) with awareness of differences from on‑prem SQL ServerThis 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 insuranceShort-term and long-term disabilityPregnancy disability and parental leave401(k) and employer-funded retirement planPaid vacation (from two to five weeks depending on salary grade and tenure)Up to 11 paid holiday opportunitiesAdoption assistanceSick and Safe Leave accruals of one hour for every 30 worked, up to 80 hours per calendar year unless otherwise provided by lawReview 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-VerifyU.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.00U.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.SummaryLocation: Hopkins, MN; Irving, TXType: Full time