Planner Ii - Ddot

Area of Specialization: GIS & Demographic Data
SUMMARY: Under general supervision, is responsible for map-based reporting and data analysis. On a cyclical basis, prepares federally mandated reports, such as National Transit Database inputs and Title VI compliance analyses. On a dynamic basis, produces similar outputs for city, state, regional and institutional stakeholders. Satisfies reporting requirements in an accurate, proactive manner, makes extensive use of GIS (geographic information systems) software. Maintains a working knowledge of specialized operational systems such as automatic vehicle location (AVL), automatic passenger counters (APC), and various scheduling/planning modules. Locates external data to provide essential context for internal data. Delivers outputs that are subject to extensive scrutiny by oversight agencies.
Adheres to precise timelines and standards, but also has latitude to take creative approaches to technical, multi-faceted challenges. Projects require close collaboration with other data-centric staff throughout the Department.
Area of Specialization: Ridership & Operations Data

1. Extracts data from various systems to compile performance summaries.
2. Collaborates with other groups to maximize value of technology systems.
3. Writes and updates queries to retrieve desired outputs.
4. Implements methods to increase efficiency of data compilation.
5. Maintains structured, organized files and queries for interoperability between different systems and different users.
6. Reviews inputs, outputs and new data sets for accuracy and applicability.
7. Transfers, imports and exports data/files between various platforms.
8. Compiles raw outputs into mainstream formats, such as spreadsheets and written reports.
9. Participates in City-wide efforts to enhance data accessibility.
10. Develops a working knowledge of ground-level transit operations and maintenance practices.
11. Fulfills individual requests for data, either in raw or processed form.
12. Interacts proactively with Service Development group to build effective transit services, including routes, bus stop locations and scheduled point-to-point running times.
13. Interacts with other transit workgroups to pinpoint problems and deploy solutions.
14. Archives all digital and hard-copy materials in a clear, accessible manner.
15. Advises the entire Department on matters affecting data and technology.
16. Makes occasional presentations on technology systems and reports.
17. Conducts occasional fieldwork at special events, at transit locations or on-board transit vehicles

Area of Specialization: GIS & Demographic Data

1. Prepares complex reports to quantify the effects of transit service proposals.
2. Uses GIS software to develop maps for various presentation formats.
3. Queries GIS data to fulfill requests about transit characteristics.
4. Produces other geographical or tabular representations of data.
5. Extracts geographical components from various internal systems for use in a GIS environment.
6. Sources external data for use alongside internal data.
7. Maintains structured and organized files for interoperability between different users and systems.
8. Reviews inputs, outputs and new data sets for accuracy and applicability.
9. Transfers, imports and exports data/files between various platforms.
10. Compiles raw outputs into mainstream formats, such as spreadsheets and written reports.
11. Participates in City-wide efforts to enhance data accessibility.
12. Develops a working knowledge of ground-level transit operations.
13. Interacts proactively with Service Development group to build effective transit services, including routes, bus stop locations and scheduled point-to-point running times.
14. Archives all digital and hard-copy materials in a clear, accessible manner.
15. Advises the entire Department on matters affecting data and technology.
16. Makes occasional presentations to stakeholders on performance of technology systems.
17. Conducts occasional fieldwork at special events, at transit locations or on-board transit vehicles

Bachelor's Degree in Geography/Geographic Information Systems (GIS), Planning, Statistics, Mathematics, Programming or Information Management
Four (4) years of experience using geographical data in a commercial environment, such as sales planning, business reporting or market research, preferably including two (2) years of experience in a municipal or public-sector function such as zoning, planning, compliance or transit management. A demonstrated ability to learn and apply new skills may substitute for direct professional experience.Evaluation Plan

• Interview: 70%
• Evaluation of Training, Experience & Personal Qualifications: 30%
• Total of Interview and Evaluation T.E.P: 100%

Additional points may be awarded for:

• Veteran Points: 0 - 15 points
• Detroit Residency Credit: 15 point

LRD:09/07/2023Employment Type: Certified-Regular Civil Service