U.S. Bank Data Analyst in Saint Louis, Missouri

Responsibilities

The Reporting and Analytics group is seeking a Data Analyst to contribute toward the success of our technology initiatives. The successful candidate will be a member of a team responsible for development, deployment and management of reporting solutions for the Mortgage division within Consumer Banking Sales and Support.

Position Highlights:

  • Translate customer reporting requirements into actionable products that are user friendly, concise, intuitive and visually consistent

  • Develop reports using SSRS with a SQL Server backend

  • Create and manage ETL tasks within SSIS packages to gather, validate and store data from disparate sources

  • Develop portable dashboard style business intelligence solutions using SSRS

  • Cultivate a fundamental understanding of business processes and servicing platforms

  • Present data findings, results, recommendations and challenges to upper management

  • Closely coordinate with the Business Analysis team to understand and act on reporting requirements

  • Research, troubleshoot and solve data integrity problems affecting SLA of deliverables

  • Develop effective strategies in coordination with Business Analysis team to minimize scope creep

  • Research, understand and determine availability of source system data to be used in reporting

  • Manage all aspects of assigned reporting inventory to include archiving, retention, sun-setting, etc.

  • Generate weekly progress updates for upper management

  • Identify opportunities and make proposals to consolidate and simplify current processes

  • Remain closely involved in projects and initiatives that directly impact data used in reporting

  • Direct participation in recurring priority and status meetings with various business partners

  • Strict adherence to both internal and external compliance mandates

  • Identify and grow a network of internal subject matter experts within assigned areas

  • Provide thought leadership during projects and assignments

Qualifications:

Basic Qualifications

  • Bachelor's degree, or equivalent work experience

  • 1 years of data analytics experience

Preferred Skills/Experience

  • Advanced skill level in writing queries within a SQL Server environment, 2012 or newer

  • Demonstrated knowledge of SSIS/SSRS.

  • Strong familiarity with MS Office products, specifically VBA scripting in Excel

  • Experience with Power BI a plus

  • Applicants based in Owensboro KY or Dallas/Fort Worth area preferred

  • Experience implementing SSRS reporting in a SharePoint environment a plus

  • Working knowledge of developing and implementing VB scripts

  • 2 years of Mortgage Banking experience, preferably in the areas of SCRA, Vendor Management, Customer Advocacy, and Quality Management etc.

  • Excellent organizational, managerial and project management skills

  • Well-developed presentation skills

  • Demonstrate strong business acumen and professionalism at all times

  • Strong desire to continually improve self, people and processes

  • Exceptional time management skills

  • Excellent interpersonal, verbal and written communication skills

  • Effective at prioritizing a diverse workload

High degree of adaptability in an environment with continually shifting priorities

Job: Information Technology

Primary Location: Kentucky-KY-Owensboro

Shift: 1st - Daytime

Average Hours Per Week: 40

Requisition ID: 180031614

Other Locations: Texas-TX-Dallas, United States

U.S. Bank is an Equal Opportunity Employer committed to creating a diverse workforce.

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.