Business Intelligence Analyst I/II

Tower•Laurel, MD

About The 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.

Requirements

BS in computer science, business intelligence or related field
Minimum 2 years of experience developing BI solutions
Microsoft Power BI
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)
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.

Nice To Haves

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.

Responsibilities

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.