Government Healthcare Provider Rate Consultant

We need to output HTML fragment with sections: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Only include sections that have real specific content. Must not repeat job title. Must not include Job ID etc. Must remove boilerplate like EEO, accommodation, etc. Must preserve all substantive info. Let's parse the posting: Intro: "We are seeking a talented individual to join our Government Human Services Consulting (GHSC) team, part of our People & Investments business at Marsh. This role can be based in Atlanta, Minneapolis, Phoenix, Seattle, or DC and offers a hybrid work arrangement, requiring a minimum of three days per week in the office." That's about role location and hybrid schedule. Then description: "The Government Healthcare Provider Rate Consultant partners with state governments and internal teams to examine financial reports in order to understand emerging Medicaid health care experience as well as the financial performance of managed care organization and interacts with credentialed actuaries and financial executives to ensure Medicaid dollars are being utilized efficiently. We specialize in assisting government-sponsored programs in becoming more efficient purchasers of health services. We bring the best critical thinkers forward in helping our clients address their issues." Then bullet list of responsibilities: "We will count on you to: Perform comprehensive analysis of health care, financial and other detail data using spreadsheet and database management software, with most time spent in Excel Work with client and team project managers to clearly define the scope, timelines and deliverable(s) of the project; ensure development and proposes essential project documents, including the budget and work plans Assist in the development of reports, spreadsheets, and presentations Ensure regular communication with client to review project status and expectations; provide expertise and insight to the client and team to solve potential problems within the project; manage scope of project, budget and timelines Thrive and be motivated by an environment that embraces AI and technology-enabled tools" Then "What you need to have:" list: BA/BS degree in economics, finance, accounting, business analytics, mathematics, statistics, or a related analytical major 3+ years of healthcare financial analysis experience, rate analysis, and provider payment modeling. Ability to work on team projects and initiatives in a dynamic environment Strong Microsoft Excel skills, including experience using formulas and functions to organize, analyze and interpret data with a strong desire to work in complex financial forecasting models Then "What makes you stand out?" list: Medicaid program experience Knowledge of data analysis, project management, and presentation design Excellent interpersonal, verbal, and written communication skills Intellectual curiosity Ability to work collaboratively on a team Flexibility to respond to changing client needs Superior organizational skills and strong attention to detail Creative problem-solving abilities Ability to manage multiple projects in a fast-paced environment Then "Why join our team:" list: We help you be your best through professional development opportunities, interesting work and supportive leaders. We foster a vibrant and inclusive culture where you can work with talented colleagues to create new solutions and have an impact on colleagues, clients, and communities. Our scale enables us to provide a range of career opportunities, as well as benefits and rewards to enhance your well-being. Marsh (NYSE: MRSH) is a global leader in risk, reinsurance and capital, people and investments, and management consulting, advising clients in 130 countries. With annual revenue of over $27 billion and more than 95,000 colleagues, Marsh helps build the confidence to thrive through the power of perspective. For more information, visit marsh.com, or follow us on LinkedIn and X. Marsh is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age background, disability, ethnic origin, family duties, gender orientation or expression, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, veteran status (including protected veterans), or any other characteristic protected by applicable law. If you have a need that requires accommodation, please let us know by contacting reasonableaccommodations@marsh.com. Marsh is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams will identify at least one “anchor day” per week on which their full team will be together in person. Then pay: "The applicable base salary range for this role is $68,500 to $137,000. The base pay offered will be determined on factors such as experience, skills, training, location, certifications, education, and any applicable minimum wage requirements. Decisions will be determined on a case-by-case basis. In addition to the base salary, this position may be eligible for performance-based incentives. We are excited to offer a competitive total rewards package which includes health and welfare benefits, tuition assistance, 401K savings and other retirement programs as well as employee assistance programs." Then ID: R_361761 (should be dropped). We need sections: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We need to decide what goes where. - About the role: likely the introductory paragraph describing role purpose, location, hybrid arrangement, and maybe the mission statement. Could include the description of what the role does (partner with state governments, etc). That seems like role overview. - Responsibilities: the list after "We will count on you to:" includes tasks. - Requirements: maybe the "What you need to have:" (degree, years experience, ability to work on team projects, Excel skills). Could be considered requirements. - Qualifications: maybe the "What makes you stand out?" list (Medicaid experience, knowledge, communication skills, etc). Could be qualifications/preferred. - Skills: maybe separate out technical skills like Excel, data analysis, project management, presentation design. But we already have some in requirements. Could combine. - Benefits: from "Why join our team:" includes professional development, inclusive culture, career opportunities, benefits and rewards, plus later total rewards package (health and welfare benefits, tuition assistance, 401K, retirement programs, employee assistance). Also mention Marsh global leader etc but that's more company info. We'll include benefits. - Pay: salary range and performance incentives. - Schedule: hybrid work arrangement, minimum three days per week in office, anchor day, etc. We must not create sections with filler like "commensurate with experience". We have actual content. We must not repeat job title. Not include Job ID. We must not include boilerplate like EEO, accommodation request, diversity statement, etc. Remove those lines. We must preserve all substantive information. So we need to keep location list, hybrid arrangement, description of role, responsibilities list, requirements list, standout list, benefits list, pay range, schedule details. We must not include the accommodation request line, diversity statement, etc. Also remove the Marsh global leader description? That's substantive about company but maybe not required? The instruction: "Preserve ALL substantive information; do NOT invent or summarize away detail." So we should keep that info unless it's considered boilerplate? It's about Marsh being a global leader, revenue, etc. That's substantive about the company. Might be okay to keep. However, the instruction also says remove cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, and application instructions. The Marsh description is not boilerplate; it's company info. Might be okay to keep under "Why join our team" or maybe a separate section like "About Marsh". But we only have allowed sections list; we could put it under "Why join our team" as part of benefits/culture. It's okay. We must not include the line about reasonableaccommodations@marsh.com. Remove. We must not include the line about "If you have a need that requires accommodation, please let us know..." Remove. We must not include the diversity statement lines. Remove. We must not include the line about Marsh committed to hybrid work etc? That's schedule info, we keep. We must not include the line about "All Marsh colleagues are expected to be in their local office or working onsite with clients at least three days per week." That's schedule. We must not include the line about "Office-based teams will identify at least one “anchor day” per week on which their full team will be together in person." That's schedule. Now craft HTML. We'll have sections:

