We are seeking a Data Analyst to join the Enterprise Business Intelligence team at Zions Bancorporation. The Data Analyst plays a key role in collecting, validating, modeling and analyzing data for the organization as well as develop key metrics, design and implementation of data initiatives and reporting within the Bank. The candidate will be provided the opportunity to learn and develop skills working with data from multiple leading-edge Banking systems.

The Data Analyst will:

• Support the preparation of financial and operational reports, recommendations and participate in the analysis and interpretation of data as appropriate

• Collaborate with system architects, software architects, design analysts, and others to understand business requirements, develop database architectural strategies at the modeling, design, and implementation stages superficially focusing on the Power BI platform

• Develop data models for applications, metadata tables, views or related database structures

• Develop advanced and complex SQL procedures and queries

• Accurately collect and model data for various types of business reports

• Within Power BI Create relationships between data and develop tabular and other multidimensional data models

• Create customized charts and custom calculations as required

• Create visually impactful, interactive business reports that provide insight into key data points

• Design business analysis and data recording systems for use in the reporting processes

• Examine existing reports to locate and resolve issues

• Coordinate, facilitate and provide data analytical support to other departments and managers as needed

• Interpret performance trends, identify root causes behind the trends and contributes to the development of performance improvement efforts

• Perform special projects as requested

• Support other duties as assigned.

Technical Experience and Qualifications

• Advanced Microsoft SQL knowledge with strong T-SQL skills and background for the creation of views, and complex queries stored procedures, jobs. Tools to include MS Visual Studio and SQL Management Studio

• Good experience in writing DAX expressions, M Query Language

• Experience in building Power BI datasets, Data flows and deployment pipelines

• Experience in Configuring Gateways for different kind of source systems

• Experience with development of knowledgebase documentation and deployment through Sharepoint

• Strong Query/data Analytics and performance tuning experience

• Strong skills and experience with Power BI Report development and optimization

• SSRS to Power BI migration

• Analyze existing SQL queries for performance improvements

• Proactively identify opportunities and implement enhancements to improve system and business processes to support the goals and objectives of the Bank.

• Bachelor's in computer science, information technology, business, finance or a related field and 4+ year's experience in installing and maintaining database systems, statistical/data analysis, modeling, business systems, data bases or other directly related experience

• Advanced working knowledge of project techniques and practices including usage of Azure DevOps

• Excellent problem solving, root cause analysis and communication skills, both verbal and written

• Excellent interpersonal skills with the ability to work with both management and staff employees

• May train or lead team members

A combination of education and experience may meet requirements.

Pay Range - depends on experience: $100,000 - $125,000

Location: Position is primary on-site located at a California Bank & Trust Administration office within San Diego but can work remotely 1 to 2 days a week.

Benefits:

• Medical, Dental and Vision Insurance - START DAY ONE! 
• Life and Disability Insurance, Paid Parental Leave and Adoption Assistance
• Health Savings (HSA), Flexible Spending (FSA) and dependent care accounts
• Paid Training, 20 days of Paid Time Off (PTO) and 11 Paid Federal Holidays
• 401(k) plan with company match, Profit Sharing, competitive compensation in line with work experience
• Mental health benefits including coaching and therapy sessions
• Tuition Reimbursement for qualifying employees
• Employee Ambassador preferred banking products

Zions Bancorporation is transforming what it means to work for a financial institution. We operate in a fast-paced, information-driven environment, which means we need people who bring diverse experiences, perspectives, and expertise to meet ever-changing demands. Your ability to adapt, learn innovate and collaborate with a dynamic team helps us provide exceptional service to our customers and communities.

Zions Bancorporation is committed to helping our employees grow, develop and advance in their career. Our Workforce of the Future, DEI and UpSkilling initiatives allow you to network across the organization, volunteer in our community, and build your technical and soft skills. We believe that investing in your success and well-being is an investment in our customers and our business.

Together we are building a culture that values diversity, celebrates growth and creates a space of belonging for all our team members. Our people are what set us apart and make us great.

Apply now if you have a passion for impactful outcomes, enjoy working collaboratively with co-workers, and want to make a difference for the clients and communities we serve.

About Zions Bancorporation

Zions Bancorporation, N.A. is one of the nation's premier financial services companies with annual net revenue of $2.9 billion in 2021 and more than $90 billion of total assets. Zions operates under local management teams and distinct brands in 11 western states: Arizona, California, Colorado, Idaho, Nevada, New Mexico, Oregon, Texas, Utah, Washington, and Wyoming. The Bank is a consistent recipient of national and state-wide customer survey awards in small and middle-market banking, as well as a leader in public finance advisory services and Small Business Administration lending, ranking as the tenth largest provider in the U.S. of the SBA’s Paycheck Protection Program loans. In addition, Zions is included in the S&P 500 and NASDAQ Financial 100 indices.

Connections working at Zions Bancorporation