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.
Build 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.
Adhere to corporate standards, policies and procedures
Write short procedures including but not limited to ETL Processing, Report Development, Business Requirement Definitions
Resolve end user reporting problems through collaboration with IT and line of businesses
Execute and monitor on-going reporting and data processing operations for the credit union
Present and explain findings
Responsible for related duties as required or assigned
College course work in computer information systems, database concepts or related fields beneficial
Previous exposure to relational database reporting and SQL beneficial
Ideal candidate will be proficient in T-SQL or other database query language
Experience with either database tools and concepts or credit unions a must
Experience with Jack Henrys ARCU system a plus
Microsoft Excel- strong Excel skill, including pivots is beneficial; 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
2+ years in a combination of either a report writing/database role or credit union experience
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
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.