About the role

We are seeking a talented individual to join our Government Human Services Consulting (GHSC) team, part of our People & Investments business at Marsh. This role can be based in Atlanta, Minneapolis, Phoenix, Seattle, or DC and offers a hybrid work arrangement, requiring a minimum of three days per week in the office. The Government Healthcare Provider Rate Consultant partners with state governments and internal teams to examine financial reports in order to understand emerging Medicaid health care experience as well as the financial performance of managed care organizations and interacts with credentialed actuaries and financial executives to ensure Medicaid dollars are being utilized efficiently. We specialize in assisting government-sponsored programs in becoming more efficient purchasers of health services. We bring the best critical thinkers forward in helping our clients address their issues.

Then Responsibilities:

Responsibilities

• Perform comprehensive analysis of health care, financial and other detail data using spreadsheet and database management software, with most time spent in Excel
• Work with client and team project managers to clearly define the scope, timelines and deliverable(s) of the project; ensure development and propose essential project documents, including the budget and work plans
• Assist in the development of reports, spreadsheets, and presentations
• Ensure regular communication with client to review project status and expectations; provide expertise and insight to the client and team to solve potential problems within the project; manage scope of project, budget and timelines
• Thrive and be motivated by an environment that embraces AI and technology-enabled tools

Requirements:

Requirements

• BA/BS degree in economics, finance, accounting, business analytics, mathematics, statistics, or a related analytical major
• 3+ years of healthcare financial analysis experience, rate analysis, and provider payment modeling
• Ability to work on team projects and initiatives in a dynamic environment
• Strong Microsoft Excel skills, including experience using formulas and functions to organize, analyze and interpret data with a strong desire to work in complex financial forecasting models

Qualifications (preferred):

Qualifications

• Medicaid program experience
• Knowledge of data analysis, project management, and presentation design
• Excellent interpersonal, verbal, and written communication skills
• Intellectual curiosity
• Ability to work collaboratively on a team
• Flexibility to respond to changing client needs
• Superior organizational skills and strong attention to detail
• Creative problem-solving abilities
• Ability to manage multiple projects in a fast-paced environment

Skills: maybe we could separate technical skills like Excel, data analysis, project management, presentation design. But we already have Excel in requirements, and data analysis etc in qualifications. Could still have a Skills section summarizing: Strong Excel, data analysis, project management, presentation design. But to avoid duplication, maybe we skip Skills section if content overlaps. However instruction: Prefer a few substantive sections over many thin ones. We could combine Skills into Requirements or Qualifications. But we need to include a Skills section only if posting has real specific content for it. The posting does mention "Strong Microsoft Excel skills", "Knowledge of data analysis, project management, and presentation design". That's skills. Could make a Skills section with those items. But then we would duplicate content from Requirements and Qualifications. Better to not duplicate; we could move Excel to Skills, and data analysis etc to Skills, and adjust Requirements/Qualifications accordingly. However we must preserve ALL substantive information; moving