OFFICE OF DEVELOPMENT AND GRANTS PROGRAM ANALYST II

Be a Part of the City You Love! The Office of the Chief Financial Officer - Office of Development and Grants is accepting applications for a Program Analyst II.. Program Analyst II is an intermediate level professional that receives close direction from higher level Program Analysts and supervision from a Supervisor or Manager I. A Program Analyst II primarily serves as an advisor to management on the evaluation of the effectiveness of government programs and operations. Program Analysts focus on reviewing, evaluating, and recommending approval of applications for grants and contracts. Program Analysts are responsible for assisting with the implementation and ongoing maintenance of the City's centralized grants management system and provides day-to-day support for the following groups: (1) Neighborhood, Community, and Economic Development, (2) Public Safety, Health, and Private Foundations, and (3) Transportation and Public Works and Government Operations. Program Analysts assist with continual timely and accurate tracking of activity and spending of City grants to ensure compliance with State and Federal regulations and audit requirements. Program Analysts also support the implementation and data integrity of the grants management system 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 ERP Cloud that impact the operations of this position. Using ERP Cloud applications performs the following activities: Creation of Grant/Financial Performance Reports Editing of reporting templates Generating revenue Processing and interfacing revenue to General Ledger Generating invoices Creation of Grant Awards Assistance with project funding Creating contracts Analyzes and evaluates, on a quantitative or qualitative basis, the effectiveness of program operations in meeting established goals and objectives Develops, administers, monitors or evaluates economic and community development programs, grants and/or contracts for conformance, effectiveness and timeliness Develops cost analyses of projects or performs cost benefit or economic evaluations of current or projected programs Independently conducts field surveys and carries out routine research in connection with budget, legislative or management studies and/or performs analysis of actual expenditures compared to the budget or public policy issues Utilizes data collection and analysis techniques to evaluate individual programs; submits oral and written reports to management personnel for their consideration and decision-making Researches and investigates new or improved business and management practices for application to agency programs or operations Reviews audit and investigative reports to determine appropriate changes or corrective action required Provides assistance to Federal, State, and local agency officials in developing proposals and in preparing program plans and project application documents Receives from Departmental Financial Services financial and financial-related information to perform analysis of program effectiveness Analyzes new or proposed legislation or regulations to determine impact on program operations and management Performs and supports grant application development as directed and in coordination with City department staff Reviews, analyzes, and evaluates grants/assistance applications, plans, and estimates Prepares, processes, issues, and tracks grants/assistance awards and ensures and monitors compliance with all terms and conditions of reporting requirements Gathers grant-related data and reports from City departments and performs the electronic filing of that information into the centralized grants management system Monitors and analyzes grantee financial and progress reports to assure funds are properly expended Performs review of completed awards, makes appropriate adjustments or disallowances, and processes close-outs in a timely and compliant manner Conducts post-award reviews and analyses to identify management, financial, and administrative issues Identifies promising and strategic grant opportunities in both the private and public sectors Performs special projects and other duties as assigned Bachelor's degree from an accredited college or university, with major course of work in business administration, public administration, public policy, economics, finance, accounting, urban studies, information technology, or a closely related field. In addition, Program Analysts with a master's degree, such as master's in business administration, master's in public administration, master's in finance, master's in economics, Masters in a technology related field, and other appropriate and related courses of study meet the minimum experience required for Program Analyst II. In addition to the minimum education requirements, the following experience requirements also apply: For entry into the Program Analyst position, one (1) year of professional experience providing project management-related activities or a systematic review, analysis, interpretation, and evaluation of grants, housing development or other financial/operational data is preferred but not required. Program Analyst must demonstrate proficiency with integrated word processing and spreadsheet functions. For selection, appointment to a Program Analyst level II or higher, in addition to the minimum education requirements, more progressive levels of experience are required based on the following: Program Analyst II - at least two (2) years of experience Licensing and Certifications Preferred certifications include the following: PMP Certification; PgMP Certification; CAPM Certification; PMI-PBA Certification; PMI-ACP Certification; Lean Six Sigma Certification; or ITIL Certification. Equivalency Equivalent combinations of education and experience that provide the required knowledge, skills, and abilities will be evaluated on an individual basis.

