Consultant, Analytics & Insights (Revenue Cycle)

About Chartis

The challenges facing US healthcare are longstanding and all too familiar. We are Chartis, and we believe in better. We work with more than 1,900 organizations annually to develop and activate transformative strategies, operating models, and organizational enterprises that make US healthcare more affordable, accessible, safe, and human. With more than 1,450 professionals, we help providers, payers, technology innovators, retail companies, and investors create and embrace solutions that tangibly and materially reshape healthcare for the better. Our family of brands—Chartis, Jarrard, Greeley, and HealthScape Advisors—is 100% focused on healthcare and each has a longstanding commitment to helping transform healthcare in big and small ways. Believe in better.

Chartis has offices in Boston, Chicago, New York, Washington D.C., and Nashville.

This is a remote role that may require some occasional travel.

Role Overview

As Chartis accelerates its evolution into a more tech and AI-forward enterprise, this role sits within the Strategic Intelligence & Technology (SIT) organization—built to enable internal and external transformation through modern technology, data, and analytics capabilities that advance healthcare AI and digital transformation and deliver new insights to our clients.

Specifically, this role sits within SIT’s Analytics & Insights team, helping shape and deliver increasingly sophisticated analytic deliverables and insights to our clients while also contributing to reusable analytics assets that can be deployed and tailored to specific client use cases.

This specific role will be focused on supporting our Revenue Cycle Transformation practice. This role bridges consulting teams, business stakeholders, and technical resources by acquiring, preparing, and analyzing client data, delivering exploratory insights, upskilling our consulting teams in advanced analytical practice, and supporting the design of scalable solutions in partnership with solutions leads and engineering. This role is a foundational member of the analytics delivery team, combining hands-on SQL and business intelligence (BI) skills with business consulting acumen to ensure data-driven insights are rapidly available to projects, and we advance as a practice in bringing best-in-class insights to the market for our clients.

Responsibilities

Client Data Acquisition & Preparation

• Partner with client teams to extract and acquire structured data based on our inventory of SQL code, along with non-SQL based data needs in the future.

• Support extract, transfer, load (ETL) process with a high-touch customer service model to acquire and transmit data

• Write basic SQL scripts for data extraction and mapping.

• Perform first-level cleaning and QA (deduplication, schema alignment, missing values).

• Manage data from SFTP through to analytics deployment in internal analytics platform (Echo).

Exploratory Analysis & Insights

• Conduct exploratory/first-pass analysis to uncover trends and issues.

• Deliver stop-gap dashboards or ad-hoc reports in Power BI/Tableau to support project needs.

• Prepare first-pass deliverables for consulting teams on analytics findings.

Solution Support & Enablement

• Collaborate with Domain Data Engineers to codify business rules into advanced SQL extraction and data build tools (DBT) and with BI Engineers to create impactful data visualization and storytelling.

• Support Solutions Leads in designing analytic solutions that align with client process improvement goals.

• Coach consulting and client teams on BI tool functionality and analytic interpretation.

• Provide feedback on data quality and business logic for continuous improvement.

Qualifications and Desired Skills

• 5-8 years of relevant analytics experience, with a minimum of 2 years in a professional related healthcare field is required.

• Working knowledge of Epic Clarity database; Clarity/Cogito certification (or equivalent) is required.

• Bachelor’s Degree in a quantitative or technology-related field of study (e.g., Business, Mathematics, Economics, Statistics, Analytics, or Informatics).

• Previous experience executing analytics with programming languages (e.g., SQL, Python, R, Spark, PySpark, Scala) with deployment via notebook tools (e.g., Jupyter, Zeppelin)

• Proficiency in SQL for querying, data extraction, and basic transformations.

• Familiarity with BI tools (Power BI, Tableau). Exposure to Snowflake or other cloud-based data platforms preferred.

• Strong analytical and problem-solving skills, applying quantitative techniques to identify trends, diagnose issues, and developing evidence-based recommendations.

• Skilled collaborator who partners effectively with client teams to frame data challenges, co-develop solutions, and substantiate recommendations with data-driven insights.

• Proven ability to independently manage workstreams or projects, demonstrating initiative, accountability, and exceptional attention to detail.

• Strong understanding of organizational KPIs and the ability to link analytics and recommendations to strategic performance goals.

Salary range: $104,000-$135,000, plus may be eligible for an annual discretionary bonus. The salary range for this role takes into account the wide range of factors that are considered in making compensation decisions including, but not limited to, skills, experience, training, licensure and certifications, practice area, and other business and organizational needs. In addition, Chartis offers several benefits including medical, dental, vision, HSA, FSA, disability insurance, life insurance, 401(k) match, paid time off, wellness stipend, and additional voluntary benefits.

At Chartis, we pride ourselves on having a diverse workforce. We value and celebrate the uniqueness of individuals and the different perspectives they provide. We offer equal opportunity employment regardless of race, color, religion, gender identity or expression, sexual orientation, national origin, genetics, disability status, age, marital status, or protected veteran status.