Consultant, Analytics & Insights, Revenue Cycle

Process Intelligence Consultant, Financial Performance Improvement About Chartis Chartis comprises 1,350 professionals who value working for a purpose-driven organization, people who have committed their careers to helping providers, payers, technology innovators, retail companies, and investors create and embrace solutions that reshape healthcare for the better. We work with over 900 clients annually to help make US healthcare more affordable, accessible, safe, and human. Through our family of brands—Chartis, Jarrard, Greeley, and HealthScape Advisors—we have created a culture that prioritizes respect for our clients, commitment to each other, and unwavering integrity. From physicians, nurses, healthcare executives, and community health leaders to strategists, digital advisors, transactions experts, and healthcare futurists, we bring a diverse set of perspectives to assess healthcare challenges from every angle. Believing in what we do helps us attract and retain the best and brightest because the work we do every day makes a meaningful impact. This theme of believing in a better way forward is woven into our brand, Believe in better. Chartis has offices in Boston, Chicago, New York, Washington D.C., and Nashville. This is a remote position with minimal travel requirements. Role Overview The Process Intelligence (PI) Consultant is a client-facing analytics role embedded within the Process Intelligence team in the 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 PI Solutions Leads and PI engineering. The PI Consultant 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. The role is grounded in our PI Team Principles, ensuring that analytics is not just a technical function but a driver of measurable practice outcomes. Key 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 PI 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, Desired Skills & Experience Summary: 5+ years in a healthcare IT role Deep understanding of healthcare operations and revenue cycle workflows, with the ability to translate complex data into actionable business requirements and workflow optimization strategies. Strong analytical and problem-solving skills, applying quantitative techniques to identify trends, diagnose issues, and developing evidence-based recommendations. Proficiency in SQL, data modeling, visualization tools (Power BI, Tableau), and experience supporting ETL processes within modern data environments. Ability to bridge technical configurations and data structures with operational needs to drive measurable business outcomes. Skilled collaborator who partners effectively with client teams to frame data challenges, co-develop solutions, and substantiate recommendations with data-driven insights. Strong communication and interpersonal skills, with the ability to convey complex information clearly to stakeholders at all levels. 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. Mindset: Curious problem-solver — eager to explore data for hidden issues and opportunities. Comfortable with ambiguity; able to prototype quickly and iterate. Hungry to learn; acknowledges their lack of expertise in a rapidly changing world of technology and willing to constantly upskill. Team-oriented — thrives in a collaborative, cross-functional environment. Technical: Proficiency in SQL for querying, data extraction, and basic transformations. Proficiency in prompt engineering with large language models (LLMs) and demonstrated outcomes in advancing thinking through LLM partnership. Familiarity with BI tools (Power BI, Tableau). Exposure to Snowflake or other cloud-based data platforms preferred. Prior experience with Epic is highly desired. Consulting/Business: Strong communication skills — able to translate technical analysis into business insights. Comfortable working directly with clients to acquire data and define analytic needs. Ability to balance quick-turn deliverables with longer-term solution development. Career Path Entry point into the Process Intelligence (PI) analytics career track. Growth into PI Solutions leadership roles that are involved in designing and embedding full analytic solutions. Opportunity to deepen technical expertise or consulting expertise. Salary range: $118,000-$172,500, 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.