Business Intelligence Analyst III - Quality

Colorado Access•Denver, CO

1d•$94,600 - $126,200•Hybrid

About The Position

Colorado Access is seeking a BUSINESS INTELLIGENCE ANALYST III - QUALITY to help shape their vision and support their mission. This role serves as the primary point of contact for department data requests, working with multiple departments to gather information and representing the Quality team in meetings where new data requests are reviewed. The analyst will act as an integrated line of business team member, ensuring information needs are understood, complete specifications are identified, and appropriate analysis, research, or reporting is provided. This includes designing and documenting customer reporting and analytic requests, considering strategic alignment, business problems, operational efficiency, and process improvement. The role involves transforming complex Business Intelligence requests into useful products with actionable outcomes, developing and updating dynamic reports in PowerBI and SSRS, and presenting results to Senior Management. The analyst will identify actionable issues through data interpretation and research, provide summaries of trends and observations, and apply advanced data analysis and statistical techniques. They will also develop methodologies, create new tools and system enhancements, troubleshoot data issues, and resolve data quality issues. Participation in training programs and maintaining an individual training strategy is also required. Specific elements of the Company’s Strategic Plan will be identified as focus areas and included as position responsibilities.

Requirements

Bachelor’s degree in a health care related area, statistics, or computer systems.
Equivalent combination of experience and/or education may substitute.
Minimum of five years’ experience in healthcare data related field.
At least four years of SQL experience.
Significant and demonstrated experience with advanced data reporting and analysis methods, data management and query tools including the use of Toad, SSMS, SSRS, Power BI, Business Objects, Tableau, Python, or other similar tools required.
Expert understanding of health benefits, medical terminology, medical procedures, and managed care industry.
Expertise with CPT, ICD and other coding systems.
Demonstrated analytical, problem solving, and research ability as evidenced by experience in the identification of requirements and the definition, evaluation, and selection of appropriate solutions to business problems or opportunities.
Ability to pivot and respond quickly with complicated ad hoc analyses of claims expense, membership, and provider performance.
Demonstrates support for the company’s mission, vision and values.
Excellent written and verbal communication skills.
Demonstrated ability for turning complicated verbal requests into reports and queries.
Ability to interpret complex data results and effectively summarize information that can be easily translated into company action.
Strong interpersonal and teamwork skills.
Good organizational and time management skills.
May be required to manage multiple priorities and projects with tight deadlines.
Proficient in MS-Office applications (Excel, Access, Word, Power Point).
A valid driver's license and proof of current auto insurance will be required for any position requiring driving.

Nice To Haves

Preference for four years progressive relevant work experience.
Exposure to value-based care analytics, Pay-for-Performance or Shared Savings performance tracking, HEDIS Measures and financial projections modeling is a plus.
Familiarity with Medicaid quality programs, health plan performance metrics, and NCQA standards preferred.
Ability to translate quality program requirements into dashboard specifications and analytic products.
Experience working with cross-functional teams including quality, finance, and operations.
Understanding of intervention effectiveness evaluation methods and gap closure analytics.

Responsibilities

Is the primary point of contact for department data requests.
Works with multiple departments to gather information regarding requests.
Represents the Quality team in meetings where new data requests are reviewed or requested.
Serves as an integrated line of business team members ensuring that information needs are understood, complete specifications are identified, and the appropriate analysis, research, report, or other support is identified to address those needs.
Analyzes and documents requirements through research, data gathering, and brainstorming activities.
Designs and documents customer reporting and analytic requests by defining, creating, evaluating, and selecting alternatives.
Transforms complex Business Intelligence requests, both internal and external, into useful products with actionable outcomes that utilize the most credible and efficient data source, subject to relevant materiality levels.
Develops and updates dynamic reports in PowerBI and SSRS, and presents report results to Senior Management.
Identifies actionable issues through data interpretation and research.
Provides summary of trends, observations, and actionable items on complex reporting issues and development reports.
Applies advanced data analysis and statistical techniques to answer any number of complex data questions and initiatives.
Validates that output meets Line of Business needs.
Partners with Line of Business Directors to “dig deeper” into output and identifies areas of further analysis.
Utilizes a variety of software applications and data sources to develop methodologies for the department and the Analysis and Reporting Team.
Actively develops new tools and system enhancements, troubleshoots and solves data issues.
Seeks out, identifies, documents, and initiates resolutions to data quality issues that are discovered during report and analysis development.
Participates in available training programs and maintains an individual training/education strategy with immediate supervisor.
In coordination with Department management, specific elements of the Company’s Strategic Plan will be identified as focus areas for this position and will be included as position responsibilities.

Benefits

PTO
Floating holidays
Nine company paid holidays
Employee Assistance Program
401K
Tuition reimbursement
Leadership training
Promotion opportunities
Performance evaluations
Employee recognition
Language pay stipend
Medical, dental, vision insurance that starts the first day of the month following start date.
Supplemental insurance such as critical illness and accidental injury.
Health care and dependent care flexible spending account options.
Employer-paid basic life insurance and AD&D (employee, spouse and dependent).
Short-term and long-term disability coverage.
Voluntary life insurance (employee, spouse, dependent).
Annual bonus program