Apply on Employer Site

Colorado Access · 3 weeks ago

Business Intelligence Analyst III

11100 E Bethany Dr, Aurora, CO 80014, USA

Full-time

Hybrid

Senior Level

$95K/yr - $121K/yr

7+ years exp

Colorado Access is a Colorado-based company focused on improving the health of the state by providing quality and affordable care. The Business Intelligence Analyst III will analyze and document requirements, transform complex requests into actionable products, and identify data quality issues while supporting the company's strategic plan.

FitnessHealth CareNon Profit

Responsibilities

Serves as an integrated line of business team member 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, Business Intelligence, 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. Identifies and creates new data objects. 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 Business Intelligence 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

Qualification

SQLPower BIData analysisHealthcare dataPythonToadBusiness ObjectsTableauAnalytical skillsProblem solvingCommunication skillsTeamworkOrganizational skills

Required

Bachelor's degree in health care related area, statistics, computer systems, finance or accounting

Minimum of seven years' experience in healthcare data related field with at least three 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, Business Objects, Power BI, 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

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 with good organizational and time management skills

Proficient in MS-Office applications (Excel, Access, Word, Power Point)

Experience with data management and query tools, such as Power BI and Tableau and SQL Experience is required

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