Consultant, Analytics &amp; 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, equitable, 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&#x2014;Chartis, Jarrard, Greeley, and HealthScape Advisors&#x2014;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 &amp; Technology (SIT) organization&#x2014;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&#x2019;s Analytics &amp; 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 &amp; Preparation <ul><li>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.</li><li>Support extract, transfer, load (ETL) process with a high-touch customer service model to acquire and transmit data</li><li>Write basic SQL scripts for data extraction and mapping.</li><li>Perform first-level cleaning and QA (deduplication, schema alignment, missing values).</li><li>Manage data from SFTP through to analytics deployment in internal analytics platform (Echo). </li></ul>Exploratory Analysis &amp; Insights <ul><li>Conduct exploratory/first-pass analysis to uncover trends and issues.</li><li>Deliver stop-gap dashboards or ad-hoc reports in Power BI/Tableau to support project needs.</li><li>Prepare first-pass deliverables for consulting teams on analytics findings. </li></ul>Solution Support &amp; Enablement <ul><li>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.</li><li>Support Solutions Leads in designing analytic solutions that align with client process improvement goals.</li><li>Coach consulting and client teams on BI tool functionality and analytic interpretation.</li><li>Provide feedback on data quality and business logic for continuous improvement. </li></ul>Qualifications And Desired Skills <ul><li>5-8 years of relevant analytics experience, with a minimum of 2 years in a professional related healthcare field is required.</li><li>Working knowledge of Epic Clarity database; Clarity/Cogito certification (or equivalent) is required.</li><li>Bachelor&#x2019;s Degree in a quantitative or technology-related field of study (e.g., Business, Mathematics, Economics, Statistics, Analytics, or Informatics).</li><li>Previous experience executing analytics with programming languages (e.g., SQL, Python, R, Spark, PySpark, Scala) with deployment via notebook tools (e.g., Jupyter, Zeppelin)</li><li>Proficiency in SQL for querying, data extraction, and basic transformations.</li><li>Familiarity with BI tools (Power BI, Tableau). Exposure to Snowflake or other cloud-based data platforms preferred.</li><li>Strong analytical and problem-solving skills, applying quantitative techniques to identify trends, diagnose issues, and developing evidence-based recommendations.</li><li>Skilled collaborator who partners effectively with client teams to frame data challenges, co-develop solutions, and substantiate recommendations with data-driven insights.</li><li>Proven ability to independently manage workstreams or projects, demonstrating initiative, accountability, and exceptional attention to detail.</li><li>Strong understanding of organizational KPIs and the ability to link analytics and recommendations to strategic performance goals. </li></ul>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.

Consultant, Analytics & Insights, Revenue Cycle

