U.S. Bank Data & Reporting Analyst (SAS, SQL and Hadoop) - Charlotte, Minneapolis, Cincinnati or Irvine, CA Only in Irvine, California
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.
The Data and Reporting Analyst will be a member of the Consumer and Business Banking (CBB) Financial Crimes Control (FCC) Reporting and Analytics team responsible for gathering and integrating large volumes of data focused on Anti-Money Laundering/Bank Secrecy Act/Know Your Customer, performing analysis, interpreting results and developing actionable insights to accelerate operational excellence, demonstrate compliance and mitigate risk.
Provide routine and ad hoc reporting tied to AML/BSA/KYC compliance and risk.
Develop and maintain routine reporting.
Provide guidance for other team members.
Learn new technology.
Gather and aggregate complex data from multiple, disparate data sources.
Understand data cycle/data flow between processes, systems, and data sources.
Identify trends, patterns and/or outliers in data using various statistical techniques and tools.
Leverage data and conduct root cause analysis to identify gaps, raise issues and propose solutions to mitigate risk.
Present data and analysis in a clear and concise manner allowing the audience to quickly understand the results and recommendations so they can make informed data driven decisions.
Collaborate with various partners to provide a holistic view of the analysis. Measure and monitor results of applied recommendations and present adjustments.
Develop insightful and compelling summary reporting and dashboards for management and business line partners.
Ensure all data acquisition and sharing aligns with company standards and policies.
Partner with various groups to improve data collection and integration.
Create and maintain documented procedures for routine responsibilities.
Provide support to the weekly batch process on weekends when on call.
Bachelor's degree, or equivalent work experience
Typically more than six years of applicable experience
Requires experience using SQL and SAS programming (and a preference for experience with Hadoop/Presto) for querying data and for data manipulation/transformation
Experience in advanced analytics and statistics
Strong analytic skills and problem solving with the ability to extract, collect, organize, analyze and interpret trends or patterns in complex data sets
Experience supporting AML/BSA/KYC, Customer Due Diligence, economic sanctions/OFAC or other compliance related initiatives in a large, complex, highly regulated financial institution highly preferred
Knowledge of financial and banking products, policies, operations and applicable procedures
Knowledge of policies, procedures, products and regulatory requirements for the CBB business line
Ability to manage multiple tasks/projects and deadlines simultaneously with limited supervision
Effective interpersonal, verbal, and written communication skills
Experience in Business Intelligence/Data Exploration and Visualization tools such as Tableau and Superset
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 (https://careers.usbank.com/global/en/disability-accommodations-for-applicants) .
Learn how the way we work at U.S. Bank (https://assets.phenompeople.com/CareerConnectResources/prod/UBNAGLOBAL/documents/Thewaywework-1666895142717.pdf) drives meaningful relationships with our customers and collaboration across the company.
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
Sick and Safe Leave accruals of one hour for every 30 worked, up to 80 hours per calendar year unless otherwise provided by law
EEO is the Law
U.S. Bank is an equal opportunity employer committed to creating a diverse workforce. We consider all qualified applicants without regard to race, religion, color, sex, national origin, age, sexual orientation, gender identity, disability or veteran status, among other factors. Applicants can learn more about the company’s status as an equal opportunity employer by viewing the federal KNOW YOUR RIGHTS (https://eeoc.gov/sites/default/files/2022-10/EEOC_KnowYourRights_screen_reader_10_20.pdf) EEO poster.
U.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 (https://careers.usbank.com/verification-of-eligibility-for-employment) .
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, US Bank offers a comprehensive benefits package, including incentive and recognition programs, equity stock purchase 401k contribution and pension (all benefits are subject to eligibility requirements). Pay Range: $92,480.00 - $108,800.00 - $119,680.00
U.S. Bank is an equal opportunity employer committed to creating a diverse workforce. We consider all qualified applicants without regard to race, religion, color, sex, national origin, age, sexual orientation, gender identity, disability or veteran status, among other factors.