Business Intelligence Analyst - Power BI -San Diego
Location: San Diego, California
Internal Number: 10280_061146
We are seeking a Business Intelligence Analyst to join the Enterprise Business Intelligence team at Zions Bancorporation supporting California Bank & Trust. The Business Intelligence 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 system and will be expected to become a report development SME of banking information in partnership with the business, data and financial analysts and the Business Intelligence team.
The Business Intelligence Analyst will:
Be responsible for the analysis, solutions design, development, implementation, configuration and support of the Business Intelligence environment and User Interfaces.
Design and administer the reporting metadata (i.e. Data Sets/Data Flows, Universes, etc.) and construct/distribute complex reports.
Be responsible for the development, distribution, and maintenance of operational, marketing and other ad-hoc reports through the Microsoft Power BI platform.
Troubleshoot reporting performance problems and management of BI security.
Manage the creation, documentation and publication of policies and procedures of BI technology and data standards and methods.
Will develop strong partnerships and client relationship with Bank's Senior Management team
Work with partners to gather and collaborate on project requirements, and share team deliverables
Builds consistent and trusting relationships and communications between team members and senior stakeholders of the Bank.
Lead projects of moderate complexity along with coaching, development, and training to junior staff.
Support other duties as assigned.
Technical Experience and Qualifications
Broad knowledge of business intelligence tools and systems; relational databases, report writing, data warehouse system process and data modeling.
Advanced Microsoft SQL knowledge with strong T-SQL skills for the creation of views, and complex queries stored procedures, jobs. Tools to include MS Visual Studio and SQL Management Studio
Strong skills with Power BI Report development and optimization including experience with SSRS to Power BI migration
Good experience in writing DAX expressions and code with the M Query Language
Experience in building, configuring, and troubleshooting Power BI gateways, datasets, dataflows and deployment pipelines
Experience with Python programming is a plus.
Experience with development of knowledgebase documentation and deployment through Sharepoint
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 interpersonal skills with the ability to work with both management and staff employees in problem solving and root cause analysis
A combination of education and experience may meet requirements.
Pay Range - depends on experience: $100,000 - $130,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.
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.
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
Employees may, at the company's discretion, be eligible to receive a cash bonus award
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.