Data/Reporting Analyst II - Park Design
About The Position
Performs seasoned-level reporting and analysis in support of the Office of Park Planning and Design (OPPD) within the Department of Parks and Recreation, primarily for the planning division. Manages data related to planning efforts and real estate acquisitions, ensuring projects and records are properly tracked, filed, and reported so teams can meet project milestones. Plans and conducts studies of operational effectiveness or trends, accesses databases and consolidates data from multiple sources, designs report formats, and summarizes findings with commentary. The role does not perform data entry. Data sources may include enterprise systems, GIS, complex spreadsheets, and databases requiring specialized expertise or training. The position plans its own work and project schedules under general, collaborative direction focused on results. The role follows the City’s hybrid work schedule policy as assigned by the Department of Human Resources Commissioner. It requires in-person work at City worksites or facilities at least four days per week, with the option to work remotely one day per week subject to eligibility, departmental needs, and supervisor approval. The schedule may change to five days of in-person work.
Requirements
- Bachelor’s degree in business/public administration, accounting, finance, information technology, statistics, human resources, or a related field; additional years of experience may exceptionally substitute for the degree, with at least eight years of professional related experience in data creation, reporting, and/or management.
- At least four years of professional related experience in data creation, reporting, and/or management, or closely related tasks; data entry does not count toward this experience requirement.
- Required skills: SQL, Microsoft Access, and Microsoft Excel.
- Thorough knowledge of databases, reporting methods and formats, and appropriate reporting languages.
- Knowledge of real property records and documents, including deeds, plats, easements, legal descriptions, and tax parcel data, and of planning and project management terminology.
- Knowledge of data governance, records management, and quality control practices.
- Computer skills for retrieving data and preparing reports, dashboards, maps, and presentations; skill in writing narrative reports and communicating.
- Skill in leading groups and speaking to groups.
- Ability to organize and present data in presentations and narrative reports for technical and non-technical audiences.
- Ability to review data and identify trends or inconsistencies.
- Ability to manage multiple priorities and deadlines and work effectively with project managers, partner departments, and the public.
Nice To Haves
- Bachelor’s degree in the listed fields, or in planning, real estate, geography/GIS, or a related field, plus five years of data analysis experience, including experience managing real estate, property, or planning data.
- Experience with GIS (ArcGIS), Power BI or Tableau, R, Python, or Visual Basic.
Responsibilities
- Manage data related to OPPD planning efforts and real estate acquisitions, including property, parcel, acquisition, and planning study information.
- Design, build, and maintain tracking systems and databases for real estate acquisitions, recording milestones, agreements, easements, due diligence items, surveys, and required filings.
- Ensure planning and real estate project records and documents, including deeds, plats, legal descriptions, agreements, and county tax exemption filings, are properly recorded, filed, and retrievable.
- Track project milestones and deadlines and alert project managers to upcoming or missed milestones.
- Plan data collection and analysis for assigned planning, real estate, and project delivery functions.
- Design custom reports, dashboards, and data displays, as well as standard report formats for ongoing functions.
- Review operating records and databases for quality and identify processes or reporting functions that lack completeness, detail, or accuracy.
- Retrieve and summarize data from information systems, including GIS and parcel/property data, for research, planning, and operating reports.
- Write queries in the appropriate reporting language.
- Review monthly operating statistics and project data and prepare monthly, quarterly, and fiscal year reports on OPPD’s project delivery pipeline.
- Support planning studies and community engagement by collecting, analyzing, and summarizing demographic, park access, survey, and other planning data.
- Generate reports, presentations, maps, graphics, forms, and other documents to demonstrate information flow and project results.
- Present periodic reports or special projects to OPPD and DPR leadership.
- Coordinate with project managers, the Department of City Planning, and other City departments to collect, reconcile, and share planning and property data.
- Establish data standards, work methods, and procedures for OPPD records and reporting, and serve as a technical resource to other employees.
- May provide leadership to interns, temporary employees, and others.
- May perform other duties as assigned.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
