Data Scientist

About the role

DCWP is seeking a highly skilled Data Scientist with a strong background in assessing data quality, a track record of applying appropriate analytical techniques to solve complex organizational and operational challenges, and an entrepreneurial spirit with the ability to think outside the box to design and implement novel solutions. Working in close contact with the Manager of Data Analytics and Reporting and other DoTSS Reporting Team members, the selected candidate will be responsible for spearheading analytic, innovation, and reporting efforts across the agency to ensure efficiency, accountability, and transparency in DCWP's many community-based and community outreach programs.

Responsibilities

• 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.

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: 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 the 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 as described. Two years as a City Research Scientist Level I can be substituted for the experience required.

Preferred skills

• 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