Professional Administrative Analyst

Professional Administrative Analyst 3 (Finance Department) Location Detroit, MI (Downtown area) : Description 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 does not honor reversion rights for internal candidates. SUMMARY: The Professional Administrative Financial Analyst provides information and analysis to enable executives, managers, and supervisors to make informed strategic and tactical business decisions. The Professional Administrative Financial Analysts focus is on financial and operational planning and analysis including strategic planning, budgeting, forecasting, financial modeling, and detailed financial analysis. The Professional Administrative Financial Analyst will work effectively with minimal supervision and will report directly to the Chief Financial Officer. ESSENTIAL JOB FUNCTIONS: The Professional Administrative Financial Analysts will prepare weekly, monthly, quarterly, and annual reports in which the analyst will compare financial and operational results using actual, historical, budget, and forecast data. The Professional Administrative Financial Analysts monitors the implementation of DWSD's budget to ensure compliance and develop financial and operational metrics to measure progress. The Professional Administrative Financial Analysts also prepare reports and presentations and provide recommendations regarding the financial and operational risks and opportunities associated with particular decisions. The Professional Administrative Financial Analysts use enterprise resource planning systems, spreadsheet, and statistical software packages to analyze financial and operational data, identify trends, and develop forecasts.
Examples of Duties REQUIRED KNOWLEDGE, SKILLS AND ABILITIES KNOWLEDGE OF : Financial theory and principles of business management operations and practices Operational cost metrics such as overtime, productivity, operating expenses, GL assignments, activity based costing concepts Financial Planning and Analysis from running a day to day operation Budget Planning and Analysis Contracting cost and analysis Make versus Buy Analysis Concepts, principles, practices, and methods of budget formulation, enactment and execution, accounting and finance functional area(s) Standardized bookkeeping processes, accounting terminology, generally-accepted accounting principles (GAAP), accounting techniques, and other financial rules and regulations Business technology, data management systems and applications Department-wide reporting tools Departmental mission, processes, policies and procedures Economic and accounting principles and practices, the financial markets, banking, and the analysis and reporting of financial data Basic Geographic Information Systems SKILL TO : Identify, synthesize, and evaluate complex budget related issues and assignments, consolidating information from a variety of sources, and selecting appropriate analytical approaches Present concise financial and operational information (orally, written, and/or using PowerPoint or Word) to a variety of audiences Use Microsoft Office (i.e. Word, Excel, Access, PowerPoint, and / or other office suite software packages) Use Excel (e.g. Pivot Tables, Vlookup, Hlookup, charts, tables, and / or other related software packages) functionality Communicate in writing clearly and effectively, demonstrate this skill by rendering technical details and reports in a form readily understandable to management and the public ABILITY TO : Work effectively with minimal supervision Complete specialized, technical assignments Develop effective working relationships with other business units as well as external vendors and customers Conduct Research Partners with City Agencies to oversee the development of multi-year operating and capital plans, reserve forecasts, and long range financial strategies Manage the strategic financial modeling, annual target setting, and annual business planning process for City Agencies to assess financial implications and support complex business decisions Recommend, develop, implement, and monitor financial and operational policies, guidelines, processes, procedures, internal controls, and performance measures Analyzes and evaluates the financial and business operations and transactions engaged in by many different departments/agencies Communicate effectively, both verbally and in writing Understand and follow verbal and written instructions Establish and maintain effective working relationships with others Communicate frequently with team members and other units across the Department about process, equipment or potential problems Effectively utilize appropriate security and safety equipment and procedures Maintain regular and reliable attendance Develop proficiency in unit specific operations and software Direct team activities or to work as a team member Collect, quickly interpret, and analyze information from a variety of sources, apply criteria, draw conclusions and develop recommendations, guidelines, and policies 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 diversified fiscal analysis and forecasting 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, by interpretation of data, potential roadblocks, and program improvements through analysis of monthly reports and special analysis Communicate information and ideas clearly and effectively both orally and in writing Work tactfully and effectively with employees, supervisors and managers, 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 Minimum Qualifications ABILITY TO: Work effectively with minimal supervision Complete specialized, technical assignments Develop effective working relationships with other business units as well as external vendors and customers Communicate effectively, both verbally and in writing Understand and follow verbal and written instructions Demonstrate proficiency in written communication Establish and maintain effective working relationships with others Communicate frequently with team members and other units across the Department about process, equipment or potential problems Effectively utilize appropriate security and safety equipment and procedures Maintain regular and reliable attendance Develop proficiency in unit specific operations and software Direct team activities or to work as a team member Decide on content of correspondence, reports or on procedures to be followed, based on the circumstances of individual cases and departmental rules, records and policies Conduct Research Provide information to the public regarding DWSD policies and procedures Respond to workplace dynamics in a timely, visionary and proactive manner Proficiently utilize standard office and pertinent specialized software Interpret and analyze data Manage multiple priorities Acquire additional training and knowledge of contemporary principles and best practices of function managed Work effectively with minimal supervision Complete specialized, technical assignments Develop effective working relationships with other business units as well as external vendors and customers REQUIRED EDUCATION AND EXPERIENCE (position requirements at entry) Bachelor's degree; with specialization in Business Administration or related field of study Minimum of 1-3 years of experience related to the field and/or job assignment Education requirement can be substituted with extensive experience, at the discretion of the General Manager or designee. Experience working in a legal environment Supplemental Information ESSENTIAL REQUIREMENTS 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 the essential duties. This position requires the ability to remain sedentary and requires extensive computer use and extended time seated in meetings. Environmental Working Requirements: Work may be performed in the plant or office environment. Work may be performed near excessive noise and moving objects/vehicles. OTHER REQUIREMENTS Valid Michigan Driver's License Ability to work irregular hours, to commute to DWSD facilities and work sites, and respond to after hour emergencies and on-call responses. 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. Employees in this class are required to undergo alcohol and drug screening and are subject to a criminal background investigation.