Financial Data Analyst - Salt Lake City - Hybrid Schedule

Zions Bancorporation - Salt Lake City, UT

Full-time - Entry Level

Hybrid - Salt Lake City, UT

Credit Intermediation and Related Activities

About the position

We are currently seeking a Financial Data Analyst as part of our FP&A SQL and Modeling 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 Data Analyst will be responsible for using SQL to develop and maintain multiple financial models that impact profitability analysis, pricing guidance, and financial forecasting and budgeting. Other responsibilities include validating data, researching issues, building dashboards and reports, and maintaining process and model documentation. You will collaborate with teams from Finance, Accounting, and Data Office to report on and analyze financial data and deliver insights that drive the company's growth and profitability.

Responsibilities

• Develop and maintain multiple financial models using SQL.
• Impact profitability analysis, pricing guidance, and financial forecasting and budgeting.
• Validate data and research issues.
• Build dashboards and reports.
• Maintain process and model documentation.
• Collaborate with Finance, Accounting, and Data Office teams to analyze financial data.

Requirements

• Experience using SQL to query and manipulate large data sets and perform calculations.
• Familiarity with concepts including joins, subqueries, case statements, update statements, date and time functions, string and text manipulation, window functions, and common table expressions.
• Specific knowledge of relational databases and general knowledge of data warehouse processes.
• Experience using Power BI or similar data visualization tools to build meaningful, complex reporting.
• Advanced Microsoft Excel skills.
• Experience with data validation and testing, process documentation, and technical writing.
• Familiarity with Microsoft Power Apps or other low-code automation tools is a plus.
• General knowledge of banking products and financial statements is a plus.
• Ability to communicate effectively to a large variety of audiences, from finance to data engineers.
• Detail-oriented and capable of managing multiple priorities.
• A desire and an ability to find ways to continually improve processes and drive efficiency.

Nice-to-haves

• Familiarity with Microsoft Power Apps or other low-code automation tools.
• General knowledge of banking products and financial statements.

Benefits

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