Evaluation Plan Interview:

70%

Evaluation of Training, Experience & Personal Qualifications:

30% Total of Interview and Evaluation T.E.

P:

100%

LRD:

10/02/2025

Knowledge, Skills and Abilities Knowledge of:

• Concepts, principles, practices, and methods of budget formulation, enactment and execution, accounting and finance functional area(s)
• Principles, practices and techniques of program development, implementation, and evaluation
• Formal project management processes, resource management, risk management, scope, and change request management, schedule management, communication plans and internal controls, and quality management
• Federal, State, and local laws, regulations, rules, policies, procedures, and methods governing the economic development and the administration of grants, cooperative agreements, and awards
• Schedule of Expenditures of Federal Awards (SEFA) preparation
• Grants/assistance management processes and techniques consistent with sound business and industry practices
• Obtaining, compiling, and summarizing narrative information and quantitative data for use by others
• Data and/or statistical analysis
• Process improvement tools and methodologies
• Interdependencies between business processes and technology
• Standardized bookkeeping processes and general accounting terminology
• Business and management principles involved in strategic planning, resource allocation, human resources modeling, leadership technique, and coordination of people and resources
• Structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar
• Standard 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 for finance, budget, general ledger, human resources, and other management systems and software programs, including centralized grants management systems Skill in:
• Identifying, synthesizing, and evaluating program related issues and assignments, consolidating information from a variety of sources, and selecting appropriate analytical approaches
• Making decisions or recommendations significantly changing, interpreting, or developing important public policies or programs
• Assessing customer requirements, analyzing business processes and data, evaluating possible solutions, and presenting recommendations to stakeholders and higher-grade personnel
• Identifying key performance indicators and reliable ways to collect data related to such
• Providing direction and guidance to project teams in a collaborative manner
• Negotiating challenging situations with both internal and external stakeholders
• Reconciling accounts against multiple systems
• Presenting concise financial and operational information (orally, written, and/or using PowerPoint or Word) to a variety of audiences
• 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
• Understanding written sentences and paragraphs in work related documents
• Giving full attention to what other people are saying, taking time to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times
• 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, quickly interpret, and analyze 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
• Utilize process analysis techniques to identify opportunities for process and/or technology improvements
• 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 supervise staff and others engaged in program management activities
• Develop 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
• Participate in decision-making sessions, provide guidance, and advise a number of program managers on legal and regulatory requirements, financial policies, the interpretation of data, potential roadblocks, and program improvements through analysis of fund requests, program operations, monthly reports, and special analysis
• Communicate information and ideas clearly and effectively both orally and in writing so they can be understood
• Read and understand information and ideas presented in writing
• Add, subtract, multiply, or divide quickly and correctly
• Apply general rules to specific problems to produce answers that make sense
• 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

PHYSICAL DEMANDS

The work is characterized as sedentary. Typically Program Analysts sit comfortably to do their work, interspersed by brief periods of walking, standing, bending, carrying of papers and books, and extended periods requiring the use of computer terminals to accomplish work objectives.

WORK ENVIRONMENT

Work is performed in a comfortable office environment which is appropriately lighted, heated and cooled. The work environment contains no significant hazards. Some work may require walking and standing in conjunction with travel to and attendance at meetings and conferences away from the work site. The Program Analyst may encounter individuals that are upset. The above statements describe the general nature and level of work performed by employees assigned to the class. Incumbents may be required to perform job-related responsibilities and tasks other than those stated in this specification. Specific job duties may vary from position to position. The City of Detroit is an Equal Opportunity Employer. No applicant for employment shall be discriminated against on the basis of race, color, national origin, sex, religion, age, disability, or other criteria prohibited by City, State, or Federal law.