Business Intelligence Analyst

• Salary Range: $89,648 - $125,507 annually based on relevant years of experience
• Location: Larimer County, Colorado
• Full time, 40 hours per week
• Hours: Monday- Friday

The salary range for this position is SummitStone’s good faith belief and reasonable estimate of the range of possible compensation for this position at the time of the posting. SummitStone may ultimately offer more or less than the posted range. The compensation offered to the successful applicant may vary based on factors including the applicant’s education, training, skills, experiences, and other job-related information and how relevant those are to SummitStone’s needs, aspirations, organizational priorities, and the evolving needs and delivery of services to the community that it serves.

Role Overview:

Responsible for transforming healthcare and organizational data into actionable insights through the design, development, and delivery of analytic and reporting solutions. Supports all levels of the organization by interpreting, organizing, and communicating data in meaningful ways that inform operational, clinical, and strategic decisions. Translates complex business and clinical processes into intuitive, efficient data structures using SQL and business intelligence tools such as Power BI. Determines and documents requirements, develops queries and visualizations, and applies professional judgment to recommend data solutions and presentation methods. Demonstrates strong collaboration and communication skills by engaging with internal stakeholders to ensure data is accurate, accessible, and aligned with organizational priorities.

Essential Duties:

• Design, build, enhance, and maintain reports, dashboards, and data models through direct interaction with business and clinical users.
• Develop and maintain formal and ad hoc reports in support of internal programs, grants and external agencies (including quality and state reporting).
• Conduct complex and detailed data analysis to identify, interpret, and communicate trends, anomalies and actionable insights to support decision-making.
• Perform ad hoc and formal data extraction and analysis using T-SQL within the Data Warehouse environment.
• Perform data analysis and reporting using EPIC tools such as Slicer Dicer or Clarity, ensuring consistency and accuracy across platforms.
• Contribute to the development and continuous improvement of BI and reporting standards, procedures, and documentation.
• Execute data validation and quality assurance processes in support of data governance initiatives and compliance with reporting requirements.
• Collaborate with cross-functional teams to understand data needs, define metrics and design scalable analytic solutions that support clinical, financial, and operational outcomes.
• Maintain awareness of industry best practices and emerging BI technologies relevant to healthcare data analytics.
• Perform other duties as assigned.

Minimum Qualifications:

• Bachelor’s degree in healthcare, Informatics, Finance, Business, Computer Science, or related field required.
• More than four years of proven experience developing data and reporting solutions in a healthcare or similarly complex environment required.
• More than two years of experience working with Power BI or similar business intelligence platform required.
• Proven experience working with healthcare-related data—including EHR/EMR systems, claims, quality, and financial sources—with a solid understanding of applicable privacy and security standards required
• Equivalent combination of education and experience may be evaluated and considered.

Preferred Qualifications:

• EPIC Certification – Report Writer (Clarity / Caboodle) preferred.
• Bilingual/bi-cultural preferred

SummitStone will take into consideration a combination of an applicant’s education, training, skills, experiences, and other job-related information and how relevant those are to SummitStone’s needs, aspirations, organizational priorities, and the evolving needs and delivery of services to the community that it serves. The position posting describes the minimum and preferred qualifications for position and, beyond those, the candidate is responsible for making a compelling case in support of their application.

At SummitStone Health Partners, we strive to foster trust, empower recovery, and inspire hope to strengthen and enrich our Northern Colorado community.

We need your help to make this vision a reality.

We are committed to fostering a diverse and inclusive environment where everyone can be their authentic self. We actively seek team members with a variety of backgrounds, identities, and experiences, and we honor the whole self—embracing differences in race, ethnicity, ability, age, gender, sexual orientation, spiritual beliefs, socioeconomic status, language, and the many intersections of identity. We invite everyone to be part of our journey and proudly serve as an equal opportunity employer.

Please visit summitstone.org for more information about who we are.

Total Rewards

At SummitStone Health Partners, we are proud to offer a comprehensive and competitive benefits package designed to support the well-being of our team members. Eligibility and pro-rated benefit levels are based on FTE (full-time equivalent) status.

Below are some of the benefits we offer:

• Medical, dental, and vision coverage — including options for eligible dependents

• Mental health and wellness resources

• Short-term and long-term disability insurances

• Paid time off (PTO): Accrued vacation and personal leave based on FTE status and length of service

• Paid Sick Leave: Provided in accordance with the Colorado Healthy Families and Workplaces Act (HFWA)

• A range of voluntary benefits available to all employees

• 403(b) retirement plan with employer matching contributions

Health & Safety Requirement

All employees are required to receive an annual flu vaccination or have an approved exemption in place and wear a mask during flu season

Reach Out

SummitStone will provide persons with disabilities with reasonable accommodations. If reasonable accommodation is needed to participate in the job application or selection process, please let your recruiter know.

Questions? Please email us at hiring@summitstonehealth.org.

This position will be open for a minimum of three days and/or until a top candidate is identified.