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. No Job ID. Remove boilerplate, navigation, legal, EEO, etc. Must preserve all substantive info. We need to parse the posting. Content: - 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." - 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 "We will count on you to:" list of duties: - 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 - "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 - "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 - "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. - 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. - At end: "R_361761" (Job ID) to be dropped. We need to produce sections: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We need to decide which sections have content. - About the role: Could be the introductory paragraph describing role and location/hybrid. That seems appropriate. - Responsibilities: The "We will count on you to:" list. - Requirements: Could be the "What you need to have:" list (education, experience, ability to work, Excel skills). Might be considered requirements. - Qualifications: Could be "What makes you stand out?" list (preferred qualifications). Could be separate. - Skills: Could be overlapping with requirements; but we need to avoid duplication. Perhaps we treat "What you need to have:" as Requirements (education, experience) and "What makes you stand out?" as Qualifications (preferred). Skills could be extracted from those lists: Excel skills, data analysis, project management, presentation design, communication, etc. But we must not invent or summarize away detail; we must preserve all substantive info. If we create a Skills section, we must include only content that is explicitly about skills. However, the posting already includes skill-related items in both sections. We could decide to not create a separate Skills section if it would duplicate or be thin. The instruction: "Prefer a few substantive sections over many thin ones." So we could combine skill-related items into Requirements or Qualifications. But we need to follow the headings list: we can include only those headings that have real specific content. If we think Skills would be thin or duplicate, we can omit it. - Benefits: The "Why join our team:" includes benefits: professional development opportunities, interesting work, supportive leaders, vibrant inclusive culture, range of career opportunities, benefits and rewards to enhance well-being, etc. Also mentions health and welfare benefits, tuition assistance, 401K savings, retirement programs, employee assistance programs. That's substantive. So we can include Benefits. - Pay: The salary range and performance-based incentives. That's specific. So include Pay. - Schedule: The hybrid work arrangement: minimum three days per week in office, location options, hybrid. That's schedule info. So include Schedule. We must not include boilerplate like EEO, legal, accommodation contact, diversity statement, etc. Remove those. We must not include navigation, cookie, etc. We must not repeat job title. We must not include Job ID. We must not include sections with filler like "commensurate with experience". Not present. Now craft HTML. Structure:

About the role

... (intro paragraph(s) about role, location, hybrid)

Responsibilities

• ...
...

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

• 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

Benefits

• Professional development opportunities, interesting work and supportive leaders
• Vibrant and inclusive culture where you can work with talented colleagues to create new solutions and have an impact on colleagues, clients, and communities
• Range of career opportunities and benefits and rewards to enhance your well-being
• Health and welfare benefits, tuition assistance, 401K savings and other retirement programs, employee assistance programs

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.

Schedule

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.

We need to ensure we didn't include any boilerplate like "Marsh is committed to hybrid work..." etc. That's part of schedule? Actually we already captured hybrid arrangement in schedule. The extra sentences about Marsh commitment to hybrid work, anchor day, etc are more boilerplate; we can drop them as they are generic. The instruction: remove duplicated lines, cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate. The hybrid work details beyond the minimum three days might be considered boilerplate but still substantive? The posting says: "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." This is somewhat generic but still about schedule. However we already have schedule sentence. To avoid duplication, we could include that extra detail in schedule section as well, but it's not duplicated elsewhere. The instruction: "Prefer a few substantive sections over many thin ones." Including extra schedule details may be okay. But we must not include boilerplate like EEO etc. The hybrid work description is not EEO; it's about work arrangement. Might be okay to include. But we already have schedule sentence: "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 captures location and hybrid requirement. The extra sentences about flexibility of working remotely, collaboration benefits, anchor day are additional but not required. Could be included to preserve all substantive info. The instruction: "Preserve ALL substantive information; do NOT invent or summarize away detail." So we should include all substantive info