About Mission Underwriting Services At Mission Underwriters, we provide the capital, issuing paper, and reinsurance access you need to launch your own Program Administrator (PA) business quickly and efficiently. We offer non-recourse capital for qualified underwriters, giving you a manageable risk profile with potential equity upside. By taking care of administrative complexities like compliance, risk management, accounting, and HR, we free you to focus on what you do best underwriting and distribution. Our turnkey platform gets you into the market in just a few months, minimizing disruption to your key relationships. With access to our network of highly rated issuing carriers and reinsurance partners, you can secure coverage with less stress and uncertainty. Built from the ground up, our purpose-driven technology simplifies workflows, enhances responsiveness, and eliminates the burden of outdated legacy systems. What We Offer <ul><li>Remote First Work Environment (US Based)</li><li>Medical, Dental, Vision</li><li>401K, 401K Match</li><li>Life and Disability Benefits</li><li>Unaccrued Paid Time Off</li><li>11 Paid Holidays</li><li>Employee Discounts</li><li>Employee Assistance Program</li><li>Educational Assistance Program</li><li>Employee Referral Program</li><li>Paid Parental Leave </li></ul>Purpose The Finance Data Analyst will serve as the primary analytical and data-process partner from the data team to the Finance team, ensuring that financial data from Mission&apos;s enterprise data warehouse (EDW) is accurate, complete, timely, and usable for accounting, reporting, and ad hoc analysis. This role will assume day-to-day responsibility for the existing finance ETL process while it remains in use, compare EDW output with this process, investigate and explain differences, and establish repeatable validations for premium, commissions, taxes, fees, payments, and other policy transaction data. The ideal candidate combines insurance accounting knowledge with strong SQL and data analysis skills, sound judgment about whether financial results make sense, and the ability to translate Finance requirements into reliable data processes. Essential Duties/Functions <ul><li>Assume day-to-day responsibility for running, monitoring, and troubleshooting the existing daily finance ETL accounting process while it remains in use, producing policy transactions and monetary amounts across premium, taxes, and fees.</li><li>Compare financial data produced by the EDW with the current finance ETL outputs; reconcile results at the appropriate policy, transaction, coverage, or other business grain.</li><li>Investigate variances and pinpoint root causes such as missing or duplicated transactions, timing differences, incorrect signs, mappings, joins, effective dates, transformation logic, or source-data defects.</li><li>Use significant SQL to query, validate, and transform policy, premium, commission, payment, tax, fee, and related financial data; develop reusable queries and process components.</li><li>Establish, document, and maintain automated validation rules, reconciliation checks, reasonableness tests, and exception reporting for financial data delivered from the EDW.</li><li>Provide Finance with accurate and timely recurring data, reports, reconciliations, and supporting schedules for accounting, reporting, close, and operational needs.</li><li>Work closely with Finance as the primary business stakeholder to define financial metrics, transaction treatments, data definitions, accounting assumptions, and acceptance criteria for EDW outputs.</li><li>Partner with data engineers to trace source-to-target logic, recommend field-level changes, validate fixes, and support reliable production processes.</li><li>Build a strong working knowledge of the EDW data model, including the insurance policy lifecycle, transaction data, source systems, data layers, grains, and relationships needed for financial reporting.</li><li>Help define how paid data is sourced, ingested, modeled, validated, and made available in the EDW, including required history, timing, grain, and financial attributes.</li><li>Support portfolio / program health check reporting through data preparation, KPI reporting, and process improvements.</li><li>Perform ad hoc analyses for Finance; quantify business impacts, explain trends, and translate findings into clear takeaways.</li><li>Create process flows, SQL documentation, data dictionaries, reconciliation procedures, and issue logs to promote repeatability and shared understanding. </li></ul>Required Qualifications <ul><li>4+ years of experience in finance data analysis, financial reporting, accounting analytics, business intelligence, or related analytical roles.</li><li>2+ years of experience working with commercial or specialty insurance, including policy, premium, commission, paid, tax, fee, or other transaction data.</li><li>Working knowledge of insurance concepts, including premium and commission transactions, taxes, fees, and reconciliations.</li><li>Strong SQL skills, including complex joins and aggregations, financial reconciliations, data validation, and development of reusable queries or processes.</li><li>Experience comparing data across systems or ETL processes and diagnosing the root causes of discrepancies.</li><li>Experience building or maintaining recurring reports, validation checks, or financial data controls using SQL, Excel, BI, or similar tools.</li><li>Strong critical thinking, attention to detail, communication, and documentation skills, with the ability to explain technical issues and financial results to Finance and Data stakeholders. </li></ul>Preferred Qualifications <ul><li>Experience supporting financial processes, planning, management reporting, or process automation.</li><li>Experience with enterprise data warehouses, relational or dimensional data models, or data pipeline development.</li><li>Familiarity with Databricks, PySpark, Python, Azure, or similar data engineering and development tools.</li><li>Experience with Power BI or other BI tools, and with ERP, general ledger, premium accounting, policy administration, or billing systems.</li><li>Bachelor&apos;s degree in finance, accounting, economics, data analytics, information systems, or a related field, or equivalent experience; ability to travel up to 5% of the year. </li></ul>Knowledge, Skills, And Abilities <ul><li>Familiarity with insurance financial data domains, including policy transactions, premium, commission, paid data, taxes, fees, reconciliations, and downstream accounting or reporting.</li><li>Ability to evaluate financial results using business context, recognize unexpected patterns, distinguish expected timing or business differences from data defects, and assess materiality.</li><li>Strong relational database and data warehousing knowledge; able to use SQL effectively across normalized and denormalized schemas and multiple data grains.</li><li>Skilled in reconciliation, variance analysis, root cause analysis, and the design of validation checks, reasonableness tests, and exception reporting.</li><li>Proficiency in Excel to prepare recurring Finance reporting and support one-off analysis.</li><li>Comfortable collaborating with data engineers and business users to trace data flows, clarify assumptions, troubleshoot processes, and drive issues to resolution.</li><li>Able to document queries, financial definitions, accounting assumptions, reconciliation logic, process flows, and data-quality decisions for shared understanding.</li><li>Detail-oriented, organized, and dependable when working with daily processes, recurring financial deliverables, and sensitive monetary data. </li></ul>Working Conditions <ul><li>Requires a quiet work environment with regular sitting at a computer for extended periods of time.</li><li> Occasional walking and standing, and lifting of up to 10 lbs.</li><li>Regular use of hands and fingers.</li><li>Frequent talking or hearing.</li><li>Vision requirements: Close, distance, color, peripheral, focus and depth perception. </li></ul>Additional Information This is a remote position. Planned, in-office activities may be required on occasion (typically 2-4x per year). You must live in the United States and be authorized to work in the United States without requirement of employment sponsorship/visa.

