Business Intelligence Analyst III – Quality

Business Intelligence Analyst III – Quality

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.

• 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.

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…