U.S. Bank Data Analyst in Overland Park, Kansas
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.
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
Bachelor's degree, or equivalent work experience
1 years of data analytics 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.