Data Analyst (Finance)

Job Posting: Salesforce Support &amp; BI AnalystCompany: NanosonicsLocation: United StatesWork Arrangement: RemoteTravel Requirements: Occasional travel may be required.Employment Type: Full-TimeCompensation: $90,941 - $113,676; STI 5% Nanosonics improves the safety of patients, clinics, their staff and the environment by transforming the way infection prevention practices are understood and conducted and introducing innovative technologies that deliver improved standards of care. Nanosonics is a company that specializes in the development of innovative solutions for the automated reprocessing of reusable medical devices. Today, Nanosonics has a global presence with offices across Australia, Canada, the United States of America, Europe, the United Kingdom and Japan. Global HQ is located in Macquarie Park, Sydney, where all Research &amp; Development, Manufacturing and Corporate functions reside. The US Corporate HQ is located in Indianapolis, IN. Position PurposeThe Salesforce Support &amp; BI Analyst supports the North American commercial organization through two equally weighted areas of responsibility: Salesforce end-user support (50%) and business intelligence and analytics (50%). The position combines practical user assistance, training, and governed data maintenance with the development, maintenance, and ongoing management of Power BI reports and dashboards. Reporting to the Sr. Manager, Commercial Operations - Sales Systems &amp; Analytics, this role strengthens system adoption, data quality, and visibility into commercial performance. The position works closely with the Salesforce Architect, who owns system architecture, objects, fields, layouts, record types, validation rules, and automation. The role follows established data governance and access controls, documents user needs, and supports testing of Architect-led changes. Priorities are managed to maintain the intended balance between user support and analytics. Core ResponsibilitiesSalesforce End User Support 50%<ul><li>Serve as the first point of contact for Salesforce end-user support for North American commercial teams, helping users navigate the system and complete routine business activities.</li><li>Triage and track support requests, gather examples, reproduce issues, and resolve routine questions using approved procedures; escalate configuration, automation, access, and integration issues to the Salesforce Architect or IT.</li><li>Work closely with the Salesforce Architect to follow data governance rules, approved workflows, security requirements, and change controls; route requests for objects, fields, layouts, record types, validation rules, and automation to the Architect.</li><li>Provide onboarding, refresher training, and practical guidance on Salesforce processes; partner with super users to reinforce consistent system use and adoption.</li><li>Support users with lead, account, contact, opportunity, and quoting activities, helping them understand required information and resolve routine process questions.</li><li>Perform data imports, updates, and cleanup only within delegated permissions and approved procedures; validate results and coordinate exceptions with the Architect and data owners.</li><li>Help users access and use approved Salesforce reports, dashboards, and list views; prepare operational reporting within established standards and escalate changes requiring Architect review.</li><li>Document user requirements and recurring issues for the Salesforce Architect; assist with user acceptance testing, validate business scenarios, and communicate approved changes to users.</li><li>Coordinate user onboarding, role changes, and offboarding requests with the Architect or IT, following established access approval processes.</li><li>Maintain user guides, support records, and process documentation; identify recurring training needs and recommend improvements to the Architect and Commercial Operations leadership.</li></ul> Business Intelligence and Analytics 50%<ul><li>Develop, maintain, enhance, and support Power BI dashboards and reports used by Sales, Commercial Operations, and other North American business functions.</li><li>Build and maintain data models, Power Query transformations, and DAX measures that translate approved reporting requirements into reliable business information.</li><li>Combine and analyze data from Salesforce, Microsoft Dynamics 365, AcuityMD, NanoLake/Snowflake, and other approved commercial sources.</li><li>Produce recurring reporting on revenue, units, product mix, customer and territory performance, pipeline, and other agreed commercial measures.</li><li>Perform ad hoc sales, market, account, and opportunity analyses; summarize trends, exceptions, and findings to support business decisions.</li><li>Support pipeline and forecasting analytics, territory planning, and evaluation of commercial programs, promotions, and product launches.</li><li>Validate and reconcile reporting across Salesforce, D365, Finance, and other sources; investigate discrepancies with data owners and business partners.</li><li>Maintain Power BI reporting assets, including refresh monitoring, troubleshooting, access administration, and documentation within established governance.</li><li>Partner with the Sr. Manager and Finance to maintain common metric definitions and reporting standards; help users understand reports, measures, filters, and findings.</li><li>Improve reporting efficiency and data quality through approved automation and AI-enabled tools, with appropriate validation and human review.</li></ul> Experience &amp; QualificationsRequired Qualifications<ul><li>Bachelor&apos;s degree in information systems, business analytics, business, or a related discipline, or an equivalent combination of education and relevant experience.</li><li>Hands-on experience supporting Salesforce Lightning users, including system navigation, lead and opportunity processes, account and contact data, quoting workflows, reports, and dashboards.</li><li>Experience troubleshooting user issues, documenting support requests, providing training, and performing approved data imports, updates, and data-quality checks.</li><li>Working knowledge of Salesforce permissions, data governance, and change controls; ability to collaborate with a Salesforce Architect, follow approved procedures, and support user acceptance testing.</li><li>Demonstrated experience developing and supporting Microsoft Power BI reports and dashboards, including data modeling, Power Query, DAX, and effective data visualization.</li><li>Understanding of commercial measures such as revenue, units, pipeline, forecast, attainment, customer performance, territory performance, and market opportunity.</li><li>Ability to translate user needs into clear requirements for the Salesforce Architect and business reporting needs into practical reports, dashboards, and analyses.</li><li>Strong troubleshooting and analytical skills, including the ability to investigate system issues, data discrepancies, trends, and root causes.</li><li>Ability to communicate with technical and non-technical users, provide practical training, and balance end-user support requests with recurring analytical work.</li></ul>Preferred Qualifications<ul><li>Three (3) or more years of relevant experience across Salesforce user support, sales operations, business intelligence, or commercial analytics, with demonstrated hands-on capability in both Salesforce support and Power BI; healthcare or medical device experience preferred.</li><li>Advanced Microsoft Excel skills and experience combining, reconciling, and validating data from CRM, ERP, and data warehouse sources; D365 or Snowflake experience preferred.</li><li>Experience maintaining Power BI refreshes, workspaces, and report access within established governance; working knowledge of SQL preferred.</li><li>Microsoft Power BI certification preferred; Salesforce certification or formal Salesforce training is an advantage.</li><li>Experience using approved automation or AI-enabled tools to improve system support, analysis, or reporting efficiency preferred.</li></ul> Candidates are encouraged to apply even if they do not meet every preferred or nice-to-have qualification. Nanosonics is committed to fostering a diverse, inclusive, and equitable workplace where everyone feels valued and respected. We welcome applicants of all backgrounds and strive to ensure equal opportunities in recruitment, development, and advancement. We uphold the principle of equal pay for equal work and actively work to eliminate any unexplainable pay gaps. If you&#x2019;re passionate about contributing to an environment where diversity thrives, we encourage you to apply.

Data Analysis jobs in Los Angeles, CA

Companies hiring for Data Analysis in Los Angeles, CA

Data Analysis in other regions

More jobs in Los Angeles, CA

Data Analysis jobs in Los Angeles, CA

Companies hiring for Data Analysis in Los Angeles, CA

Related searches

Data Analysis in other regions

More jobs in Los Angeles, CA