Data Analyst

The Data Analyst is responsible for analyzing data to inform policies and improvements to operations, supporting performance improvement and innovation programs, advising departmental leaders through business intelligence, and providing data visualizations to inform City leaders and residents about the way government is working. Primary responsibilities also include supporting the deployment of artificial intelligence tools and workflow automation for City staff, the development of Digital Twins and other advanced technology programs, improving work and analytic processes within the City, data management, the City’s data governance program, and data engineering efforts conducted by the Data Services Team. 

Department:  Innovation and Performance

Salary:  $79,352 per year

Posting Type: Announcement 

Union: Non-union

Civil Service Classification:  Non-Competitive 

General Application Requirements:

You must submit or show proof of all of the following at the time of filing your application (unless otherwise indicated below) or your application will be disqualified.  Disqualifications based on any of these General Application Requirements are not subject to a Civil Service appeal.

• Applicants must submit a complete application including education, work experience, a resume (if applicable) and completed supplemental questions.
• Applicants must be or become residents of the City of Pittsburgh prior to employment and remain a resident throughout employment. 
  • Click here to view a map of City of Pittsburgh neighborhoods. 

NOTE: The City of Pittsburgh, as a matter of policy, conducts pre-employment and promotional background investigations on all candidates being considered for positions. The background investigation includes, but is not limited to, criminal background, driver's license, and City of Pittsburgh real estate tax payments. Candidates may be disqualified from consideration based on the results of their background investigation, as it relates to the job for which the applicant is being considered.

NOTE: Candidates being considered for employment must submit official transcripts verifying post-secondary education (college/university, trade school, etc.) prior to hire. 

Qualifying Requirements:
Your work experience and education/training will be evaluated to determine if you meet the qualifying eligibility requirements listed below for this position. You will receive notice of your eligibility status via email.

• WORK EXPERIENCE: The application must clearly show two (2) years of full-time experience in information science, economics, technology, engineering or a related field. (Less than full-time experience will be calculated on a pro-rated basis.)
• EDUCATION/TRAINING: The application must clearly show a Bachelor's Degree from a fully accredited institution in Computer Science, Information Science, Economics, Engineering or a related field.  (See NOTE under General Application Requirements regarding education/training verification.)
• EQUIVALENCY:  Education/training and/or work experience may be substituted on a year-for-year basis if the application clearly shows the required number of years to meet the Total Qualifying Requirement for this position, based on the sum of work experience and education/training listed above. The Total Qualifying Requirement is six (6) years. (See NOTE under General Application Requirements regarding education/training verification.)

If you meet the qualifying requirements listed above, you will receive a letter of admission (when applicable) for the following examination(s). You must pass the written and/or performance examination(s) to have your name placed on the official Civil Service eligibility list for this position. Candidates receiving job offers must pass a medical examination (when applicable) before the date of hire.

• Written:  None required for this position.
• Performance:  None required for this position.
• Medical:  None required for this position.

• Undertakes the collection, pre-processing, cleaning and analysis of data for City Departments. 
• Builds data processing models, including using AI tools to address identified business problems for internal client departments or initiatives. 
• Presents information using data visualization techniques. 
• Develops data products in the Microsoft Power Platform and participates in the development of the Microsoft Power Platform Center of Excellence to automate workflows and supports the practice of workflow automation.
• Develops artificial intelligence (AI) tools and supports initiatives related to AI.
• Performs geospatial analysis related to dashboards and data visualizations.
• Audits and provides quality assurance for analysis of I&P.
• Develops cloud computing pipelines from workflow automations. 
• Works closely with the Process Improvement and Data Engineering practices on I&P’s Data Services Team, the Infrastructure and Applications Teams, and key Department stakeholders in order to support analytics projects at the City. 
• Researches and supports the integration of emerging technologies and practices. 
• Identifies and addresses new opportunities for process improvement. 
• Acts as a liaison and City representative to community groups participating in data analytics and policy development. 
• Develops style guidance for analytic project presentation and visualization. 
• Implements procedures for data privacy and governance. 
• Develops AI strategy and governance policies in accordance with the City’s values and latest technology. 
• Collaborates with Operations Performance Analysts in City departments. 
• Performs other related tasks, duties, or trainings as assigned or required. 

Click here to view the full job description, including knowledge, skills, and abilities, and working conditions for this position. Locate and click on the position title to view the complete job description.