Financial Analyst - FP&A Profitability SQL Reporting - SLC - Hybrid Schedule

Zions Bancorporation is one of the nation’s premier financial services companies operating as a collection of great banks under local brands and management teams in high-growth western markets. Zions is regularly recognized by American Banker as one of the “Best Banks to Work For” and as having a top banking team in its list of “The Most Powerful Women in Banking.” Our customers consistently vote us as the best bank in our local markets., We value our employees, and we are committed to search out, recognize and create fulfilling opportunities for outstanding people within our organization, rewarding them for their contributions to our success. We recognize that banking is a “local” business, and that to be successful, we must have very strong ties to the communities we serve and strong relationships with our customers.

With benefits starting on day one, 12 bank holidays, profit sharing and company-matched 401(k) contributions, Zions is dedicated to being an employer of choice in our communities. At Zions, the possibilities are endless. You bring the talent; we bring the opportunity. 

We are currently seeking a Financial Analyst as part of our Profitability Reporting team within the Financial Planning and Analysis department. 

The FP&A division is focused on developing talent that will enable our organization’s long-term success by improving balance sheet returns, growing fee income, controlling expenses, and gaining efficiencies through process improvement and automation. FP&A works with the brightest minds in the organization who foster a culture of continuous learning and growth, there is executive and board-level visibility and support for our work, and our efforts translate directly into highly visible, enterprise-wide initiatives. We are laser focused on creating value and are seeking like-minded professionals to join our team.

The Financial Analyst will be responsible for maintaining data and understanding complex financial models that underpin the calculations in a web-based profitability forecasting tool. The candidate will also be using SQL heavily to validate, research issues, and generate reporting from optimized datasets that allow the bank to analyze profitability – by account, customer, product, segment and more – to help inform strategic decisions and drive results. The profitability tool and reporting are utilized by more than a thousand employees at all levels of the organization. The candidate will be communicating daily with employees at all levels, from bank officers to executive management, and must be able to tailor responses on complex financial concepts to audiences with varying degrees of understanding and different perspectives. 

 
Requirements:
 

• Experience using SQL to query and manipulate large data sets
  
• Specific knowledge of relational databases and general knowledge of data warehouse processes
  
• Intermediate or higher-level knowledge of banking products and financial statements.
  
• Experience with complex financial models and concepts
  
• Excellent verbal and written communication skills 
  
• Ability to communicate effectively to a large variety of audiences, from finance to data engineers
  
• Ability to find creative solutions to previously unsolved data and reporting problems
  
• A desire and an ability to find ways to continually improve processes and drive efficiency
  
• Ability to contend with competing demands and occasionally changing requirements
  
• Experience with process documentation, data validation and testing, and technical writing
  
• Experience using Power BI or similar data visualization tools to build meaningful, complex reporting with optimized data models is a plus
  
• Familiarity with Microsoft Power Apps or other low-code automation tools is a plus
   

Qualifications:
 

• 2-6 + years of related work experience
  
• Bachelor’s degree in a quantitative discipline (computer science, statistics, finance, etc.) is required
  
• Master’s degree in a quantitative discipline may substitute for experience

Located in the heart of downtown Salt Lake City, the Zions Bank Building serves as the headquarters of both Zions Bancorporation and Zions Bank. The building sits adjacent to City Creek Center, a world-class shopping and dining destination with more than 100 stores and restaurants. The Zions Bank Building stands tall among Salt Lake City’s central business district, providing hundreds of team members with an exceptional work environment and features such as:

• Easy access to the City Creek UTA TRAX station, as well as various electric vehicle charging stations in most City Creek area garages;
  
• An employee-only fitness center and bike storage;
  
• An employee lounge, kitchen, micro market, game tables, couches and TVs;
  
• Private mothers’ rooms and lockers; and
  
• Access to downtown shopping, dining, arts and entertainment.