Applicants with Disabilities
Applicants Seeking Re-Employment
Career FAQs
Benefits
Position Title: CountyStat Analyst

Salary: $63,000-$68,000 per year

How to Apply:

Applications are submitted online until the position is filled and/or the posting is closed. After reviewing this job announcement, please click on the link at the bottom of the page to apply online. A resume is required with the application. Further instructions on submission of documents are available in the online application. A resume may not be substituted for an application.

Minimum Requirements:
  • Bachelor’s Degree from a fully accredited institution in Public Administration, Information Systems, Data Science, Statistics, Business Administration, or a related field AND two (2) or more years of experience in data analysis, business intelligence, or other related experience.
  • An equivalent combination of education and experience may be substituted.
  • Master’s degree preferred.

It is the policy of Allegheny County that in order to receive a final offer of employment, candidates must successfully pass a background check, which includes verification of Allegheny County Real Estate Tax status.

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.
AN EQUAL OPPORTUNITY EMPLOYER - M/F/V/D


Apply Online