The Law, Safety, & Justice (LSJ) department is seeking a Senior Planning Analyst to conduct data analysis, develop a variety of reports, and support the development of the Hennepin County Public Safety Data Lake. This position will analyze data from large databases, perform ad-hoc analyses and present results to key stakeholders to address complex organizational problems. This Senior Planning Analyst will use report development and data products including but not limited to R, Databricks, and Power BI.Current Hennepin County employees who refer a candidate hired into an open competitive position may be eligible for a $500 referral bonus. For more information visit the employee referral program page. Location and hours:
This position is remote. Remote workers may be required to come on-site 0 to 12 days a year for work meetings, trainings, or for any other reasons that their supervisor may deem necessary (may include additional days for onboarding and new employee training). Supervisors will provide as much advance notice as practicable. Work hours will be Monday through Friday, 8 a.m. - 4:30 p.m. with flexibility. Based on business needs of this position, hires must live in or relocate to Minnesota.
New employees who are hired into remote or hybrid positions between January 2, 2022, to December 31, 2024, will receive $500 toward the cost of establishing consistent internet connectivity, payable upon completion of 6 months of employment.About the position type:This is a full-time, benefit earning position. This position is internally classified as a Planning Analyst, Senior.Clickhere to view the job classification specification. In this position, you will:
· Create and support interdepartmental reports using multiple data sources (SQL, Databricks, etc.).
· Work with requestors and subject matter experts to outline report requirements, determine methodology, and design the report.
· Consult on data collection methods and address feasibility.
· Conduct statistical analysis, present reports, and provide written summaries.
· Complete ad hoc data requests.
· Support the Public Safety Data Lake by working with data engineers to troubleshoot issues related to data feeds and creating new data feeds.
· Create refined and trusted data tables for use by LSJ Analytics and partners.
· Serve as a subject matter expert on the Data Lake structure and tool.
Need to have:One of the following:
· Master's degree or higher in business administration, public administration, research methods, statistics, behavioral/social science, public health, computer science/MIS, management science, urban/city planning or a field appropriate to the area of specialization.
· Bachelor's degree in one of the fields listed above and one year or more of relevant planning analyst experience.
· Bachelor's degree in any field and a minimum of two courses in research methods, analysis, statistics, project management, planning or evaluation and 18 months or more of relevant planning analyst experience.
Nice to have:
o Using statistics and quantitative research methods to solve real-world problems.
o Using programming languages for data science and/or applied research (R, Python).
o With using reporting tools (e.g., Power BI, Tableau).
o Operating SQL and/or Python to query from large and complex databases.
o Working with data lake architectures and/or other cloud-based data structures.
o Working in the criminal and/or juvenile justice system.
· Knowledge of the county government processes and data.
· Ability to:
o Present and communicate complex analyses to a variety of stakeholders.
o Build and nurture collaborative relationships with a variety of customers/partners, both internal and external.
o Successfully manage multiple priorities and projects, and work independently.
· Skills in using Microsoft Office products, including Word, Excel, PowerPoint, and SharePoint.