BI Analyst in Sandy, UT

$80K - $100K(Ladders Estimates)

Mountain America Credit Union   •  

Sandy, UT 84070

Industry: Finance & Insurance


5 - 7 years

Posted 55 days ago

Job Summary

Manage critical organization data and data systems, turn data into information, and information into insight. Deliver comprehensive business intelligence solutions, data cube design, reporting and analytics. Provide system administrative support for data extract processes and reporting tools, including support for user community.Job Description

To be effective, an individual must be able to perform each job duty successfully.

  • Identifies and recommends methods to normalize and maintain data from disparate systems. Works closely with ETL Developers throughout the EDW development lifecycle.
  • Works with internal and external data users to identify requirements to deliver high quality BI solutions and analyses and takes ownership for data and report quality.
  • Translates and documents results of requirements gathering into a standard format to be used to create the appropriate Business Intelligence (BI) solution.
  • Leads in the collection of system/business requirements and the documentation of business and technical data dictionaries/metadata and specifications in support of complex strategic EDW solutions. Prepares documentation for ETL Developers for integration of new data into EDW.
  • Applies industry standards to the technical architecture of a Business Intelligence solution (Stars, Cubes, etc.) to solve business problems or increase business efficiency.
  • Manages user acceptance testing of reporting modules, analyzes test results, and corrects problems.
  • Establishes data quality standards and data governance protocols.
  • Coordinates with ETL Developers to create and support Business Intelligence environment.
  • Identifies and works with appropriate staff to resolve technical issues.
  • Provides on-going data consultation, including training end users on data usage and BI tools
  • Collects and analyzes external market data to provide benchmarks for comparison purposes
  • Performs additional duties as assigned


The requirements listed are representative of the knowledge, skills, and/or abilities required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions.


Five to eight years related experience

Banking/Finance experience preferred


Four-year college degree or equivalent in related field.


Computer/Office Equipment Skills

  • Strong knowledge and experience using T-SQL and MS-SQL - (MCSE Certification preferred)
  • Strong knowledge of data warehouse architecture, data modeling, data cubes, etc. and experience using SQL query techniques to access SQL Server or other relational databases.
  • Data reporting and analytics competencies (content knowledge)
  • Experience with detailed data analysis over complex data systems, including many-to-many databases
  • Experience with management of BI systems for a large organization
  • Advanced level skill for Excel
  • Intermediate knowledge in analytical software such as Tableau, Power BI, Oracle, Google Analytics
  • SSMS or SSIS experience preferred

Managerial Responsibility

Does not have managerial responsibility.

Other Skills and Abilities

  • Project management
  • Forecasting
  • Adaptive to change
  • Innovative
  • Responds positively to altered circumstances or conditions
  • Effective communication skills with technical team members as well as business partners. Able to distill complex ideas into straightforward language


Physical Demands

Ability to sit, talk and hear consistently

Ability use hands to handle or reach occasionally

Vision Requirements

Close vision (clear vision at 20 inches or less)

Distance vision (clear vision at 20 feet or more)

Weight Lifted or Force Exerted

Ability to lift up to 10 pounds occasionally


There are no unusual environmental factors (such as a typical office)

Noise Environment

Moderate noise (business office with computers and printers, light traffic)

Mountain America Credit Union is an EEO/AA/ADA/Veterans employer.

Valid Through: 2019-10-18