Note: The job is a remote job and is open to candidates in USA. Chartis is a purpose-driven organization focused on reshaping healthcare through analytics and insights. The Consultant, Analytics & Insights Provider role involves acquiring and analyzing client data to deliver insights and support the design of scalable solutions, while collaborating with consulting teams and technical resources.

Responsibilities

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

Skills

• 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
• 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)
• Comfortable working directly with clients to acquire data and define analytic needs
• Ability to balance quick-turn deliverables with longer-term solution development
• Exposure to Snowflake or other cloud-based data platforms preferred
• Prior experience with Epic is highly desired

Benefits

• May be eligible for an annual discretionary bonus
• Medical
• Dental
• Vision
• HSA
• FSA
• Disability insurance
• Life insurance
• 401(k) match
• Paid time off
• Wellness stipend
• Additional voluntary benefits

Company Overview