The Business Intelligence (BI) Analyst provides strategic guidance to management through detailed analysis of both internal and external data sources. This role will play an integral part in the creation and deployment of reporting and analytical solutions for the organization and will be responsible for all facets of the BI report life-cycle. As such, responsibilities will include gathering report requirements, creating new solutions, and implementing them throughout the organization.
Essential Function, in priority order: (Majority of duties, but not meant to be all inclusive or prevent other duties from being assigned as necessary)
Develops and maintains new and existing reports for the organization using various technologies including SQL, SQL Server, Reporting Services, and Microsoft Office. Time: 50%
Resolves production problems of medium to high complexity and works with end-users to support applications as needed. Time: 15%
Performs strategic analysis, using a variety of data sources, to help management make informed business decisions by identifying patterns and trends. Time: 10%
Manages the MCIF system, and coordinates all requests for studies, provides analysis of data and serves as a resource to the user departments within the Credit Union. Specifically, the position will be responsible for creating necessary mail/marketing files as requested by Marketing and project managers. Time: 5%
Actively engages management to identify areas for improvement and/or analysis. Time: 5%
Serves on appropriate Credit union committees and teams as assigned. Time: 5%
Learns new technologies to implement within existing infrastructure. Time: 5%
Provides technical assistance to colleagues by helping them better understand internal and external data structures as needed. Time: 5%
Working Relationships/Contacts (Positions with which incumbent has frequent contact)
Daily, personal/written/phone contact with Business Intelligence Manager
Daily, personal/written/phone contact with other department managers
Daily, personal/written/phone contact with Credit Union staff
Daily, personal/written/phone contact with vendors
Daily, personal/written/phone contact with community agencies and consultants
Physical Demands (Physical effort generally associated with this position)
Work involves standing and walking for brief periods of time, but most work is done from a seated position. There is potential for eyestrain from prolonged work at the computer. Deadlines, workloads, and pressure to achieve goals may cause increased stress levels. Ability to lift an average of 35 pounds may be required when moving boxes of printed materials.
Working Conditions (Typical working conditions associated with this type of work and environmental hazards, if any, that may be encountered in performing the duties of this position)
Internal -- work is normally performed in climate controlled office environment, where exposure to conditions of extreme heat/cold, poor ventilation, fumes and gases is very limited. Noise level is moderate and includes sounds of normal office equipment (computers, telephones, etc). No known environmental hazards are encountered in normal performance of duties. Length of day is unpredictable; long hours may be required to accommodate deadlines or special meetings.
External -- Some travel is required; however, information on environmental conditions is not available.
Accountability (Budget/asset amount managed, revenues produced, and/or other financial resource incumbent is accountable for. Also indicates judgment/decision-making level)
The Business Intelligence Analyst provides valuable input to the Credit Union’s planning process by conducting and sharing critical research/analysis functions that are used for strategic planning, organizational improvement, and for the development of meaningful marketing efforts.
Strong working knowledge of relational data models, database design, and data modeling concepts
Working knowledge of Microsoft SQL Server in order to manage a large-scale data warehouse
Working knowledge of SQL Server Reporting Services
Able to highlight issues/problems and convey complex thoughts, written and oral, in a clear, concise, and timely manner
Comfort in using a wide range of interpretive analysis tools (e.g. trend analysis, spreadsheets, comparisons, graphs, summary versus detail charts, drill-down, correlations, maps, exception analysis)
Superior research and analytical skills
Excellent organizational skills
Ability to conduct appropriate market research, analyze findings and provide meaningful reports relative to existing and/or potential Credit Union needs
Ability to work under pressure
Proven problem-solving abilities
Ability to understand and relate activities to strategic objectives
Ability to concentrate in a multi-task environment
Ability to maintain a positive attitude and professional image
Tools and Equipment Used
All available general office equipment as needed
All available computer software and hardware as needed
PC, scanner, and accessories
Marketing related word and graphic software
Website software and scripting language
Research tools and services
Bachelor's degree, preferable in Computer Science, Information Systems, and/or equivalent formal training or work experience.
A minimum of 2 years professional Information Systems or analytical experience required.
A minimum of 2 years Advance SQL, (or other database query language), programming experience required.