Program Analyst I (Field Engineering)

Program Analyst

This is not a Civil Service Position. DWSD employees are subject to provisions of Court Orders entered in United States District Court, Eastern District of Michigan, Southern Division, Case No. 77-71100 with regard to certain terms and conditions of employment. DWSD doesnot honor reversion rights for internal candidates. Applicants for open positions at the Detroit Water and Sewerage Department must be authorized to work for ANY employer in the U.S. The Detroit Water and Sewerage Department is unable to sponsor or take over sponsorship of an employment Visa at thistime.

Program Analyst is an experienced level professional within the Operations division of the City of Detroit Water and Sewerage Department that requires minimal direction and supervision. A Program Analyst primarily serves to implement, manage and evaluate the effectiveness of the procedures and operations used in delivery of regulatory and operational programs. Program Analysts focuses on improving, reviewing, evaluating, and recommending process improvements, compliance measures, utilization of project management information systems to improve the regulatory and compliance of the organization. Program Analysts are responsible for assisting with the implementation and ongoing maintenance of the PMIS, project scheduling and provides day-to-day support for water, sewer and other operational and regulatory intensive efforts. Program Analyst has key functions within the document management systems for the operations division for accuracy and integrity of business documents throughout the document life cycle. Program Analysts assist with continual timely and accurate tracking of activity and spending of funds to ensure compliance with Organization, City, State and Federal regulations and audit requirements. Program Analysts also support the implementation and data integrity of the project management systems used for the projects and perform financial, set-up, and post-award management and administrative duties. Many of these services will be performed within the appropriate modules of the Cloud that impact the operations of this position.

Essential Job Functions:

• Using Cloud applications performs the following activities:
• Creation of Financial Performance Reports for capital funded projects
• Editing of reporting templates and workflows with E-Builder software platform
• Creation of schedules for CIP projects and assistance with project funding
• Creating effective and efficient electronic document management structure through document control practices
• Safe Drinking Water Act awareness and EGLE regulations

Analyzes and evaluates, on a quantitative or qualitative basis, the effectiveness of program operations in meeting established goals and objectives

Familiar with sanitary survey requirements lead the coordination effort between various stakeholders to consolidate and prepare final submissions for regulatory agency

Creation and maintenance of document management processes within existing platform to store and collectively share and edit documents. Managing the updating of standard operating procedure and other process documents per defined schedule.

Develops advanced cost analyses of projects or perform cost benefit or economic evaluations of current or projected programs

Ability to coordinate with field team on emergency response events

Develop funding, budget, scheduling and invoicing processes to meet DWSD financial reporting needs

Utilizes complex data collection and analysis techniques to evaluate individual programs; submits oral and written reports to management personnel for their consideration and decision-making

Research and investigates new or improved business and management practices for department programs or operations

Advises on the potential benefits/uses of automation to improve the efficiency of administrative support to program operations

Participates in evaluating new or proposed legislation or regulations to determine impact on program operations and management

Reviews audit reports to determine appropriate changes or corrective action required

Monitors compliance with all terms and conditions of reporting requirements for capital program delivery

Manage short-term high priority projects and other duties as assigned

Prepare, conduct, support, and participate in internal and external meetings. Handle or assist in the handling of administrative duties for the division including but not limited to file maintenance, data entry, personnel management, business processes and procedures, equipment purchases, office maintenance and other matters assigned. Design, implement, and support the design and implementation of organizational initiatives and special projects. Manage and assist in managing vendor relationships. Prepare, conduct, support or assist with the supporting of organizational training and training materials. Provide periodic reviews of processes and procedures and take action to ensure appropriate functionality. Perform related work duties as assigned.

Required Knowledge, Skills and Abilities:

Professional, comprehensive knowledge of the concepts, principles, and practices of capital and operational programs, the operational effectiveness, efficiency, or productivity within City agencies, and internal compliance with policies, laws, and regulations governing those programs sufficient to do experienced level work such as

Knowledge of:

• US EPA Sanitary Survey requirements
• Michigan EGLE Cross Connection requirements
• Financial theory and principles of business management operations and practices
• Concepts, principles, practices, and methods of budget formulation, enactment and execution, in the accounting and finance functional area(s)
• Principles, practices and techniques of program development, implementation, and evaluation
• Obtaining, compiling, and summarizing narrative information and quantitative data for use by others
• Data and/or statistical analysis
• Business and management principles involved in strategic planning, resource allocation, human resources modeling
• General procurement/contract management policies and practices
• Personal computer capabilities and the application of computer systems to issues of format and content in City and departmental financial management
• Enterprise resource planning systems management systems and software programs, including centralized management systems
• Project controls techniques

Skill to:

• Identifying, synthesizing, and evaluating budget related issues and assignments, consolidating information from a variety of sources, and selecting appropriate analytical approaches
• Understanding of water and sewer capital improvement projects tasks and work scopes
• Making decisions or recommendations significantly changing, interpreting, or developing important public policies or programs
• Assessing customer requirements, analyzing multifaceted business processes and data, evaluating possible solutions, and presenting recommendations to stakeholders and higher-grade personnel
• Identifying key performance indicators, (KPI) and reliable ways to collect data
• Providing direction and guidance to project teams in a collaborative manner
• Negotiating challenging situations with both internal and external stakeholders
• Use of Microsoft Office (i.e. Word, Excel, Access, PowerPoint, and / or other office suite software packages)
• Use of Excel (e.g. Pivot Tables, Vlookup, Hlookup, charts, tables, and / or other related software packages) functionality
• Communicating in writing clearly and effectively, demonstrate this skill by rendering technical details and reports in a form readily understandable to management and the public
• Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems
• Talking to others to convey information effectively
• Establishing and maintaining good working relationship with other City employees and the public

Ability to:

• Collect and analyze complex information from a variety of sources, apply criteria, draw conclusions and develop recommendations, guidelines, and policies
• Utilize a variety of fact-finding techniques (e.g. interview, case analysis, observation) to elicit appropriate data and to identify areas of operation which significantly deviate from Federal requirements
• Learn and use contemporary grants management software and other related software for program and financial management
• Read, interpret, and effectively analyze professional and technical reports
• Choose the right mathematical methods or formulas to solve a problem
• Plan, coordinate, set priorities, and oversee staff and others engaged in program management activities
• Develop and review cost-benefit and business case analyses by consolidating information, identifying relevant data, and making logical assumptions to provide insight and recommendations with minimal errors regarding cost savings, optimal organization and financial structure, and program offering
• Work tactfully and effectively with employees, supervisors and managers, grantors, sub-recipients, and with elected and appointed officials and senior staff in assigned Departments and Agencies
• Take initiative to acquire additional knowledge and education to remain current in field
• Work as part of a team

Required Education and Experience:

• Bachelor's degree in engineering or related degree preferred or equivalent work experience
• 4 years of experience within related field and job functions
• Project Management Information Systems experience in major software platforms
• Administering Content Management Software - SharePoint and BOX

Physical Requirements:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential duties of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform