U.S. Bank Business Operations Analyst 5 in Saint Louis, Missouri

The Reporting and Analytics group is seeking a Business Operations Analyst. 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.

Duties to include but not limited to the following:

  • 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


Basic Qualifications

  • Bachelor's degree, or equivalent work experience

  • 10 or more years of experience in operations/technology project management activities

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 Dallas/Fort Worth area preferred

  • Experience implementing SSRS reporting in a SharePoint environment a plus

  • Working knowledge of developing and implementing VB scripts

  • 5 years of Mortgage Banking experience, preferably in the areas of insurance (hazard, flood and PMI), taxes, escrow, loss draft, 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: Business Ops Analysis

Primary Location: United States

Shift: 1st - Daytime

Average Hours Per Week: 40

Requisition ID: 180044939

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.