Corporate Strategy - Analyst II - Business Intelligence

TITLE: ANALYST II - BUSINESS INTELLIGENCE
STATUS: EXEMPT
REPORT TO: MANAGER BUSINESS INTELLIGENCE 
DEPARTMENT: CORPORATE STRATEGY
JOB CODE: 11459

PAY SCALE: $71,600.00 - $77,000.00 ANNUALLY

GENERAL DESCRIPTION:

The Analyst II on the Business Intelligence team provides reporting and information to our business partners.  Work closely with credit union personnel and business partners to identify and maximize opportunities to create monitoring and reporting using information to improve products, services and/or business processes.  This includes gathering, preparing, analyzing, and summarizing data from multiple systems or external sources for into visualizations for management's reference to guide strategic development. 

This role is a junior analyst with Golden 1 Credit Union where you will work with leadership or senior analysts on complex analysis to develop your skills.  Projects will require the use of critical thinking and communication to complete, along with technical skills including SQL, PowerBI and Excel.  You will also need to be able to quickly understand, clean and interpret data for use in the reporting.

TASKS, DUTIES, FUNCTIONS:

• 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.
• Using PowerBI, create visuals that will assist Senor 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.
• Manage required ad hoc report preparation, analysis, and presentation to management as reference for strategic decisions, committee review and other information requests.
• Assist with automation of Excel based reports.
• Assist with requirement gathering using interviews, document analysis, use cases, scenarios, and workflow analysis.
• 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.
• Ensure compliance with applicable standards, rules, regulations, and systems of internal control.

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

1. Effective oral and written communication skills required to assist other staff, share reports, coach staff, communicate clearly with management, and perform other related tasks.
2. Must possess sufficient manual dexterity to skillfully operate standard office equipment, such as financial calculators, personal computer, and telephone.

ORGANIZATIONAL CONTACTS & RELATIONSHIPS:

1. INTERNAL: All levels of staff and management.
2. EXTERNAL: Vendors, other financial institutions, business partners and industry peers.

QUALIFICATIONS:

1. EDUCATION:

1. • 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. 

1. EXPERIENCE:

1. • 3+ years or more of progressive banking/credit union experience.
   • 3+ years of Analytical Experience.
   • Knowledge of commonly used concepts, practices, and procedures within credit union operations.

1. KNOWLEDGE / SKILLS:

1. • Technical Skills
     • Required- knowledge in the following systems/applications:
     • Microsoft Excel- Formulas, functions, pivot tables, dashboard creation, data connections and basic macros
     • Microsoft Power Point
     • PDF Creation/Editing (Nitro Pro)
     • Microsoft Power BI - Building Visuals using existing Datasets, and understanding of Power BI Desktop
     • SQL Programming - Select Statements, Joins, Aggregating Data, and Querying.
   • Preferred- knowledge in the following systems/applications:
     • SAS Enterprise Guide - Use of tools to import and manipulate datasets.
     • VBA Coding to support automation of tasks.
   • 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.
   • Behavior
     • Self-Motivated, can stay focused with minimal oversight.
     • Takes ownership of their own professional and personal development to ensure their skills remain current and relevant.
     • Attention to detail; ensures accuracy in work product.
     • Ability to independently prioritize tasks.
     • Leverages available tools and resources to stay organized and proactive.
     • 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 and Interactions
     • Contributes to an inclusive environment, where everyone is treated with courtesy, dignity, and respect, regardless of perceived differences.
     • Fully participates in meetings, proactively bringing forward relevant information, ideas, and potential solutions.
     • Communicates clearly and concisely, both in written and oral form.
     • 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.

PHYSICAL REQUIREMENTS:

1. Prolonged sitting throughout the workday with occasional mobility required.
2. Corrected vision within the normal range.
3. Hearing within normal range. A device to enhance hearing will be provided if needed.
4. Ability to lift 15 lbs. as may be required.
5. Occasional movements throughout the department daily to interact with staff, accomplish tasks, etc.

LICENSES / CERTIFICATIONS:

Preferred: Data Analytics Certification like: Certified Analytics Professional (CAP), IBM Data Science Professional Certificate, Datacamp Analyst Certification, Microsoft Data Analyst Associate Certification, SQL Certification, or other graduate work in the fields of finance, Business Intelligence or data analytics.

THIS JOB DESCRIPTION IN NO WAY STATES OR IMPLIES THAT THESE ARE THE ONLY DUTIES TO BE PERFORMED BY THIS EMPLOYEE. HE OR SHE WILL BE REQUIRED TO FOLLOW OTHER INSTRUCTIONS AND TO PERFORM OTHER DUTIES REQUESTED BY HIS OR HER SUPERVISOR THAT ARE WITHIN HIS / HER KNOWLEDGE, SKILL AND ABILITY AS WELL AS HIS / HER MENTAL AND PHYSICAL ABILITIES.

REV. 12/26/2023