Data Analyst

We need to output HTML fragment with sections: About the role? Actually we have "Position Description" then "About Harris County Public Health:" then "Our Values:" then "Position Overview:" then "Duties And Responsibilities" then "Requirements" then "Preferences" then "General Information" etc. We need to use

for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). We should map headings accordingly. We should not repeat job title. We need to include sections only when posting has real specific content. We need to preserve all substantive info, remove boilerplate (EEO, accommodations, criminal history check, etc). Also remove duplicated lines. Also remove application instructions. Also remove navigation/legal/EEO etc. Also remove "NOTE: Qualifying education..." repeated. We need to decide which sections to include: About Harris County Public Health (maybe "About the role"? Actually "About Harris County Public Health" is about organization, not role. Could be "About the role"? The instruction says use headings like About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. So we should use those headings if content matches. We have "Position Overview" which could be "About the role". We have "Duties And Responsibilities" -> Responsibilities. We have "Requirements" -> Requirements. We have "Knowledge, Skills & Abilities" -> Skills. We have "Core Competencies" maybe also Skills? Could combine. We have "Preferences" maybe could be "Qualifications"? Actually Qualifications is similar to Requirements. But we have both Requirements and Preferences. Could treat Preferences as additional qualifications but maybe we can include under Requirements or Qualifications. The instruction: Prefer a few substantive sections over many thin ones. So we could combine Requirements and Preferences into a single Requirements section? But we need to preserve all info. Could have Requirements (including education, experience) and then Preferences as a separate subsection? But we cannot create extra headings not in list unless they are substantive? The instruction says use

for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). It doesn't forbid other headings, but says use those for section headings. Probably we should stick to those headings. So we need to map content to those headings. We have: - About the role: could be Position Overview + maybe About Harris County Public Health? But "About the role" likely refers to role description. We'll put Position Overview there. - Responsibilities: Duties And Responsibilities. - Requirements: Education, Experience, Knowledge, Skills & Abilities (maybe also Core Competencies? but those are skills). Could also include Preferences as "Preferred qualifications" but we could put under Requirements as "Preferred" bullet. - Skills: maybe separate from Requirements? But we already have Knowledge, Skills & Abilities. Could treat that as Skills section. However we also have Core Competencies which are skills. Could combine. - Benefits, Pay, Schedule: we have General Information includes Position Type, Typical Hours of Work, Work Environment, Physical Demands, Work Location. No explicit benefits, pay, schedule. Schedule is mentioned: Typical work hours Monday-Friday 8am-5pm, may require periodic overnight travel, long hours/overtime during emergencies, occasional after-hours support. That's schedule info. So we can create a Schedule section with that info. Benefits: not mentioned. Pay: not mentioned. So we omit Benefits and Pay. - Qualifications: maybe we could treat Requirements as Qualifications. But we already have Requirements heading. Could also have Qualifications separate but we might combine. Given instruction to prefer few substantive sections, we could have: About the role, Responsibilities, Requirements (including education, experience, knowledge, skills, abilities, core competencies, preferences), Schedule. That's four sections. We need to use

