Business Intelligence Analyst III -Quality

Colorado Access; Denver (CO); Hybrid; USD 95,000 - 126,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Flexible spending accounts

Life insurance

Disability insurance

Paid time off

Tuition reimbursement

Annual bonus program

Job summary

Colorado Access seeks a Business Intelligence Analyst III - Quality to shape data-driven decisions for our quality initiatives. You will collaborate with multiple departments, translate complex data requests into actionable dashboards, and present results to senior management.

The role emphasizes Power BI, SSRS, and Tableau expertise within a hybrid Denver-area environment. The ideal candidate has five years in healthcare data analytics, strong SQL skills, and experience with behavioral health

Qualifications

• Five years of healthcare data experience with at least four years of SQL experience.
• Experience with advanced data reporting and analysis methods.
• Familiarity with data sources and reporting tools (Power BI, SSRS, Tableau).
• Knowledge of CPT, ICD coding systems and managed care terminology.
• Ability to translate complex data requests into clear dashboards and ad hoc analyses.

Responsibilities

• Primary point of contact for department data requests and meetings.
• Analyze requirements and design customer reporting and analytic requests.
• Develop and update dynamic reports in Power BI and SSRS for senior management.
• Identify actionable issues through data interpretation and research.
• Develop methodologies using various data sources and tools; troubleshoot data issues.

Skills

SQL

Power BI

SSRS

Tableau

Python

Toad

SSMS

Data analysis

Education

Bachelor's degree in health care related area

Tools

Power BI

SSRS

SSMS

Tableau

Toad

Job description

Why should you consider a career with Colorado Access?

We are a Colorado-based company, working to improve the health of our state. We care for individuals, families, and children who receive health care under Child Health Plan Plus (CHP+) and Health First Colorado (Colorado's Medicaid Program). Our focus is driving improvements in quality, member experience, outcomes, and cost. We are a mission-driven organization whose foundation is built by our vision, supported by our values and pillared by diversity, equity and inclusion.

• Find work/life balance: We offer PTO, floating holidays, nine company paid holidays, a hybrid work environment, an Employee Assistance Program and a 401K.
• Be a part of something bigger and make an impact: We serve the underserved and most vulnerable populations in our community through access to quality and affordable health care. No matter what you do for Colorado Access, you are impacting our community and making a difference.
• Sharpen your skills, learn, and grow: We support your continued development through tuition reimbursement, leadership training, promotion opportunities, performance evaluations, employee recognition, and a language pay stipend.

What you will do:

We are looking for a BUSINESS INTELLIGENCE ANALYST III - QUALITY who can help shape our vision and support our mission. Here is what the position will look like.

• 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. Key considerations in the selection process include: Colorado Access, Financial Analysis, and Line of Business strategic plan alignment, Business problems and opportunities, Operational efficiency, Process improvement Techniques used in analysis and design include, but are not limited to: Report Mockups, Analytical Project Design.
• 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.

What you will bring:

Education: bachelor’s degree in health care related area, statistics, or computer systems.. Equivalent combination of experience and/or education may substitute with a preference for four years progressive relevant work experience.

Experience: Minimum of five years’ experience in healthcare data related field with 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. Exposure to value-based care analytics, Pay-for-Performance or Shared Savings performance tracking, HEDIS Measures and financial projections modeling is a plus.

Knowledge, Skills, and Abilities: 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. Position requires 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. Must have strong interpersonal and teamwork skills with good organizational and time management skills. May be required to manage multiple priorities and projects with tight deadlines. Must be proficient in MS-Office applications (Excel, Access, Word, Power Point) 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.

Licenses/Certifications: A valid driver's license and proof of current auto insurance will be required for any position requiring driving.

Together we will be: an innovative and collaborative team who supports each other, the employees and vision of the company to reach our goals individually, together and as an organization.

Pay, Perks and Benefits at Colorado Access:

The compensation for this position is $94,600.00 - $126,200.00 annually. Colorado Access has provided a compensation range that represents its good faith estimate of what Colorado Access may pay for the position at the time of posting. Colorado Access may ultimately pay more or less than the posted compensation range. The salary offered to the selected candidate will be determined based on factors such as the qualifications of the selected candidate, departmental budget availability, internal salary equity considerations, and available market information, but not based on a candidate’s sex or any other protected status.

• 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).
• Paid time off
• Tuition reimbursement (based on eligibility).
• Annual bonus program (based on eligibility, requirements and performance).

Where you will work:

This position will be a hybrid model work environment, a blend of ‘In-Office’ and ‘Remote.’

We are not able to support out of state employees at this time as we continue to serve our members and community in the metro Denver area and across the beautiful state of Colorado.