DWM Data/Reporting Analyst I (Office of Engineering Services)

General Description

Performs reporting and analysis work in support of departmental research, performance reporting, operations management, and departmental operations. Designs and prepares reports by accessing databases or by consolidating data from multiple sources. Lays out report formats and produces reports. May summarize data and provide commentary or observations based on analysis. Position does not perform data entry. Sources of data may be enterprise systems, complex spreadsheets, databases, etc., requiring specialized expertise or training. Positions in this class may also perform other related administrative or operations tasks within the organization provided they have a similar level of professional challenge.

Supervision

Performs work under general supervision with review and advice from manager or a senior level professional. May work independently or with other workers with responsibility for completion of assigned tasks.

Responsibilities

• Assumes responsibility for maintaining accuracy of assigned operating records and/or databases
• Identifies processes or reporting functions that do not provide the necessary level of completeness, detail, or accuracy
• Designs standard report formats based on organizational needs for information
• Retrieves and summarizes data from various information systems for inclusion into research or operating reports
• Writes queries in the appropriate reporting language
• Reviews monthly operating statistics and operating data and prepares operating reports
• Participates in internal and external research projects by collecting, reviewing, and summarizing results
• Generates reports, presentations, graphics, forms, and other documents to demonstrate information flow and project results
• Selects from multiple procedures and methods to accomplish tasks
• Establishes work methods, timetables, performance standards, etc.
• Provides guidance and training as required to lower-level, interns, temporary employees, etc.
• Serves as a technical resource or mentor to other employees
• Monitors and updates database to reflect the most current information as it relates to accreditation compliance
• Performs seasoned-level reporting and analysis work in support of departmental research, performance reporting, operations management, and departmental operations
• Plans and executes projects to study operations effectiveness or trends
• Summarizes data and provides commentary or observations based on analysis; sources of data may be enterprise systems, complex spreadsheets, databases, etc.
• Leads other related administrative or operations processes within the organization
• Analyzes, disseminates, and prepares briefings, slides, and presentations
• May make presentations of periodic reports or special projects to organizational management
• May lead or instruct less experienced workers in high-level or technical jobs
• May perform other duties as assigned

Knowledge, Skills, and Abilities

• Knowledge of databases, reporting methods, and formats
• Skill in operation of computers to retrieve data and prepare reports and presentations
• Skill in writing narrative reports
• Skill in communicating
• Ability to review data and identify data trends and/or inconsistencies

Qualifications

Education and Experience: Bachelor's Degree in Business Administration, Public Administration, Accounting, Finance, Information Technology, Statistics, Human Resources, or a related field (additional years of experience may be considered as a substitute for the required degree on an exceptional basis, with a minimum of seven (7) years of professional related experience in creation, reporting, and/or management of data), and three (3) years of work experience in creation, reporting, and/or management of data or closely related tasks (not including data entry).

Licensures and Certifications: No specific certifications or licensures required. Individual positions may require completion of training in specific reporting languages or software.

Preferred Qualifications: Bachelor's degree as described above, and four (4) years of experience in data analysis preferred.

Work Environment

Required physical, lifting, and sensory capabilities are requirements to perform the job successfully. Typical environmental conditions associated with the job. Lifting Requirements: Sedentary work — exerting up to 10 pounds of force occasionally and/or negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body.

Schedule

This position follows the City's hybrid work schedule policy as assigned by the Department of Human Resources Commissioner and requires in-person work at City worksites/facilities at least four (4) days per week, with the option to work remotely one (1) day per week, based on eligibility, departmental needs, and supervisor approval. The hybrid work schedule is subject to change at any time to five (5) days in-person work.

Pay

Salary range: $44,369 – 63,000