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
Somos uma empresa especializada em consultoria e contabilidade geral. It was founded in 2016, and is headquartered in São José dos Campos, São Paulo, BR, with a workforce of 2-10 employees. Its website is http://www.gestaosmart.com.br.