Senior Data Analyst

We need to output HTML fragment with sections: Overview (maybe not a heading? The overview is prose). The instructions: Use

for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). Do NOT repeat the job title as a heading. We need to include sections only when posting has real specific content. The posting includes Overview (intro), Hybrid schedule, Predictable hours, Competitive pay + generous PTO, Medical, dental & vision starting day one, 401(k), tuition reimbursement & longevity bonuses. That's benefits and schedule and pay. Also Responsibilities section. Qualifications section (Required qualifications, Preferred Qualifications). Salary Range. Also maybe "Overview" could be considered "About the role"? But they said use headings like About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We can map: Overview could be "About the role". We'll include that as

About the role

with paragraph(s). Then Responsibilities

Responsibilities

with

• items. Then Qualifications

  Qualifications

  with required and preferred maybe as
  . Could also separate Required and Preferred but not required. We'll include both as list items maybe with subheadings? But we shouldn't create extra headings not listed. Could embed "Required qualifications:" as bold text inside

  ? But we should preserve content. Use

  for prose. For list of qualifications we can use

  • . We'll need to capture all qualifications text. Also Benefits: we have "Medical, dental & vision starting day one", "401(k), tuition reimbursement & longevity bonuses". Also "Competitive pay + generous PTO". That's benefits and pay. Pay: we have salary range. Schedule: "Hybrid schedule: 2 days remote / 3 in‑office" and "Predictable hours (no nights, weekends, or holidays)". So we can have Benefits, Pay, Schedule sections. We must not include boilerplate like EEO, legal, etc. Remove "Applicants must be authorized to work in the U.S. without current or future sponsorship." That's maybe not boilerplate? It's a requirement but could be considered part of Qualifications? It's a work authorization requirement. Might be considered part of Qualifications? But it's not explicitly listed as qualification; it's a condition. Could be included in Qualifications as a list item? The instruction: preserve ALL substantive information; do not invent or summarize away detail. So we should keep that statement. Where to place? Could be under Qualifications as a list item: "Must be authorized to work in the U.S. without current or future sponsorship." Or we could put in a

    under Qualifications. Probably okay. Also "Interview Integrity Notice:" is boilerplate? It's about interview process; maybe considered boilerplate? It's not EEO but still maybe considered legal. The instruction: Remove cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, and application instructions. Interview Integrity Notice might be considered legal/boilerplate. Safer to remove it. Also "This role may be based out of any of our office locations, including: US-PA-Wilkes Barre | US-AZ-Scottsdale | US-TX-Plano | US-PA-Philadelphia". That's location info; could be considered part of Overview or maybe a separate section? Not listed as heading; we could include in Overview paragraph. We need to output only HTML fragment, no /, no markdown fences. Let's craft:

    About the role

    Overview Good things are happening at Berkshire Hathaway GUARD Insurance Companies—an A+ (Superior) rated, nationwide Property & Casualty insurer backed by Berkshire Hathaway. With supportive leadership, collaborative teams, and opportunities to grow, GUARD is a place where people build meaningful, long‑term careers. Good Things You Can Count On. Hybrid schedule: 2 days remote / 3 in‑office Predictable hours (no nights, weekends, or holidays) Competitive pay + generous PTO Medical, dental & vision starting day one 401(k), tuition reimbursement & longevity bonuses This role may be based out of any of our office locations, including: US-PA-Wilkes Barre | US-AZ-Scottsdale | US-TX-Plano | US-PA-Philadelphia

    But we have schedule, pay, benefits duplicated; we will later create separate sections for Schedule, Pay, Benefits. So we should not repeat that content in About the role; we should keep only overview narrative without those details. However the instruction: preserve ALL substantive information; we can't omit details. We need to include them somewhere. If we create separate sections for Schedule, Pay, Benefits, we should not duplicate them in About the role. So we need to split the overview paragraph: keep the narrative about company, supportive leadership, etc., and maybe location. Then move schedule, pay, benefits to their sections. Thus About the role paragraph: "Good things are happening at Berkshire Hathaway GUARD Insurance Companies—an A+ (Superior) rated, nationwide Property & Casualty insurer backed by Berkshire Hathaway. With supportive leadership, collaborative teams, and opportunities to grow, GUARD is a place where people build meaningful, long‑term careers. Good Things You Can Count On. This role may be based out of any of our office locations, including: US-PA-Wilkes Barre | US-AZ-Scottsdale | US-TX-Plano | US-PA-Philadelphia" Now Schedule section:

    Schedule

    with
    • Hybrid schedule: 2 days remote / 3 in‑office
    • Predictable hours (no nights, weekends, or holidays)
    Pay section:

    Pay

    with

    Salary Range $77,762.70-$180,082.10 + bonus

    (maybe also mention competitive pay? but we already have schedule and benefits; competitive pay is covered by salary range.) Benefits section:

    Benefits

    with
    • Medical, dental & vision starting day one
    • 401(k), tuition reimbursement & longevity bonuses
    • Generous PTO
    (Competitive pay already covered; generous PTO is benefit.) Responsibilities: we have a paragraph then "Essential Responsibilities And Principal Accountabilities" then a list of responsibilities. We'll output

    Responsibilities

    then maybe a

    for the introductory sentence then

    • for each bullet. We need to capture all responsibilities bullet points. Let's extract them: - Partner with Data Product Managers, business leaders, and cross-functional stakeholders to clarify complex business problems, define requirements, establish success measures, and drive alignment on data product adoption and business outcomes. - Lead the translation of insurance business needs into implementation-ready requirements, including business rules, data definitions, source-to-target mappings, metric logic, acceptance criteria, and data quality standards. - Utilize advanced SQL techniques to profile data, validate business logic, investigate data anomalies, reconcile results, assess data quality, and provide actionable insights across complex and integrated data environments. - Own and lead the Power BI development lifecycle for assigned domains, including requirements gathering, solution design, dashboard development, validation, deployment, user adoption, and continuous improvement initiatives. - Lead descriptive and diagnostic analytics efforts to identify trends, root causes, opportunities, and risks, delivering actionable insights that support operational and strategic decision-making. - Collaborate closely with data engineering teams to define data models, semantic layer requirements, reusable dimensions, governed metrics, and scalable data structures that support enterprise analytics capabilities. - Lead business validation activities and data product quality reviews with Data Product Managers, QA analysts, and business stakeholders to ensure solutions are accurate, reliable, usable, and aligned with business needs. - Establish and maintain comprehensive documentation, including business definitions, metric definitions, data dictionaries, reporting standards, usage guidance, and key decision records to support data governance and consistency. - Support the successful rollout and adoption of data products by communicating business value, facilitating stakeholder engagement, gathering user feedback, monitoring utilization, and identifying enhancement opportunities. - Serve as a subject matter resource for data analysis, reporting, and business intelligence best practices, providing guidance and knowledge sharing to analysts and business partners as appropriate. - Provide guidance, mentoring, and technical support to Data Analysts and other team members, fostering analytical capability and adherence to best practices. We'll put each as
    • . Qualifications: we have Required qualifications paragraph and Preferred Qualifications paragraph. We'll output

      Qualifications

      then maybe a

      for required qualifications intro then

      • for each required bullet, then another

        for preferred qualifications intro then

        • for each preferred bullet. Also include work authorization requirement as a list item maybe under required. Let's extract Required qualifications bullet points (they are sentences separated by periods). The text: "Required qualifications: 3+ years of experience in product management, data and analytics, business analysis, consulting, strategy, or a related field within the insurance industry. Demonstrated knowledge of underwriting, actuarial, rate/product, portfolio, or underwriting operations processes. Experience identifying business problems, shaping opportunities, and delivering insurance data solutions that support underwriting decisions, pricing analysis, portfolio insight, or operational execution. Strong business acumen and ability to connect data capabilities to underwriting, actuarial, product, pricing, portfolio, or operational outcomes. Experience leading cross-functional teams through ambiguity, aligning stakeholders, and influencing without direct authority. Experience facilitating workshops, interviews, discovery sessions, prioritization discussions, and product planning conversations. Ability to translate between business needs and data or technical concepts to support shared understanding and sound decisions. Ability to define product goals, success measures, roadmaps, adoption plans, and prioritization criteria. Proven ability to adapt, solve problems, and make progress in a changing environment. Excellent spoken and written communication." Also "Applicants must be authorized to work in the U.S. without current or future sponsorship." We'll add as a bullet. Preferred Qualifications bullet points: "Preferred Qualifications 5+ years in data analysis, business analysis, analytics, reporting, or a related data-focused role. Strong Property & Casualty insurance knowledge, including business concepts, metrics, and processes across underwriting, claims, actuarial, or operations. Advanced SQL skills, including data profiling, joins, aggregations, reconciliations, validation, issue investigation, and analysis across complex data sets. Hands-on Power BI (or comparable) experience, including requirements, dashboard design, prototyping, semantic modeling, development, testing, deployment, and user enablement. Experience translating business needs into requirements, metric definitions, quality expectations, BI solutions, and implementation-ready inputs for engineering teams. Experience partnering with engineers, governance teams, QA analysts, and business stakeholders on modeling, source-to-target mapping, validation, and reusable consumption layers. Familiarity with modern data concepts such as data products, data mesh, semantic models, metadata management, data quality, access controls, and governed consumption patterns. Strong analytical, problem-solving, facilitation, and communication skills across business and technical audiences. Ability to work through ambiguity, organize details, influence across teams, and support outcome-focused delivery. Bachelor’s degree in data science, Business Analytics, Statistics, Mathematics, Computer Science, Information Systems, Business, Insurance, or a related field preferred." We'll output each as
        • . Now ensure we don't include any heading with empty content. All sections have content. Now produce HTML fragment. Let's construct:

          About the role

          Good things are happening at Berkshire Hathaway GUARD Insurance Companies—an A+ (Superior) rated, nationwide Property & Casualty insurer backed by Berkshire Hathaway. With supportive leadership