Job Summary: The Business Intelligence Analyst performs a variety of project oriented tasks to support the information needs of the organization. This position is responsible for all phases of reporting, decision support, and data analysis activities including report design, measure development, data collection, summarization, and validation. The Business Intelligence Analyst exercises independent judgement and discretionary decision making related to managing multiple and more complex reporting projects. The Business Intelligence Analyst is proficient with analytical and reporting tools, database development, ETL processes, query languages, and database and spreadsheet tools. This position is also responsible for training and mentoring other data specialists and analysts. The Business Intelligence Analyst will participate in reporting and presentations to various levels of management and staff and may also be included in action plan development.
Completes all work specific related to complex report requests, interviewing report requestor, understanding the needs/goals of the report, completing data queries, analyzing and summarizing data and presenting the final report in a small or large group setting to discuss and clarify data.
Utilizes programming tools to assist in data extraction form multiple data sources and transformation to support to create usable and reportable formats for final presentation and to make reporting more efficient and timely.
Determines the appropriate analysis technique(s) and method(s) to present data that addresses the report goal(s) and/or question(s).
Creates queries, data forms and reports for the reporting applications.
Demonstrates knowledge of data through review of existing data to identify missing/incomplete data anomalies. Proactively takes the lead in developing data Q processes, identifying and resolving data issues and problems. Validates report accuracy via auditing prior to distribution. Collaborate with other applicable areas of the organization to correct the data. Works closely with report requestor, IT Data Load Team, Application Team, and operational staff to understand data flow for reporting purpose accuracy.
Mentoring and training Data Specialists and Data Analysts in data processes, structures, tools, tuning report run performance, and steps for validation.
Utilizes project management knowledge and skills for assigned departmental project; establishing timelines, tasks, follow up items and communication to ensure all tasks activities are completed within project needs.
Participate in other departmental project activities and tasks to ensure successful completion of project, data collection, data management and data reporting.
Education: Bachelor’s Degree in Statistics, Mathematics, Economics, Computer Science/MIS, or Engineering.
Experience: Three (3) years of Enterprise Data Warehousing (EDW) knowledge Knowledge of how to speak to technical people in this industry and understand what a DW application is supposed to look and function like; Know how the Star Schema works; know what a fact table is, know what a dimension is, and how it is related to the fact. Four (4) year of experience in Business Intelligence Analyst role; Proficient in query language.
Licenses/Misc.: Valid driver’s license.