Data Scientist
New York City Department of Consumer and Worker Protection · Manhattan, NY · 1 mo ago
EngineeringFull-time
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. We must not repeat job title as heading. Must not include Job ID etc. Must preserve all substantive info. Remove boilerplate: cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, application instructions. Also remove things like "Public Service Loan Forgiveness" maybe considered benefit? It's a benefit info. Could be included under Benefits. Also "Residency Requirement" maybe not a standard heading; could be under Requirements? Might be considered a requirement. But we only have set headings; we can put residency under Requirements or maybe under Qualifications? Probably under Requirements.
We need to extract content:
- About the role: description of DCWP and DoTSS reporting team role. Paragraph(s) describing mission, role. We'll create a .
- Requirements: maybe includes "Minimum Qualifications" and "Preferred Skills"? Actually Minimum Qualifications is under Qualifications. Preferred Skills under Skills. Requirements could be things like "Two years as a City Research Scientist Level I can be substituted..." but that's part of qualifications. We'll treat Minimum Qualifications as Qualifications. Preferred Skills as Skills. Requirements maybe include "Promoting innovative analytic approaches..." etc? Actually those are under "The optimal candidate will be able to demonstrate a track record of success in the following areas:" which are more like qualifications/skills. Could be under Requirements or Qualifications. We'll decide: Qualifications: Minimum Qualifications (education/experience). Skills: Preferred Skills list. Responsibilities: duties. Requirements: maybe the "optimal candidate will be able to demonstrate..." list (these are more like required abilities). We'll put that under Requirements.
- Benefits: includes "Public Service Loan Forgiveness" info, maybe also remote work eligibility (up to 2 days per week). Also maybe "Flexible Work Pilot Program". Also maybe nothing else. We'll include Benefits section with those points.
- Pay: not specified; we should not include Pay section if not stated. The posting does not mention salary. So omit.
- Schedule: remote work eligibility up to 2 days per week is schedule info. Could be under Schedule. But we already used remote work in Benefits. Could also put under Schedule. The instruction: include a section ONLY when posting has real specific content. So we can have Schedule section with remote work info. Benefits could include loan forgiveness. We'll decide: Schedule: remote work eligibility. Benefits: Public Service Loan Forgiveness.
We must not invent or summarize away detail. Keep all substantive info.
Let's extract text.
About the role: Combine paragraphs:
"The NYC Department of Consumer and Worker Protection (DCWP) protects and enhances the daily economic lives of New Yorkers to create thriving communities. DCWP licenses nearly 45,000 businesses in more than 40 industries and enforces key consumer protection and workplace laws that apply to countless more. By supporting businesses through equitable enforcement and access to resources, DCWP protects the marketplace from predatory practices and strives to create a culture of compliance. DCWP empowers consumers and working families by providing the tools and resources they need to achieve financial health and work-life balance. DCWP also conducts research and advocates for public policy that furthers its work to support New York City’s communities. For more information about DCWP and its work, call 311 or visit DCWP at NYC Department of Consumer and Worker Protection (DCWP), sign up for its newsletter, or follow on its social media sites, X, Facebook, Instagram, and YouTube. The Division of Technology and Strategic Solutions (DoTSS) reporting team plays a critical role in providing timely and accurate operations data to stakeholders in order to comply with public reporting needs, increase the agency’s transparency generally and, provide direct informational support to our decision makers as they shape DCWP’s policies, practices, and procedures. In addition to operational reporting, the unit coordinates collaboration on quality improvement initiatives, designs and implements performance management systems and tools, and recommends new analyses and analytic projects to improve agency outcomes."
We should remove duplicated lines like "visit DCWP at NYC Department of Consumer and Worker Protection (DCWP)" maybe keep but it's okay. Also remove application instructions etc. There's none.
Responsibilities: list from "As a Data Scientist you will:" then each sentence:
- Report to the Manager of Data Analytics and assist with developing and implementing analytic, policy, and planning strategies to achieve agency-wide goals.
- Conduct routine data and statistical analysis designed to enhance understanding of agency operations and to support consumer and worker protection and financial empowerment objectives.
- Apply research and analytic best practices to evaluate program success and division performance.
- Utilize internal and web-based GIS tools and other geo-spatial data to evaluate the impact and efficacy of DCWP’s outreach and enforcement activities across a broad array of geographic and demographic sectors.
- Provide research support for special initiatives and projects.
- Coordinate with External Affairs and Communications divisions in the provision of agency data to the press, elected officials, and other interested parties.
- Consult on data sharing projects between DCWP and other governmental and non-governmental entities.
- Utilize self-authored SQL to support the agency’s reporting team on an as-needed basis, analyzing and summarizing large datasets extracted directly from DCWP’s reporting databases.
- Collaborate on the design, development, and implementation of public-facing web-based tools designed to enhance agency transparency.
We'll put each as .
Requirements: list from "The optimal candidate will be able to demonstrate a track record of success in the following areas:" then bullet-like sentences:
- Promoting innovative analytic approaches that provide greater insight into organizational operations and outcomes;
- Excellent quantitative and problem-solving skills.
- Demonstrated commitment to data-driven decision making;
- Superior written and oral communication skills and demonstrated ability to communicate effectively in public forums and to executive audiences;
- Ability to manage multiple ad-hoc intake requests and long-term projects simultaneously;
- Ability to improve data quality by identifying and resolving data quality issues.
We'll put as .
Qualifications: Minimum Qualifications section:
"Minimum Qualifications For Assignment Level I (only physical, biological and environmental sciences and public health) A master's degree from an accredited college or university with a specialization in an appropriate field of physical, biological or environmental science or in public health. To be appointed to Assignment Level II and above, candidates must have: A doctorate degree from an accredited college or university with specialization in an appropriate field of physical, biological, environmental or social science and one year of full-time experience in a responsible supervisory, administrative or research capacity in the appropriate field of specialization; or A master's degree from an accredited college or university with specialization in an appropriate field of physical, biological, environmental or social science and three years of responsible full-time research experience in the appropriate field of specialization; or Education and/or experience which is equivalent to "1" or "2" above. However, all candidates must have at least a master's degree in an appropriate field of specialization and at least two years of experience described in "2" above. Two years as a City Research Scientist Level I can be substituted for the experience required in "1" and "2" above. NOTE: Probationary Period Appointments to this position are subject to a minimum probationary period of one year."
We'll put as
About the role
thenwith combined description. - Responsibilities: list of duties bullet points from "As a Data Scientist you will:" and subsequent bullet-like sentences. We'll convert each line to
maybe with
- for the options? The instruction: Use
- for any list of duties/requirements/benefits. This is a list of options; we could format as
- . But it's a bit complex. We'll keep as
- each.
Benefits: Public Service Loan Forgiveness info:
"As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at https://studentaid.gov/pslf/."
We'll put as
. Schedule: remote work eligibility: "This position may be eligible for remote work for up to 2 days per week, pursuant to the Flexible Work Pilot Program." We'll put as
. We must not include boilerplate like EEO etc. At end there is a paragraph about equal opportunity employer etc. That's boilerplate; we must remove. Also remove "Residency Requirement" paragraph? That's not a standard heading; could be considered a requirement but not in our list. Might be considered a requirement but we don't have a heading for residency; we could include under Requirements as a bullet? But we already have Requirements list; we could add a bullet about residency. However the instruction: Use
- for any list of duties/requirements/benefits. So we could add residency as a requirement bullet. But we must preserve ALL substantive information. So we need to include residency requirement info somewhere. Could be under Requirements as an extra bullet. Let's add.
Residency requirement text: "New York City residency is generally required within 90 days of appointment. However, City Employees in certain titles who have worked for the City for 2 continuous years may also be eligible to reside in Nassau, Suffolk, Putnam, Westchester, Rockland, or Orange County. To determine if the residency requirement applies to you, please discuss with the agency representative at the time of interview."
We'll add as a bullet under Requirements.
Also "Additional Information" heading about EEO we must remove.
Now compile HTML.
Structure:
About the role
...combined paragraph...
Responsibilities
- ... ...
Requirements
- Promoting innovative analytic approaches that provide greater insight into organizational operations and outcomes;
- Excellent quantitative and problem-solving skills.
- Demonstrated commitment to data-driven decision making;
- Superior written and oral communication skills and demonstrated ability to communicate effectively in public forums and to executive audiences;
- Ability to manage multiple ad-hoc intake requests and long-term projects simultaneously;
- Ability to improve data quality by identifying and resolving data quality issues;
- New York City residency is generally required within 90 days of appointment. However, City Employees in certain titles who have worked for the City for 2 continuous years may also be eligible to reside in Nassau, Suffolk, Putnam, Westchester, Rockland, or Orange County. To determine if the residency requirement applies to you, please discuss with the agency representative at the time of interview.
Qualifications
Minimum Qualifications For Assignment Level I (only physical, biological and environmental sciences and public health) A master's degree from an accredited college or university with a specialization in an appropriate field of physical, biological or environmental science or in public health. To be appointed to Assignment Level II and above, candidates must have: A doctorate degree from an accredited college or university with specialization in an appropriate field of physical, biological, environmental or social science and one year of full-time experience in a responsible supervisory, administrative or research capacity in the appropriate field of specialization; or A master's degree from an accredited college or university with
- for any list of duties/requirements/benefits. So we could add residency as a requirement bullet. But we must preserve ALL substantive information. So we need to include residency requirement info somewhere. Could be under Requirements as an extra bullet. Let's add.
Residency requirement text: "New York City residency is generally required within 90 days of appointment. However, City Employees in certain titles who have worked for the City for 2 continuous years may also be eligible to reside in Nassau, Suffolk, Putnam, Westchester, Rockland, or Orange County. To determine if the residency requirement applies to you, please discuss with the agency representative at the time of interview."
We'll add as a bullet under Requirements.
Also "Additional Information" heading about EEO we must remove.
Now compile HTML.
Structure:
preserving the text. Might be okay. Skills: Preferred Skills list: "Proficiency with a wide variety of analytic and business intelligence tools, such as IBM Cognos, Tableau, Power BI, advanced Excel (e.g. VBA Macros), and others - Proficiency with statistical software packages (R, SAS, SPSS, STATA) - Writing SQL queries, Stored Procedures, and Optimizations in Microsoft SQL Server - Strong organizational and project management skills detail oriented with the ability to multi-task and work both independently and as part of a team - Familiarity with Object Oriented Programming (OOPS) a plus - Intermediate knowledge of GIS tools including Esri GIS products, CartoDB, and Leaflet (JavaScript) a plus" We'll split by " - " maybe each bullet. We'll produce
- each.
Benefits: Public Service Loan Forgiveness info:
"As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at https://studentaid.gov/pslf/."
We'll put as