Business Intelligence Analyst I/II

$1000 Signing Bonus effective 1/20/2024

Note: All full-time positions include exceptionally low medical premiums in addition to a whole host of other benefits.  

HOURS FOR POSITION: Monday - Friday 8:00am-4:30pm 

Hiring Range -$65,844-$82,306

Summary of Position

The Business Intelligence Analyst I (BIA) is responsible for assisting in the creation and maintenance
of Power BI dashboards, reports, and basic data models. Under guidance, the BIA will help present
findings to stakeholders and contribute to the development of self-service reporting tools. This role
works closely with other business units to support reporting needs and complete assigned tasks and
projects.

Principal Accountabilities and Functions
Supports the design and maintenance of Power BI dashboards, reports, and data models.
Assists in creating data visualizations to support understanding of key metrics and trends.
Creates basic recurring and ad-hoc reports using data from our enterprise data warehouse and various
systems of record.
Supports requirements gathering and helps create data models based on stakeholder needs.
Collaborates with IT/InfoSec teams to ensure data integrity and security.
Develops basic/intermediate reports and visualizations using Power BI and Power Query.
Stays current with new Power BI features and best practices.
Assists senior analyst(s) in solving business problems using basic analytical and technical methods.
Supports evaluation of third-party tools and services under the direction of senior staff.
Performs related duties when assigned.
Required Qualifications
BS in computer science, business intelligence or related field
Minimum 2 years of experience developing BI solutions
Microsoft Power BI Experience with Azure Data Services is a plus
Experience with scripting and programming languages such as Python is a plus
Experience with Microsoft Business Intelligence stack is a plus
Or, an equivalent combination of education and experience.

Knowledge, Skills and Abilities

Strong understanding of data modeling and ETL processes
Strong analytical and problem-solving skills
Excellent communication and collaboration skills
Proficient in writing DAX queries on the Power BI desktop
Strong proficiency with SQL (DDL, DML, & stored procedures)
Business Intelligence Analyst l
Knowledge of and successful demonstrated experience with MS Office Products, i.e. Access, Excel,
Word, PowerPoint.
Working knowledge of Relational Database Software. Demonstrated ability to apply knowledge of
databases (i.e. MSSQL, Oracle, Access).
Demonstrated proficiency in database management.
Familiarity with statistical analysis techniques and statistical software.
Ability to enter data, sort, and extract information from database systems.
Ability to manipulate, query, and analyze large quantities of data and present it in simple, insightful,
actionable summarized documents.
Demonstrated ability to apply knowledge of financial institution systems, including core processing,
job scheduling, and data sets.
Ability to create and modify word-processing and spreadsheet documents using formulas and data
tools, including graphs.
Ability to create relevant and readable graphs, charts, and presentations
Ability to find and analyze data from outside sources, validate its accuracy, and draw relevant
conclusions
Ability to create and organize reports that synthesize complex information.
Ability to create and effectively create and present relevant and readable graphs, charts, presentation
materials, reports, business correspondence, and procedure manuals for a diverse audience.
Ability to research, read, analyze and interpret financial reports, procedure manuals, business
periodicals and professional journals.
Ability to prepare technical information for a diverse audience.
Ability to effectively present ideas and concepts.
Ability to write proposals, reports, and business correspondences. Ability to define problems, outline
facts, and draw conclusions as well as identify cause-and-effect relationships and evaluate risk versus
potential return.
Ability to develop solutions for problems with concrete and/or abstract variables.
Ability to take and follow instructions.
Ability to follow procedures to reach resolutions.
Ability to develop action plans and organize workload to accommodate competing deadlines.
Ability to prioritize tasks and complete daily job assignments.
Ability to manage multiple complex projects.
Ability to work productively and professionally under stress.
Ability to work cooperatively with all departments and credit union functional areas.
Ability to work with external sources to conduct research.
Ability to present self professionally and to work effectively with outside vendors and research
networks.
Ability to provide constructive feedback to others.
Ability to interact effectively and professionally with colleagues and supervisors while demonstrating
service excellence.
Ability to maintain sensitive and confidential information.
Ability to work independently.
Ability to work on simultaneous projects autonomously and/or with a team
Be a self-starter who is continuously learning to develop new and improve existing knowledge and
skills.
Has knowledge of and adheres to credit union policies and procedures and all regulations related to the
bank Secrecy Act, the USA Patriot Act and OFAC.

Business Intelligence Analyst II
Knowledge of and successful demonstrated experience with MS Office Products, i.e. Access, Excel,
Word, PowerPoint.
Working knowledge of Relational Database Software. Demonstrated ability to apply knowledge of
databases (i.e. MSSQL, Oracle, Access).
Demonstrated proficiency in database management.
Familiarity with statistical analysis techniques and statistical software.
Ability to enter data, sort, and extract information from database systems.
Ability to manipulate, query, and analyze large quantities of data and present it in simple, insightful,
actionable summarized documents.
Demonstrated ability to apply knowledge of financial institution systems, including core processing,
job scheduling, and data sets.
Ability to create and modify word-processing and spreadsheet documents using formulas and data
tools, including graphs.
Ability to create relevant and readable graphs, charts, and presentations
Ability to find and analyze data from outside sources, validate its accuracy, and draw relevant
conclusions
Ability to create and organize reports that synthesize complex information.
Ability to create and effectively create and present relevant and readable graphs, charts, presentation
materials, reports, business correspondence, and procedure manuals for a diverse audience.
Ability to research, read, analyze and interpret financial reports, procedure manuals, business
periodicals and professional journals.
Ability to prepare technical information for a diverse audience.
Ability to effectively present ideas and concepts.
Ability to write proposals, reports, and business correspondences. Ability to define problems, outline
facts, and draw conclusions as well as identify cause-and-effect relationships and evaluate risk versus
potential return.
Ability to develop solutions for problems with concrete and/or abstract variables.
Ability to take and follow instructions.
Ability to follow procedures to reach resolutions.
Ability to develop action plans and organize workload to accommodate competing deadlines.
Ability to prioritize tasks and complete daily job assignments.
Ability to manage multiple complex projects.
Ability to work productively and professionally under stress.
Ability to work cooperatively with all departments and credit union functional areas.
Ability to work with external sources to conduct research.
Ability to present self professionally and to work effectively with outside vendors and research
networks.
Ability to provide constructive feedback to others.
Ability to interact effectively and professionally with colleagues and supervisors while demonstrating
service excellence.
Ability to maintain sensitive and confidential information.
Ability to work independently.
Ability to work on simultaneous projects autonomously and/or with a team
Be a self-starter who is continuously learning to develop new and improve existing knowledge and
skills.
Has knowledge of and adheres to credit union policies and procedures and all regulations related to the
bank Secrecy Act, the USA Patriot Act and OFAC.

Working Conditions
Working Conditions

Ability to work the hours needed which may extend beyond the defined work schedule when operating
conditions dictate.
Ability to lift up to 15 lbs., with or without assistance, in compliance with ADA.