• for any list of duties/requirements/benefits. So for duties and responsibilities we need a list. For requirements we need a list. For schedule maybe not a list but could be prose. We must preserve all substantive information. Let's extract. About Harris County Public Health: description of HCPH, network, services, values. This is about organization, not role. Should we include? It's substantive but not role-specific. The instruction says include a section ONLY when posting has real, specific content for it. It doesn't say we must include organization info. Could be part of About the role? Might be okay to include under About the role as background. But "About the role" heading expects role description. However we could still include organization info under About the role as part of role context. Might be okay. But we also have "Our Values:" list of values. That's also organization. Could include under About the role. We need to avoid boilerplate like EEO, accommodations, criminal history check, note about qualifying education repeated, etc. Let's parse the text: Position Description (intro) - we can ignore as it's generic. About Harris County Public Health: paragraph. Our Values: list of values with descriptions. Position Overview: paragraph. Duties And Responsibilities: list of items (Data Lifecycle Management, Data Management and Analysis, Product Development, Department Support, Stakeholder Engagement, Research and Communication, Presentation Development). Each with description. Requirements: Education Bachelor’s Degree. Experience Two (2) years of experience working on data projects including data collection, management, query, cleaning, analysis, and visualization. One (1) year of experience using the following data tools: Excel, SQL, R, Python, and PowerBI or similar tools. Knowledge, Skills & Abilities: list of items (Knowledge of Excel, SQL, R, Python, and PowerBI or similar tools for data analysis. Excellent written and verbal communication skills. Proficiency in navigating and resolving complex issues. Proactive self-starter capable of initiating tasks independently. Proficiency in collecting, maintaining, analyzing, and presenting data effectively. Proficiency in commonly used office computer programs, notably Microsoft Office applications. Ability to coordinate workflow effectively to ensure efficient service delivery.) Core Competencies: list of competencies with descriptions. Preferences: Experience Knowledge of or experience with community violence intervention (CVI), alternative 911 response, violence prevention, or related community-based public safety and public health initiatives preferred. General Information: Position Type, and Typical Hours of Work Full-Time Position Typical work hours are Monday through Friday 8:00 am to 5:00 pm. May require periodic overnight travel and long hours/overtime during emergencies/disasters. May require occasional after-hours support and maintenance of technical systems. Work Environment Work environment is typically in an office environment but may require infrequent travel and interaction with the community at public events. Physical Demands This is a largely sedentary role; however, some duties would require the ability to lift up to 20 pounds and bending & standing for periods at a time. Work Location Harris County Public Health - 1111 Fannin St. Houston, Texas. 77002. Also repeated NOTE about qualifying education etc - we remove. Now we need to produce HTML. We'll produce:

  About the role

  ... combine Position Overview and maybe About Harris County Public Health and Our Values? Might be too much but okay. Better: About the role: Position Overview paragraph. Then maybe a separate section for "About Harris County Public Health" but not in allowed headings. Could we add a custom heading? The instruction says use

  for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). It doesn't forbid other headings but suggests using those. Safer to stick to those. Thus we put organization info maybe under About the role as context. Let's craft About the role paragraph: "Harris County Public Health (HCPH) includes a network of more than 1,100 public health professionals working together to improve health outcomes for the third most populous county in the United States. HCPH provides a multitude of services such as medical and dental services, community programming, and health education for the approximately 2.3 million people in unincorporated Harris County. Through its core values of innovation, engagement, and health equity, HCPH strives to bring meaningful solutions to public health issues while keeping Harris County healthy and vibrant. Under the supervision of the Office of Planning and Innovation (OPI) Applied Analytics Manager, the HART & RISE Data Analyst will oversee the full spectrum of data collection, management, and analytics, from gathering to reporting, while utilizing various tools for effective data collection, management, analysis, and visualization. This position works with internal and external stakeholders using data to create deliverables that enable the Community Health and Violence Prevention (CHVPS) division programs, HART and RISE, to take a public health approach to addressing the root causes of violence." That combines org description and position overview. Now Responsibilities: list each duty. We need to preserve the description under each duty. So each

  can contain the duty title and description. We'll produce

  • Data Lifecycle Management: Manages the entire data analytics process, from gathering requirements to reporting findings, ensuring accuracy and efficiency throughout.
  etc. Now Requirements: we need to include education, experience, knowledge, skills & abilities, core competencies, preferences. We can make a list. Education: Bachelor’s Degree. Experience: Two (2) years of experience working on data projects including data collection, management, query, cleaning, analysis, and visualization. One (1) year of experience using the following data tools: Excel, SQL, R, Python, and PowerBI or similar tools. Knowledge, Skills & Abilities: list each. Core Competencies: list each. Preferences: Experience Knowledge of or experience with community violence intervention (CVI), alternative 911 response, violence prevention, or related community-based public safety and public health initiatives preferred. We could combine into a single list but maybe better to group with headings inside? But we cannot add extra headings besides h3. Could we use

  for prose and

  • for list items. For requirements we can have a
    with each bullet containing the statement. That's fine. Now Schedule: we need to include typical hours, overtime, after-hours, travel. We'll produce a

    with that info. We must not include Benefits or Pay sections. Now ensure we removed boilerplate: EEO link, accommodations, criminal history check, note about qualifying education repeated, etc. Also remove duplicated lines: there is a duplicate NOTE about qualifying education appears twice; we remove. Now produce HTML. Check for any leftover boilerplate: The line "Harris County is an Equal Opportunity Employer https://hrrm.harriscountytx.gov/Pages/EqualEmploymentOpportunityPlan.aspx" remove. Also "If you need special services or accommodations, please call (713) 274-5445 or email ADACoordinator@bmd.hctx.net" remove. Also "This position is subject to a criminal history check. Only relevant convictions will be considered and, even when considered, may not automatically disqualify the candidate." remove. Also remove "NOTE: Qualifying education, experience, knowledge, and skills must be documented on your job application. You may attach a resume to the application as supporting documentation but ONLY information stated on the application will be used for consideration. "See Resume" will not be accepted for qualifications ." remove both occurrences. Also remove "General Information Position Type, and Typical Hours of Work Full-Time Position Typical work hours are Monday through Friday 8:00 am to 5:00 pm. May require periodic overnight travel and long hours/overtime during emergencies/disasters. May require occasional after-hours support and maintenance of technical systems. Work Environment Work environment is typically in an office environment but may require infrequent travel and interaction with the community at public events. Physical Demands This is a largely sedentary role; however, some duties would require the ability to lift up to 20 pounds and bending & standing for periods at a time. Work Location Harris County Public Health - 111