You are viewing a preview of this job. Log in or register to view more details about this job.
Email

Position Summary: 
CountyStat Analysts collaborate with county departments to solve problems and improve government services. Allegheny County manages a wide range of programs and services for residents, including public safety, health, recreation, and economic development. The mission of the CountyStat team is to help Allegheny County management make data-informed decisions that will improve operations, provide quality services, lower costs, and increase revenues.

CountyStat Analysts have the opportunity to work on projects that fit within their interests but will also be expected to master subject areas that may be totally new to them. Intellectual curiosity, a collaborative nature, and the desire to improve public services are all essential qualities of a successful analyst. Analysts are assigned a portfolio of county departments and will be expected to work closely with departments to serve their data needs. Day-to-day work will include maintaining operational dashboards to enable department staff to understand trends and emerging challenges in their work. Analysts will also monitor Key Performance Indicators for assigned departments and identify opportunities for improvement.

Working closely with experienced analysts, CountyStat Analysts should expect to spend most of their time working with data, including preparing and cleaning data, performing analysis, and creating charts, maps, and dashboards to visualize the results.

The CountyStat team maintains a data warehouse, so familiarity with common Structured Query Language (SQL) platforms is essential. Experience with Tableau or similar business intelligence software is also desired. Competency with R, Python, or ArcGIS is also a plus.  
 

Overview: 
Duties: 

  • Work closely with other CountyStat Analysts, Data Engineer and operating department staff to understand data-related needs and challenges.
  • Develop data cleaning and preparation techniques to ensure an accurate, reliable data for use in analyses.
  • Analyze data using Tableau, R, SQL, Python, or other tools.
  • Develop data visualizations using Tableau, R, ArcGIS, or other software.
  • Work with department subject matter experts to define and categorize their data in the county data catalog.
  • Continually revise dashboards and other visualizations per user feedback.
  • Monitor KPIs for assigned departments.
  • Assist in preparing and maintaining datasets for the Western PA Regional Data Center, the county’s open data portal.
  • Performs other tasks and duties as requested or required.


Knowledge, Skills, and Abilities 

Knowledge of: 

  • Statistical analysis techniques and methodologies.
  • Process improvement techniques.
  • Performance metrics, preferably for government agencies.

Skill in: 

  • Data cleaning and manipulation techniques using R, SQL, Python, and Microsoft Excel.
  • Data visualization and analysis tools, including Tableau, R, ArcGIS, or Python.
  • Configuration and utilization of common data sources (i.e., MS SQL Server, Oracle, application programming interfaces (APIs), and Excel).

Ability to: 

  • Research best practices for the delivery of County services and local implementation issues.
  • Analyze service delivery inputs, outputs, efficiency and effectiveness and perform root cause analysis.
  • Proficiently utilize Microsoft Office Suite (Word, Excel, and PowerPoint), business intelligence (Tableau), and ArcGIS software.
  • Create effective, well-designed graphs, charts, maps and other data visualizations.
  • Ask questions of data, identify patterns and anomalies, and iteratively refine data visualizations and dashboards based on feedback from the CountyStat team and from department and senior county management.
  • Learn county operational processes and procedures.
  • Work within strict deadlines while maintaining a high level of professionalism.
  • Balance competing priorities and complex situations.
  • Communicate effectively, orally, visually, and in writing.
  • Establish and maintain effective working relationships with supervisors, associates, outside agencies and the public.


Residency: Allegheny County within 1 year. 
Veterans' Preference: Will be awarded to eligible candidates.