Business Intelligence Analyst I
United Federal Credit Union - Saint Joseph, MI

This job posting is no longer available on United Federal Credit Union. Find similar jobs:Business Intelligence Analyst jobs - United Federal Credit Union jobs

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.

    Required Skills 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

    Required Experience 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.