Financial Systems Analyst

at  US Bank National Association

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

Responsible for data analysis and testing in conjunction with development, automation, enhancement and maintenance of Oracle based processes that support the bank’s managerial and regulatory reporting activities.

• Responsibilities range from researching and analyzing data, including test data, to identifying and implementing process enhancements to developing new PL/SQL code depending on business needs or regulatory reporting product.
• Must be detail oriented and adept at problem solving, analyzing large data sets with the ability to drill into detailed anomalies as well as understanding overall business or regulatory reporting use of data-driven results.
• Additional responsibilities include monitoring and supporting daily and month-end processing and troubleshooting and resolving issues as necessary.

Basic Qualifications -

Bachelor’s degree in MIS, CIS, CS, Statistics, Math, Accounting, Finance or Economics, or equivalent work experience

• Typically, eight or more years of related experience

Preferred Skills/Experience

• 2+ years of experience in financial data processing
• Advanced analytical skills
• Considerable knowledge of financial systems and analysis
• Intermediate understanding of accounting principles
• Experience with federal regulatory reporting filings (2052a, FDIC370, Basel, SCCL, etc.)
• Considerable reconciliation experience between company general ledger and source applications
• Experience with data warehousing principles including indexing, partitioning, table space allocation, compression, etc.
• Experience with Oracle PL/SQL including views, stored procedures, functions
• Experience in PL/SQL tuning for business processes moving/processing large data sets (50mm+ volumes).
• Ability to identify and resolve exceptions and to analyze data
• Considerable knowledge of various computer applications, programming, hardware, software and systems design
• Advanced certifications preferred

The role is posted as remote; however, candidates who are located near any one of our locations would be required to work on site at least three 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.

Responsible for data analysis and testing in conjunction with development, automation, enhancement and maintenance of Oracle based processes that support the bank’s managerial and regulatory reporting activities.

• Responsibilities range from researching and analyzing data, including test data, to identifying and implementing process enhancements to developing new PL/SQL code depending on business needs or regulatory reporting product.
• Must be detail oriented and adept at problem solving, analyzing large data sets with the ability to drill into detailed anomalies as well as understanding overall business or regulatory reporting use of data-driven results.
• Additional responsibilities include monitoring and supporting daily and month-end processing and troubleshooting and resolving issues as necessary

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 (some may vary based on role, location or hours):

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