Description
$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 maintenanceof Power BI dashboards, reports, and basic data models. Under guidance, the BIA will help presentfindings to stakeholders and contribute to the development of self-service reporting tools. This roleworks closely with other business units to support reporting needs and complete assigned tasks andprojects.
Principal Accountabilities and FunctionsSupports 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 varioussystems 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 QualificationsBS in computer science, business intelligence or related fieldMinimum 2 years of experience developing BI solutionsMicrosoft Power BI Experience with Azure Data Services is a plusExperience with scripting and programming languages such as Python is a plusExperience with Microsoft Business Intelligence stack is a plusOr, an equivalent combination of education and experience.
Knowledge, Skills and Abilities
Strong understanding of data modeling and ETL processesStrong analytical and problem-solving skillsExcellent communication and collaboration skillsProficient in writing DAX queries on the Power BI desktopStrong proficiency with SQL (DDL, DML, & stored procedures)Business Intelligence Analyst lKnowledge 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 ofdatabases (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 datatools, including graphs.Ability to create relevant and readable graphs, charts, and presentationsAbility to find and analyze data from outside sources, validate its accuracy, and draw relevantconclusionsAbility to create and organize reports that synthesize complex information.Ability to create and effectively create and present relevant and readable graphs, charts, presentationmaterials, reports, business correspondence, and procedure manuals for a diverse audience.Ability to research, read, analyze and interpret financial reports, procedure manuals, businessperiodicals 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, outlinefacts, and draw conclusions as well as identify cause-and-effect relationships and evaluate risk versuspotential 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 researchnetworks.Ability to provide constructive feedback to others.Ability to interact effectively and professionally with colleagues and supervisors while demonstratingservice excellence.Ability to maintain sensitive and confidential information.Ability to work independently.Ability to work on simultaneous projects autonomously and/or with a teamBe a self-starter who is continuously learning to develop new and improve existing knowledge andskills.Has knowledge of and adheres to credit union policies and procedures and all regulations related to thebank Secrecy Act, the USA Patriot Act and OFAC.
Business Intelligence Analyst IIKnowledge 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 ofdatabases (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 datatools, including graphs.Ability to create relevant and readable graphs, charts, and presentationsAbility to find and analyze data from outside sources, validate its accuracy, and draw relevantconclusionsAbility to create and organize reports that synthesize complex information.Ability to create and effectively create and present relevant and readable graphs, charts, presentationmaterials, reports, business correspondence, and procedure manuals for a diverse audience.Ability to research, read, analyze and interpret financial reports, procedure manuals, businessperiodicals 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, outlinefacts, and draw conclusions as well as identify cause-and-effect relationships and evaluate risk versuspotential 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 researchnetworks.Ability to provide constructive feedback to others.Ability to interact effectively and professionally with colleagues and supervisors while demonstratingservice excellence.Ability to maintain sensitive and confidential information.Ability to work independently.Ability to work on simultaneous projects autonomously and/or with a teamBe a self-starter who is continuously learning to develop new and improve existing knowledge andskills.Has knowledge of and adheres to credit union policies and procedures and all regulations related to thebank Secrecy Act, the USA Patriot Act and OFAC.
Working ConditionsWorking Conditions
Ability to work the hours needed which may extend beyond the defined work schedule when operatingconditions dictate.Ability to lift up to 15 lbs., with or without assistance, in compliance with ADA.
Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights (https://www.eeoc.gov/poster) notice from the Department of Labor.
