Our headquarters in Sacramento contains the core functions that support our mission to deliver financial solutions with value, convenience and exceptional service to our members.

JOB TITLE: Business Intelligence Analyst II
DEPARTMENT: Finance
STATUS: Exempt
JOB CODE: 10094

GENERAL DESCRIPTION:

Works directly with our Business Partners and Senior Analysts to perform analysis to support business objectives. Gather, prepare, analyze and summarize data from multiple systems for management's reference in strategic development. This role will use a variety of techniques including simple data aggregation and statistical analysis to prepare reports of findings.

Will be involved in the creation of both repeating and adhoc reporting using Excel, PowerBI and SQL. Offer advice and guidance in the creation of reporting to our business partners while building to their specifications to assist with the operations of the department.

TASKS, DUTIES, FUNCTIONS:

Perform the following job duties and responsibilities in accordance with corporate policy and procedures, within established timeframes:

Create data storytelling, converting data into usable information to assist the Credit Union in making data driven decisions.

Assist Leadership and Senior Analysts with complex analysis, using data to add value to our business partners.

Assist with preparation of documentation of analysis using Microsoft Word or Microsoft PowerPoint to create a report of findings.

Using PowerBI, create visuals that will assist Senior Management with business decisions.

Manage required ad hoc report preparation, analysis and presentation to management as reference for strategic decisions, committee review and other information requests.

Using PowerBI, Excel and SQL, aggregate multiple data sources into a single story to summarize the results of a review into actionable points for Senior Management.

Assist with automation of Excel based reports

Assist with requirement gathering using interviews, document analysis, use cases, scenarios and workflow analysis.

Participate in team projects.

Continue to expand on an understanding of lending/deposit rates, policies and procedures impacting responsibilities.

Update procedures in response to changes in operational activities or technological upgrades.

Perform reviews or validations of Business Intelligence Analyst I work prior to, or in lieu of, review by Team Leadership.

Maintain a thorough understanding of state and federal laws and regulations related to credit union compliance including bank secrecy act (BSA) and anti-money laundering laws appropriate to the position.

Ensure compliance with applicable standards, rules, regulations and systems of internal control.

Perform other duties as assigned.

Specializations in this position may include one or more of the following:

