Payments Risk Data Analyst

US Bank; Minneapolis (MN); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Healthcare (medical, dental, vision)

401(k) and employer-funded retirement

Paid vacation and holidays

Parental leave

Sick leave

Adoption assistance

Disability insurance

Job summary

U.S. Bank seeks a data reporting expert to lead complex reporting projects, aggregating data from multiple sources, performing in-depth analysis, and delivering actionable insights for business and customer populations.

You will develop queries, assess data risks, and support FCC programs with metrics and analytics. The role requires 5+ years of experience, a Bachelor's degree, and comfort working in a hybrid schedule with in-office presence three days plus per week.

Qualifications

• Bachelor's degree or equivalent work experience.
• Typically more than five years of applicable experience.

Responsibilities

• Collect and report data from multiple backend payment services systems and databases through developed queries.
• Analyze query results and identify data risks defined by FCC programs/policies.
• Provide support to Payment Services CRO FCC programs via metrics reporting and analytics.
• Utilize technology to enhance risk management and implement controls.

Skills

SQL Query development

Python

Visual Basic

Autosys

SDLC

Change Management

Tableau/Power BI

Data analysis

Communication

Problem solving

Education

Bachelor's degree

Tools

SQL Management Studio (SSMS)

VS Code

Toad Data Point

SQuirreL

Visual Studio SSIS

Tableau

Power BI

Hive/Hadoop

Azure

SQL Server

Job description

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 complex reporting projects that gather and integrate large volumes of data, performs in depth analysis, interprets results and develops actionable insights and recommendations for use across the company for customer and employee populations. Acquires data from multiple data sources in order to perform analysis and reporting. Identifies, analyzes and interprets trends or patterns in complex data in order to provide answers to business questions as well as provide recommendations for action.

The role offers a hybrid/flexible schedule, which means there's an in-office expectation of 3 or more days per week and the flexibility to work outside the office location for the other days.

Position Highlights

• Responsible for collecting and reporting data from multiple backend payment services systems and databases through the development of queries
• Analyze query results and identify data risks defined by U.S. Bank financial crimes (FCC) programs/policies
• Provide support to the overall Payment Services CRO FCC programs through metrics reporting and analytical work
• Utilize technology to increase Payment Services ability to manage risk and implement efficient controls

Basic Qualifications

• Bachelor's degree, or equivalent work experience
• Typically more than five years of applicable experience

Highly Desired Skills and Experience

• Payment Services business knowledge
• Specific Anti-Money Laundering (AML) knowledge such as Know-Your-Customer (KYC)
• Additional experience with other programming languages such as Visual Basic and/or Python
• Job Scheduling and Automation with tools such as Autosys
• Knowledge of Change Management and Software Development Life Cycle (SDLC)

Preferred Skills and Experience

• Ability to work in a dynamic, fast changing environment
• Very comfortable with Ambiguity
• Self-learner who can produce results with minimal guidance
• Excellent interpersonal, verbal, and written communication skills
• Ability to communicate effectively with both technical and non-technical audiences such as senior business unit management, business partners, project sponsors, development teams, end users, and product owners
• 4-5+ years of experience in SQL Query development
• Experience in one or more databases such as SQL Server, Azure, Oracle, Hive/Hadoop for querying data and for data manipulation/transformation
• Experience in one or more query development tools such as SQL Management Studio (SSMS), VS Code, Toad Data Point, or SQuirreL
• Experience in developing complex ETL workflows with tools such as Visual Studio SSIS
• Experience in one or more reporting tools such as Tableau, Power BI, etc.
• Experience in financial services, with thorough knowledge of HR systems or financial services products, customers, transactions and interaction data
• Highly detail-oriented analytic skills with the ability to extract, collect, organize, analyze and interpret results for insights
• Strong decision-making, problem-solving, organization, and project management skills

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

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 th