Business Intelligence Analyst I

    • Job Tracking ID: 512165-834178
    • Job Location: Broomfield, CO
    • Job Level: Mid Career (2+ years)
    • Job Type: Full-Time/Regular
    • Date Updated: 10/13/2022
    • Years of Experience: 2 - 5 Years
    • Starting Date: ASAP
    • Days of the Week: Mon,Tue,Wed,Thurs,Fri
    • Hours: 40 hours a week Monday - Friday 8:00 am - 5:00 pm with occasional after hours
    • Salary: Starting Annual Salary $51,636.87-$77,455.30 based on experience
Invite a friend
facebook LinkedIn Twitter Email


Job Description

$1000 HIRING BONUS FOR ALL NEW EMPLOYEES*

*$1000 to be paid out 90 days after start date.

As The Artisans of Banking, we strive to be B.R.A.V.E. (Build Relationships & Add Value Everyday). We recognize that in order to meet the needs of our communities, we must represent our communities. Our success relies on creating a culture where we have diverse perspectives and a true sense of belonging. This is a journey, and we pledge to do more than simply check the box.

When you join our Premier Members team, your benefits will include:

  • Comprehensive medical insurance plan that has HRA, HSA, and FSA options
  • Dental and vision insurance
  • Generous paid-time-off
  • 11 paid holidays
  • Annual bonus
  • 401(k) plan with a 5% match
  • Wellness program
  • Tuition assistance
  • 1% employee loan discount
  • Employee Assistance Program (EAP)
  • Life and disability coverage

What sets working for Premier Members apart?

  • Career development and pathing opportunities to move into leadership roles or other lines of business within PMCU such as Commercial Lending, Finance, Marketing, Underwriting, Member Solutions, Training, Human Resources, and more.
  • Supportive and engaging work environment.
  • A wellness and sustainable work culture that puts family, Mother Nature, our community, and your health first.
  • A work environment that encourages personal as much as professional growth, teamwork to make the dream work, and treating everyone equally.

Starting Annual Salary $51,636.87-$77,455.30 based on experience

Experience and Skills

POSITION SUMMARY:

The Business Intelligence Analyst I will help facilitate the use of data for all business users using different Business Intelligence Tools, especially PowerBI and SSRS. They will monitor data integrity alerts and maintenance needs, build reports and shared data sets, manage file transfer schedules and data import jobs, develop custom analysis, and often utilize T-SQL query language. An ideal candidate will possess the skill to explore beyond the initial request received and work with the end-user and team lead to determine an optimal long-term solution while also adhering to data privacy and other technical best practices. They will be a team player within the BI group, Business Applications team, Information Technology department, and greater credit union.

ESSENTIAL FUNCTIONS:

  • Review reporting requests and update or create published reports and ad hoc outputs to present data that’s insightful and accurate. Fulfilling these requests may require integrating multiple data sets by writing or modifying SQL code that connects to the enterprise data warehouse. There may be varying levels of data analysis, design and architecture planning, and training on the deliverable. Provide analysis, design implementation, maintenance and training for enterprise data projects and tasks.
  • Perform regular monthly maintenance with established processes for secure file transfer to and from vendors and ancillary applications; monitor more frequent established processes for regular member communication data files
  • Maintain documentation and create or update technology operational procedures based on changes in the environment or workflows for ETL Processing, Report development, and release to production; adhere to established scripting and formatting best practices guidelines. Attend and present at regular code review sessions with the team.
  • Meet with business units to gather requirements, explain findings, and confirm outputs meet the end-user specifications
  • Occasionally respond to alerts or planned maintenance outside regularly scheduled hours
  • Responsible for related duties as required or assigned

 QUALIFICATIONS

EDUCATION/CERTIFICATION:

  • A two-year college degree or completion of a specialized course of study at a business or trade school.

 REQUIRED KNOWLEDGE:

  • 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 Henry’s ARCU system a plus
  • Preferred proficiency in Microsoft SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Excel (including pivots), and familiarity with relational databases

 EXPERIENCE REQUIRED:

  • Three years to five years of similar or related experience, including preparatory experience.
  • Experience using or administering PowerBI or other data visualization tool preferred
  • Demonstrated analytical and problem-solving skills
  • Experience providing direct support for end-users, and translating findings from troubleshooting activities into clear descriptions for partnering teams
  • Preferred experience eliciting and formalizing requirements from end users and crafting solutions that meet or exceed initial requirements
  • Preferred understanding of programming and database concepts, and familiarity with the Software Development Life Cycle
  • Preferred experience working with a ticket queue and updating assigned tasks
  • Experience with Credit Unions, Financial Institutions, or Jack Henry’s ARCU system preferred

 SKILLS/ABILITIES:

  • Willing to drive efforts through to completion
  • Approach work with an attitude of continuous learning and improving; innate willingness to explore new technologies and concepts
  • Quick to assist a fellow colleague and join forces to troubleshoot challenging issues or brainstorm complex solutions
  • Strong speaking, writing, and listening skills
  • Ability to work and travel independently
  • Experience working in an office environment and navigating collaboration tools such as Microsoft Teams, and Outlook scheduling assistant and automatic replies to show consideration of others’ time
  • Ability to manage multiple work-streams, including emergency support tasks, and communicate roadblocks or concerns for maintaining progress on scheduled projects and tasks
  • Ability to work well in a dynamic and changing environment, and adapt quickly to new conditions and priorities
  • Ability to recognize and define problems, research, and establish facts, communicate, and resolve issues and problems promptly.
  • Focus on user focused design principles and UX design best practices
  • Adherence to relevant Financial Industry, Credit Union, and Cybersecurity/Data Privacy regulations, policies, and procedures to protect our members’ data and our organizational reputation

 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.

This Job Description is not a complete statement of all duties and responsibilities of this position and may change with or without notice.