• Lending (Real Estate Secured/Personal Loan/Vehicle Secured/Credit Cards
• Marketing
• Retail Branch Support
• Business Banking
• Pricing (Loans and Deposits)
• Financial Reporting
• Compliance Reporting

PHYSICAL SKILLS, ABILITIES, AND EXERTION UTILIZED IN THE PERFORMANCE OF THESE TASKS:

Effective oral and written communication skills required to prepare reports and perform other related tasks.

Must possess sufficient manual dexterity to skillfully operate an on-line computer terminal and other standard office equipment, such as financial calculators, personal computer, facsimile machine and telephone.

ORGANIZATIONAL CONTACTS & RELATIONSHIPS:

INTERNAL: All levels of staff and management.

EXTERNAL: Vendors, other financial institutions or business sources.

QUALIFICATIONS:

EDUCATION: Requires a bachelor's degree in area of specialty (Accounting, Mathematics, Business Administration, Information Technology or similarly quantitative/analytical degrees). Equivalent work experience with required knowledge/skills may be substituted for degree.

EXPERIENCE: 1 - 5 years or more of progressive banking/credit union experience. 1 - 5 years of Analytical Experience. Knowledge of commonly-used concepts, practices, and procedures within credit union operations.

KNOWLEDGE/SKILLS:

• Functional:

• Functional Knowledge in the following: Federal Rules and Regulations as applied to credit unions; Golden 1 Products; Golden 1 Employee handbook.
• Intermediate knowledge in the following areas: Golden 1 Policies and Procedures; Lending concepts; Retail Branch Banking; Corporate Finance - ROI, Break Even Analysis; Compliance Reporting.

Technical:

• Intermediate knowledge in the following systems/applications (required): Microsoft Excel- Formulas, functions, pivot tables; dashboard creation, data connections and basic macros; Microsoft Power Point; Microsoft Word; Microsoft Outlook- Email, Calendar, Task; Microsoft Teams; PDF Creation/Editing (Nitro Pro).
• Intermediate knowledge in the following systems/applications (preferred): Microsoft Power BI - Building Visuals using existing Datasets, and understanding of Power BI Desktop; SQL Programming - Select Statements, Joins, Aggregating Data, and Querying; DataSafe.
• Basic knowledge in the following systems/applications (preferred): SAS Enterprise Guide - Use of tools to import and manipulate datasets; VBA Coding to support automation of tasks.

Behaviors:

• Self-Motivated, can stay focused with minimal oversight.
• Models Golden 1's Core Values of Service Excellence, Respect, Integrity and Reliability; Embraces Golden 1's mission and vision.
• Acts ethically in all matters.
• Plans and organizes work in order to support department goals.
• Productively works to improve the standard way of doing things, anticipating issues to prevent problems before they occur.
• Utilizes skill and training to make recommendations to improve a process, support our Core Values and/or save costs.
• Can be counted on to meet obligations and accepts accountability for delivering results.
• Demonstrates reliable and on-time attendance.
• Demonstrates functional, technical and job specific knowledge required for position.
• Takes ownership of their own professional and personal development to ensure their skills remain current and relevant.
• Is open and willing to try new approaches and ideas.
• Learns about and embraces changes in Golden 1's strategy or direction.
• Attention to detail; ensures accuracy in work product.
• Ability to independently prioritize tasks.
• Leverages available tools and resources to stay organized and proactive.
• Demonstrates desire and ambition to achieve.
• Knows when work product requires additional attention to presentation and acts accordingly to ensure deliverables match the need.
• Is available and sought after as a resource of relevant skill and knowledge.
• Able to work through roadblocks and find solutions.

Communication & Interaction:

• Steward of the Golden 1 Brand and maintains quality standards of service excellence in all interactions.
• Respects and works well with people with diverse skills, styles, perspectives, and backgrounds.
• Contributes to an inclusive environment, where everyone is treated with courtesy, dignity and respect, regardless of perceived differences.
• Provides exceptional member/colleague service by showing caring, friendly, member centric support, and seeking opportunities to provide Golden Service.
• Fully participates in meetings, proactively bringing forward relevant information, ideas and potential solutions.
• Communicates clearly and concisely, both in written and oral form.
• Shares knowledge freely to help others succeed.
• Shares important information at appropriate time; Ability to escalate issues requiring additional action.
• Works well within team and across departments, effectively collaborating and interacting with coworkers, leaders, and members.
• Acknowledges and celebrates the success of others.
• Gives and receives honest and candid feedback in a constructive way; Leverage feedback to further personal and professional development.
• Positively adapts to changes in Golden 1 and/or changes in own role, and helps others to do the same.
• Effective listener.
• Presumes positive intent in all communications.
• Able to speak in technical and business language based on the audience.
• Ability to ask relevant probing questions of external stakeholders to ensure appropriate accounting treatment.
• Confident communicating with mid-level management outside of the team.

Leadership:

• Guides external stakeholders to proper resources for inquiries.
• Provide guidance and training to Junior Business Intelligence Analysts.
• Ability to effectively lead efficient meetings.
• Supports team and department leadership with projects.
• Supports teammates.

PHYSICAL REQUIREMENTS:

Prolonged sitting throughout the workday with occasional mobility required.

Corrected vision within the normal range.

Hearing within normal range. A device to enhance hearing will be provided if needed.

Ability to lift 15 lbs. as may be required.

Occasional movements throughout the department daily to interact with staff, accomplish tasks, etc.

LICENSES/CERTIFICATIONS:

None

We appreciate your interest in joining the Golden 1 team! If you are selected to participate in the interview process we will contact you.