Senior Analyst, Workforce Analytics
Stanford University School of Medicine · United States · 1 mo ago
RemoteRemoteBusiness DevelopmentFull-time
We need to output HTML fragment with sections for headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Only include sections if posting has real specific content. We must not repeat job title. No Job ID etc. Remove boilerplate. Must preserve all substantive info.
We need to parse the job description.
Key sections:
- About the role: likely the introductory paragraphs describing the role, mission, HRG, etc. Should be a paragraph.
- Responsibilities: list of duties. The posting includes "Duties Include" bullet list and also "Responsibilities Core Duties:" list. We need to combine? The instruction: Use
- for any list of duties/requirements/benefits. So we need to produce a list for responsibilities. Should we include all duties from both sections? The "Duties Include" list is extensive. The "Responsibilities Core Duties:" also list similar items. Might be duplication. We should preserve all substantive info, but avoid duplication? The instruction: "Preserve ALL substantive information; do NOT invent or summarize away detail." So we should include all duties, but if there are duplicates we might still include them? Might be considered duplication but still substantive. However we can combine to avoid redundancy but that would be summarizing away detail? Might be okay to deduplicate identical items. Safer to include all items as they appear, but we can note duplicates. However the instruction says "do NOT invent or summarize away detail." Deduplication could be considered summarizing away detail (removing duplicate lines). Might be okay if it's exactly same text; but safer to keep both? Might cause repetition but still not invented. I'd keep both lists but maybe combine under one responsibilities section with all items (including duplicates). Could be lengthy but okay.
- Requirements: likely "Minimum Education Bachelor’s degree. Minimum Experience Five years of relevant experience..." Also "Desired Qualifications" includes Master's degree preferred etc. So we can have Requirements section for minimum qualifications (education, experience). Qualifications section for desired qualifications? The instruction includes both Requirements and Qualifications as possible headings. We need to decide what goes where. Typically Requirements = minimum qualifications; Qualifications = preferred qualifications. We'll follow that.
- Skills: maybe list of skills like Tableau, SQL, Python/R, etc. Could be under Skills.
- Benefits, Pay, Schedule: only include if posting actually states them. The posting does not mention benefits, pay, schedule. So we should NOT include those sections.
- About Us: maybe not a standard heading; but we could put under About the role? The instruction says use headings for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). So we should map content to those headings. The "About Us" paragraph at end could be part of About the role or maybe separate but not in list; we could incorporate into About the role.
Thus output:
About the role
... (intro paragraphs)
Responsibilities
- ... each duty
Requirements
- Bachelor’s degree.
- Five years of relevant experience or combination of education and relevant experience.
- Experience in a quantitative discipline such as economics, finance, statistics, or engineering.
Qualifications
- Master’s degree in a technical discipline (Statistics, Economics, Finance, Operations Research, Engineering, Mathematics, Psychology, Computer Science, MBA, Information Systems, Biology, Physics, Analytics, Data Science or similar area) is preferred.
- Strong knowledge of workforce or HR data, metrics, and reporting practices preferred.
- Experience working with HR technology platforms (e.g., Oracle HCM, Workday, SuccessFactors); Oracle HCM experience preferred.
- Demonstrated expertise in Tableau, with substantial hands-on experience independently designing and developing complex, interactive dashboards, including advanced calculations, parameters, level-of-detail expressions, and row-level security.
- Proficiency with SQL for querying and analyzing data.
- Demonstrated experience transforming, integrating, validating, and analyzing large, complex datasets from multiple data sources for reporting and analytics.
- Experience automating and streamlining recurring data, reporting, and analytics processes to improve efficiency.
- Hands-on experience using Python, R, or similar analytical tools is a plus.
- Experience working with modern cloud-based data and analytics platforms such as Databricks is a plus.
- Familiarity with data governance or data catalog tools, such as Collibra, is a plus.
- Strong stakeholder consulting skills, with the ability to understand business needs, translate requirements into effective data and reporting solutions, and communicate technical concepts to varied audiences.
- Experience with or interest in applying generative AI and emerging AI technologies to workforce analytics and related processes.
Skills
Maybe we could list specific technical skills: Tableau, SQL, Python/R, etc. But many are already in Qualifications. Could still create Skills section with those. However we risk duplication. The instruction says prefer a few substantive sections over many thin ones. Might be better to not create Skills if content overlaps heavily with Qualifications. But we could still include Skills as a separate section listing: Tableau, SQL, Python/R, etc. However that would be summarizing details already present. Might be considered summarizing away detail? Not exactly; it's extracting. Might be okay but risk of thin section. I'd omit Skills section to keep fewer sections. Thus final HTML includes About the role, Responsibilities, Requirements, Qualifications. Now we need to extract the exact text for About the role: The introductory paragraphs before "Duties Include". Let's capture: "Stanford Medicine is fueling discovery and innovation to advance human health. Rooted in our mission to be a premier research-intensive medical institution, the Stanford University School of Medicine (SoM) improves health through leadership, diversity, collaborative discoveries, and innovation in education, patient care, and research. Whether working in departments with faculty or in units that support the school, our staff propel us toward the future of medicine and Precision Health. We are transforming health care from reactive diagnosis to proactive prediction and prevention and from one-size-fits-all medicine to personalized care that empowers people to lead healthy lives. Join the Human Resources Group (HRG), a department within the School of Medicine’s Dean’s Office, providing best-in-class people services and solutions that deliver value to our customers and cultivate leaders at all levels of the organization. Working closely with the School's academic departments, institutes, centers and administrative units, we lead in creating and maintaining a work environment that attracts, develops, rewards and retains a highly-engaged, talented, productive and diverse workforce in support of Stanford Medicine: Leading the Biomedical Revolution in Precision Health. We have an exciting new opportunity and invite applications for the position of Senior Analyst, Workforce Analytics — Data, Reporting & BI. We are seeking a dynamic, well-rounded analytics professional who can perform complex technical and analytical work to address workforce and business needs. Reporting to the Director of Workforce Analytics, your responsibilities will span workforce data, reporting, BI, and analytics to deliver trusted information and actionable insights that inform School of Medicine’s workforce strategies and decision-making. If you are passionate about transforming workforce data into trusted, scalable reporting and analytics solutions that inform talent strategies, support organizational transformation, and enable better decision-making, this opportunity is for you!" That seems good. Now Responsibilities: combine duties from "Duties Include" list and "Responsibilities Core Duties:" list. Let's extract each bullet. From "Duties Include": - Develop and maintain complex business intelligence solutions, including workforce reports, dashboards, scorecards, KPIs, metrics, and ad hoc analyses, with a focus on scalable reporting. - Query, clean, transform, and integrate data from multiple sources to deliver accurate, actionable information and support organizational decision-making. - Lead complex workforce reporting and business intelligence initiatives end-to-end, from requirements gathering and solution design through development, validation, implementation, and ongoing support. - Originate and coordinate data governance/stewardship assignments. - Develop and maintain documentation for data, reporting, analytics, and related processes. - Participate in user acceptance testing of new BI analysis and reporting systems, upgrades, enhancements and change requests; plan, conduct and document results of testing. - Define and drive areas of investigations to assess and produce relevant, standard, or custom information (reports, charts, graphs, and tables) from structured data sources by querying data repositories and generating the associated information, including summary interpretations of results. - Develop and design methods for identifying data patterns and trends in available information sources using a variety of qualitative and quantitative techniques. - Proactively suggest areas of investigation. - Design and create meaningful reports that effectively illustrate key findings within the data. - Identify and recommend strategic data collection and reporting requirements. - Effectively convey findings and recommendations to varied audience groups and senior leadership. - Provide subject matter expertise for ad-hoc projects and inquiries (e.g., requests for statistical analyses or surveys). - Lead and/or collaborate with technical staff, project teams or vendors to develop standardizing processes and systemize routine reports, dashboards, and metrics. - Validate data, analyses, and outputs for accuracy, identify anomalies, and investigate data quality issues. - Leverage generative AI and emerging technologies to enhance analytical work, automation, and productivity, and identify opportunities to improve reporting and self-service analytics. - Educate and train stakeholders on workforce analytics tools and promote data literacy, including effective use and interpretation of workforce data. - Other duties may also be assigned From "Responsibilities Core Duties:" list (some overlap): - Define and drive areas of investigations to assess and produce relevant, standard, or custom information (reports, charts, graphs, and tables) from structured data sources by querying data repositories and generating the associated information, including summary interpretations of results. - Develop and design methods for identifying data patterns and trends in available information sources using a variety of qualitative and quantitative techniques. - Proactively suggest areas of investigations. - Design and create meaningful reports that effectively illustrate key findings within the data. - Identify and recommend strategic data collection and reporting requirements. - Effectively convey findings and recommendations to varied audience groups and senior leadership. - Create non-routine databases and generate related information summaries. - Develop innovative algorithms and statistical models to help with finding key insights. - Perform advanced statistical analyses that are appropriate for complex datasets and reporting requirements. - Provide subject matter expertise for ad-hoc projects and inquiries (e.g., requests for statistical analyses or surveys). - Direct and drive the implementation of data standards and common data elements for data collection. - Lead and/or collaborate with technical staff, project teams or vendors to develop standardizing processes and systemize routine reports, dashboards, and metrics. - May lead testing of prototype software and participate in the approval and release process for new software. - May oversee or supervise staff in the development and implementation of programs or functions. We need to include all. Some duplicates: first few items duplicate. We'll keep both sets; duplication okay. Now Requirements: Minimum Education Bachelor’s degree. Minimum Experience Five years of relevant experience or combination of education and relevant experience. Experience in a quantitative discipline such as economics, finance, statistics, or engineering. Also maybe "Ability to manage multiple activities..." etc are under Knowledge, Skills And Abilities but those could be considered Skills. But we have no Skills section; we could put them under Requirements? Might be better to put them under Requirements as they are abilities. However the instruction says Requirements heading for e.g. Requirements. Could include those. But we already have Qualifications for preferred. The Knowledge, Skills And Abilities list includes many items that are more like skills/abilities. Might be better to put them under Skills section. But we decided to omit Skills to avoid thin sections. However we could include them under Requirements as they are indeed requirements (knowledge, skills, abilities). Let's include them under Requirements as bullet points. Thus Requirements bullets: - Bachelor’s degree. - Five years of relevant experience or combination of education and relevant experience. - Experience in a quantitative