Business Intelligence Analyst

    • Job Tracking ID: 512165-746104
    • Job Location: Broomfield, CO
    • Job Level: Any
    • Level of Education: Any
    • Job Type: Full-Time/Regular
    • Date Updated: 10/14/2020
    • Years of Experience: Any
    • Starting Date: ASAP
    • Days of the Week: Mon,Tue,Wed,Thurs,Fri
    • Hours: 40 hours
    • Salary: $55,000-$85,000 based upon experience
Invite a friend
facebook LinkedIn Twitter Email


Job Description

POSITION SUMMARY:

The Business Intelligence Analyst will build reports for business users using different Business Intelligence Tools. Develops customer analysis and utilizes SQL.  An ideal candidate will possess the skill to look beyond the request received and work with the business user to determine the optimal long-term solution for the business.  This position is expected to proactively identify meaningful data and metrics to improve credit union operations, member service and regulatory/policy compliance. This position will be required to make recommendations to staff, including executive management, defend and explain complex technical information in a way that supports organizational decision makers.

 

ESSENTIAL FUNCTIONS:

  • Build, modify and explain reports for business users

  • Provide analysis, design implementation, maintenance and training for enterprise data projects and tasks.

  • Initiate improvements and develop new reports to satisfy emerging data needs

  • Write/Modify SQL code to develop data queries per end-user specifications

  • Create complex reports integrating multiple data-sets

  • Generate and maintain reports from Company Data Warehouse

  • Meet with internal line of business users to gather business requirements.

  • Manage projects and initiatives related to line of business requirements.

  • Prioritize and execute multiple work requests to meet deadlines

  • Adhere to corporate standards, policies and procedures

  • Write short procedures including but not limited to ETL Processing, Report Development, Business Requirement Definitions

  • Generate and maintain data dictionary and ensure enterprise data integrity and alignment

  • Resolve end user reporting problems through collaboration with IT and line of businesses

  • Maintain and monitor Enterprise Data Warehouse and SQL environment including after-hours work.

  • Execute and monitor on-going reporting and data processing operations for the credit union

  • Independently identify opportunities for improvement and provide operational insight and recommendations to credit union management

  • Present and explain findings to staff including executive suite

  • Responsible for related duties as required or assigned

 

QUALIFICATIONS

 

Education/Certification:      

  • 4-year college degree or equivalent work experience

     

Required Knowledge:

  • Experience with SQL or other enterprise-grade database

  • Proficient in T-SQL or other database query language

  • Experience with either database tools and concepts or credit unions a must

  • Experience with Jack Henry’s ARCU system a plus

  • Microsoft Excel- strong Excel skill, including pivots; VBA a plus, but not required

  • Outlook- ability to schedule appointments, check conflicts, etc.

  • Experience with SQL Server Reporting Services (SSRS) or other database reporting tool a plus

     

Experience Required:              

  • 3+ years in a combination of either a report writing/database role or credit union experience

  • 1 Year of experience T-SQL or other report writing language required

  • Proven experience generating, presenting and explaining complex and meaningful reports

     

Skills/Abilities:

  • Problem solving, analytical and communication skills required

  • Proven ability to listen to the needs of different groups and develop amicable relationships with a wide range of different personalities at all levels

  • Excellent written and verbal communication skills.  Demonstrated ability to convey information clearly, accurately, and timely in consideration of audience and medium.

  • Strong organizational and time management skills

  • Ability to prioritize and deliver on multiple initiatives simultaneously

  • Artistic/layout skill a plus

  • Presentation skills

     

WORKING CONDITIONS

  • Standard office conditions

  • Low to moderate noise

  • Limited lifting up to 50 lbs.

 

 

This description has been reviewed to ensure that only essential functions and basic duties have been included.  Peripheral tasks, only incidentally related to each position, have been excluded.  Essential functions, requirements, skills, and abilities included have been determined to be the minimal standards required to successfully perform the positions.  In no instance, however, should the duties, responsibilities, and requirements delineated be interpreted as all-inclusive.  Additional functions and requirements may be assigned by supervisors as deemed appropriate. 

 

In accordance with the Americans with Disabilities Act, it is possible that requirements may be modified to reasonably accommodate disabled individuals.  However, no accommodations will be made which may pose serious health or safety risks to the employee or others or which impose undue hardships on the organization.


The Credit Union believes that each employee makes a significant contribution to our success.  That contribution should not be limited by the assigned responsibilities.  Therefore, this job description is designed to outline primary duties, qualifications, and job scope, but not limit the incumbent.  It is our expectation that each employee will offer his/her services wherever and whenever necessary to ensure the success of our endeavors.

Job descriptions are not intended as and do not create employment contracts.  The organization maintains its status as an at-will employer.  Employees can be terminated for any reason not prohibited by law.

Experience and Skills

`