At U.S. Bank, the business problem is to enhance financial decision-making for customers and businesses by leveraging data analysis and reporting to identify trends, interpret patterns, and provide actionable insights and recommendations.
Requirements
- 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.
- Additional experience with other programming languages such as Visual Basic and/or Python
- Job Scheduling and Automation with tools such as Autosys
Responsibilities
- 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.
- 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
Other
- Bachelor's degree, or equivalent work experience
- Typically more than five years of applicable experience
- Payment Services business knowledge
- Specific Anti-Money Laundering (AML) knowledge such as Know-Your-Customer (KYC)
- Knowledge of Change Management and Software Development Life Cycle (SDLC)
