Director of Food Safety Data Analytics, Bureau of Environmental Surveillance and Policy

We need to output HTML fragment with headings

for sections: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Only include sections that have real specific content. No job title heading. No Job ID etc. Remove boilerplate, navigation, EEO, etc. Keep substantive info. We need to parse the posting. Key sections: - About the role: description of role, mission, context. Could be first paragraph(s). We'll create an

About the role

with

containing description. - Responsibilities: list of duties. The posting has "DUTIES WILL INCLUDE BUT NOT BE LIMITED TO:" then bullet list. We'll extract those as

• . - Requirements: maybe "The candidate must have extensive experience in leading data analytics, as well as excellent managerial and cross-functional collaboration skills." Also "Experience with implementing data-driven informatics solutions..." etc. Could be under Requirements. - Qualifications: maybe "Minimum of 3 years’ experience leading data analytic project management..." etc. Could be Qualifications. - Skills: maybe list of preferred skills: advanced proficiency in SQL, SSRS, Power BI, etc. Could be Skills. - Benefits: The "Why you should work for us:" includes Loan Forgiveness, Benefits details, Work From Home Policy, Job Security, etc. So Benefits section. - Pay: Not mentioned. No salary. So we should NOT include Pay section. - Schedule: Not mentioned explicitly (full-time). It says "We are recruiting a full-time research scientist". That's schedule info: full-time. Could be Schedule section? The rule: include Schedule only if posting actually states them. It states full-time. So we can include Schedule with that info. However we need to avoid filler like "not specified". Full-time is specific. So we can include Schedule. But we need to decide if we want separate Qualifications and Requirements sections. Might be overlapping. The instruction: Prefer a few substantive sections over many thin ones. Could combine Requirements and Qualifications into one? But they ask to use headings for those specific names if content exists. We can decide to have Requirements (must have) and Qualifications (preferred). Or combine. Let's extract: About the role: first paragraph(s) describing BESP, BFSCS, mission, team, etc. Responsibilities: the bullet list under DUTIES WILL INCLUDE BUT NOT LIMITED TO: (the long list). Also maybe some earlier sentences about primary function etc. But we can include those as responsibilities. Requirements: "The candidate must have extensive experience in leading data analytics, as well as excellent managerial and cross-functional collaboration skills." Also "Experience with implementing data-driven informatics solutions to operational problems and/or experience with designing and implementing operational process efficiency changes is also desired." Also "They will operate with a wide degree of independence and autonomy." Might be more like requirements. Qualifications: The "PREFERRED SKILLS:" list includes many items; but those are skills. Actually "PREFERRED SKILLS:" is a list of skills. So we could treat that as Skills section. Then Qualifications could be the minimum experience etc. But the "Minimum of 3 years’ experience leading data analytic project management..." is under PREFERRED SKILLS? Actually it's first bullet under PREFERRED SKILLS. So maybe we treat all under Skills. But we need to follow the headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We can assign: - About the role: description. - Responsibilities: duties list. - Requirements: mandatory experience: "extensive experience in leading data analytics, excellent managerial and cross-functional collaboration skills", "Experience with implementing data-driven informatics solutions to operational problems and/or experience with designing and implementing operational process efficiency changes is also desired", "operate with a wide degree of independence and autonomy". Also maybe "full-time research scientist" but that's schedule. - Qualifications: maybe "Minimum of 3 years’ experience leading data analytic project management through all phases", "Strong background in management of surveillance and informatics projects and staff", etc. But those are also skills. However we can treat them as Qualifications. - Skills: technical skills: SQL, SSRS, Power BI, etc., plus MS Access/Excel, etc. - Benefits: loan forgiveness, health insurance, pension, etc., work from home, job security. - Schedule: full-time. We must not include Pay. Now we need to ensure we don't include boilerplate like EEO, commitment to equity, etc. Remove those paragraphs. Also remove navigation, cookie, legal, etc. Not present. We need to preserve all substantive information; not invent or summarize away detail. So we need to keep specifics like numbers: over 40,000 food service establishments, team of four analysts, one informatics product manager, etc. Also mention specific tools: SQL, SSRS Report Designer, Power BI, etc. Also mention specific benefits: premium-free health insurance saving over $10K annually per 2024 assessment, defined benefit pension, tax-deferred savings program, Worksite Wellness Program, loan forgiveness, work up to two days from home. We need to keep the bullet list of duties exactly as given, but we can rephrase? Must preserve all substantive information; we can keep the same meaning but not necessarily exact wording? Safer to keep close. Let's extract duties list: - Collaborate directly with the Assistant Commissioner and Executive Directors of BFSCS to: - Understand operational procedures and identify opportunities for optimization or automation. - Design, develop and maintain automated data solutions, reporting pipelines, and data-driven tools to improve operational efficiency and reduce manual processes. - Collaborate with supervisors of inspectional staff to ensure user acceptance of data-driven tools; use an iterative process to improve or enhance tools as needed. - Manage and improve BFSCS’s key performance indicators, including regular refinement to ensure the indicators align with leadership goals and priorities. - Lead the BESP Food Safety Data Analytics Team by engaging in the following duties and responsibilities: - Manage staff of up to 4 data analysts and an informatics product manager, providing scientific and project direction and oversight. - Lead analysis and reporting work to answer questions related to inspection results and trends using SQL, SSRS Report Designer, Power BI, and other software. - Serve as liaison to inspection program executive leadership to formulate creative approaches for using data to improve inspection program efficiency and effectiveness. - Ensure data analytic products and reports are accurate and adhere to data documentation standards. - Liaise directly with Division of IT developers to oversee technical design and enhancements to the food safety inspection SQL database systems, including design of the backend data infrastructure and/or data migration pathways. - Design, optimize, and maintain SQL Server databases, reporting tables, views, and ETL workflows to support analytics and operational reporting. - Provide direction and support in the planning of analyses, reports, presentations and other modes for disseminating information on mobile food vending, restaurant and other food service establishment safety. - Present analytic results and research findings to Agency leadership and at conferences. - Report back on projects and progress to Executive Director of Environmental Health Surveillance. - Assist with emergency response and preparedness work. - Assist and support development and implementation of new inspection system for bureau, in coordination with EHS, DIT, OTI and outside consultants. We need to keep that as
  • maybe nested? The original had top-level bullets with sub-bullets. We can flatten or keep nested lists. Use
    • for any list. Could have nested
      inside
      • . That's fine. Now Requirements: we need to capture mandatory items. From text: - "The candidate must have extensive experience in leading data analytics, as well as excellent managerial and cross-functional collaboration skills." - "Experience with implementing data-driven informatics solutions to operational problems and/or experience with designing and implementing operational process efficiency changes is also desired." - "They will operate with a wide degree of independence and autonomy." Also maybe "We are recruiting a full-time research scientist to fill this role." That's schedule. Also "Reporting to the Executive Director of Environmental Surveillance in BESP, the candidate will assume oversight responsibility for responding to immediate and long-term needs of BFSCS programs, including developing operational tools to increase program efficiency, and directing surveillance and research projects as needed." That's more responsibilities. But we already have responsibilities. Now Qualifications: maybe the "PREFERRED SKILLS:" list items that are about experience and background: Minimum of 3 years’ experience leading data analytic project management through all phases, Strong background in management of surveillance and informatics projects and staff, Advanced proficiency in SQL programming, Advanced experience developing and delivering interactive dashboards, reports, and other data visualization products using SSRS Report Designer (advanced) or Power BI, Experience collaborating with software developers to define technical requirements, prioritize enhancements or bug fixes, and troubleshoot application issues, Background or interest in environmental health and/or the principles of food safety, Experience presenting program initiatives and related research findings to executive leaders or at conferences, Experience with MS Access and Excel., Excellent managerial, interpersonal, and communication (written and verbal) skills., Attention to detail and strong organizational skill. But many of those are skills. However we can split: Qualifications could be the experience and background items (minimum years, background in management, background or interest in environmental health, experience presenting, etc.) Skills could be technical proficiencies (SQL, SSRS, Power BI, MS Access/Excel, etc.) and soft skills (managerial, communication, attention to detail). But the instruction says prefer few substantive sections over many thin ones. Could combine Qualifications and Skills into one? But they ask to use those headings if content exists. We could have both. Let's decide: - Qualifications: Minimum of 3 years’ experience leading data analytic project management through all phases; Strong background in management of surveillance and informatics projects and staff; Background or interest in environmental health and/or the principles of food safety; Experience presenting program initiatives and related research findings to executive leaders or at conferences. - Skills: Advanced proficiency in SQL programming for querying, analyzing, and transforming complex datasets; Advanced experience developing and delivering interactive dashboards, reports, and other data visualization products using SSRS Report Designer (advanced) or Power BI; Experience collaborating with software developers to define technical requirements, prioritize enhancements or bug fixes, and troubleshoot application issues; Experience with MS Access and Excel.; Excellent managerial, interpersonal, and communication (written and verbal) skills.; Attention to detail and strong organizational skill. But note that "Excellent managerial, interpersonal, and communication (written and verbal) skills." also appears in Requirements (excellent managerial and cross-functional collaboration skills). There's overlap. We'll keep it in Skills. Now Benefits: from "Why you should work for us:" includes Loan Forgiveness, Benefits (health insurance, pension, tax-deferred savings, Worksite Wellness), Work From Home Policy, Job Security, plus description of NYC Health Department mission etc. The mission description maybe not a benefit but could be About the role? Actually it's more about the organization. Could be part of About the role? But we already have About the role covering mission of BESP and BFSCS. The later paragraph about NYC Health Department history and mission is more general; could be considered About the role as well but maybe we can include it in About the role to avoid thin sections. However we already have About the role with some content; we can add more. But we must not repeat job title. It's fine. Now Schedule: full-time. Now we need to output HTML fragment only. Let's craft:

        About the role

        ...

        Responsibilities

        ...

        Requirements

        ...

        Qualifications

        ...

        Skills

        ...

        Benefits

        ...

        Schedule

        Full-time position.

        Make sure not to include empty sections. Now we need to write the content. About the role paragraph: combine first few sentences: "The