[Remote] Consultant, Analytics & Insights Provider, CSIT

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.ResponsibilitiesPartner 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 futureSupport extract, transfer, load (ETL) process with a high-touch customer service model to acquire and transmit dataWrite basic SQL scripts for data extraction and mappingPerform 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 issuesDeliver stop-gap dashboards or ad-hoc reports in Power BI/Tableau to support project needsPrepare first-pass deliverables for consulting teams on analytics findingsCollaborate 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 storytellingSupport PI Solutions Leads in designing analytic solutions that align with client process improvement goalsCoach consulting and client teams on BI tool functionality and analytic interpretationProvide feedback on data quality and business logic for continuous improvementSkills5+ years in a healthcare IT roleDeep understanding of healthcare operations and revenue cycle workflows, with the ability to translate complex data into actionable business requirements and workflow optimization strategiesStrong analytical and problem-solving skills, applying quantitative techniques to identify trends, diagnose issues, and developing evidence-based recommendationsProficiency in SQL, data modeling, visualization tools (Power BI, Tableau), and experience supporting ETL processes within modern data environmentsAbility to bridge technical configurations and data structures with operational needs to drive measurable business outcomesSkilled collaborator who partners effectively with client teams to frame data challenges, co-develop solutions, and substantiate recommendations with data-driven insightsStrong communication and interpersonal skills, with the ability to convey complex information clearly to stakeholders at all levelsProven ability to independently manage workstreams or projects, demonstrating initiative, accountability, and exceptional attention to detailStrong understanding of organizational KPIs and the ability to link analytics and recommendations to strategic performance goalsProficiency in SQL for querying, data extraction, and basic transformationsProficiency in prompt engineering with large language models (LLMs) and demonstrated outcomes in advancing thinking through LLM partnershipFamiliarity with BI tools (Power BI, Tableau)Comfortable working directly with clients to acquire data and define analytic needsAbility to balance quick-turn deliverables with longer-term solution developmentExposure to Snowflake or other cloud-based data platforms preferredPrior experience with Epic is highly desiredBenefitsMay be eligible for an annual discretionary bonusMedicalDentalVisionHSAFSADisability insuranceLife insurance401(k) matchPaid time offWellness stipendAdditional voluntary benefitsCompany OverviewSomos 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.