U.S. Bank Insights & Reporting Analyst 4 - Dallas Metro OR Telecommute in United States
At U.S. Bank, we're passionate about helping customers and the communities where we live and work. The fifth-largest bank in the United States, we’re one of the country's most respected, innovative and successful financial institutions. 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.
The Reporting and Analytics group is seeking an Insights & Reporting Analyst.
The successful candidate will be responsible for development, deployment and management of reporting solutions for the bank’s loan portfolio serviced within Consumer and Business Banking.
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 ad-hoc and recurring reporting using MS SQL Server Management and Visual Studios
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
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.
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
- Four to five years of data analysis experience
5+ years of experience mining loan data, preferably with emphasis on Escrow
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
Experience with Power BI a plus
Working knowledge of developing and implementing VB scripts
Well-developed presentation skills
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
Quarterly travel possible
Candidates in the Dallas/Fort Worth Metro are are preferred.
Salary Range: $80,400.00 - $98,200.00
Salary range reflected is an estimate of base pay and is for the primary location. Base pay range may vary if an offer is made for work in a different location.
Take care of yourself and your family with U.S. Bank employee benefits. We know that healthy employees are happy employees, and we believe that work/life balance should be easy to achieve. That's why we share the cost of benefits and offer a variety of programs, resources and support you need to bring your full self to work and stay present and committed to the people who matter most - your family.
Learn all about U.S. Bank employee benefits, including tuition reimbursement, retirement plans and more, by visiting usbank.com/careers (https://www.usbank.com/careers/index.html) .
EEO is the Law
Applicants can learn more about the company’s status as an equal opportunity employer by viewing the federal EEO is the Law (https://www.dol.gov/sites/dolgov/files/ofccp/regs/compliance/posters/pdf/eeopost.pdf) 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://www.usbank.com/careers/verification-of-eligibility-for-employment.html) .
Our 74,000 employees work across departments to help our millions of retail, business, wealth management, payment, commercial and corporate, and investment services customers across the country and around the world turn their dreams into reality. Our employees are empowered to create change and drive our future, and we pride ourselves on diligently and ethically upholding U.S. Bank’s best-in-class financial record and legacy of more than 150 years in banking. Most importantly, we put people first, cultivating and treasuring meaningful relationships with the customers we serve, the colleagues we support and the communities where we live and work.