Data Analyst

$90,100 - $106,000/Yr

US Bank - Minneapolis, MN

Full-time - Mid Level

Minneapolis, MN

Credit Intermediation and Related Activities

About the position

The Data Analyst position at U.S. Bank involves collecting and reporting data from various backend payment services systems and databases. The role focuses on analyzing query results to identify data risks as defined by U.S. Bank's financial crimes programs. The analyst will support the Payment Services CRO FCC programs through metrics reporting and analytical work, utilizing technology to enhance risk management and implement efficient controls.

Responsibilities

• Collect and report data from multiple backend payment services systems and databases through query development.
• Analyze query results and identify data risks defined by U.S. Bank financial crimes 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.

Requirements

• Bachelor's degree or equivalent work experience.
• Four to five years of data analysis experience.
• 4-5+ years of experience in SQL Query development.
• Experience in one or more databases such as SQL Server, Azure, Oracle, Hive/Hadoop.
• Experience in SQL or other BI tools for querying data and for data manipulation/transformation.
• Experience in one or more query development tools such as SQL Management Studio (SSMS), Azure Data Studio, Toad Data Point, or SAS.
• 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.

Nice-to-haves

• 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).
• 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.
• Ability to develop and maintain strategic partnerships with senior business unit management, business partners, and project sponsors.

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