Sr Analyst, Finance (financial Services) - Req8102

Sr. Analyst, Finance

The Sr. Analyst, Finance, will manage the finances for Financial Services by preparing departmental budgets, monitoring revenue and expenses, investigating variances and reporting to stakeholders and service area management. Additionally, the position is responsible for the monthly consolidation and reporting of City-wide performance, including refinement of the current Power BI platform and further development of the City’s rolling forecast of expected revenue and expense levels. The position will also maintain ownership of the City’s long-term financial plan model and provide key analytical support for the City’s risk management efforts. The Sr. Analyst, Finance is expected to provide input, analysis, advice and consultation on internal finance operations, service area specific projects or programs and City-wide efforts. This may include analysis of new ventures or City initiatives, leadership of cross functional teams, and supporting and/or leading project and program evaluations. Recent examples of project work have been an analysis of inflationary impacts on City capital projects, financial evaluation of existing inter-governmental agreements and analysis of the City’s quarter cent capital tax renewal. Responsibilities will involve significant operational and financial data extraction and analysis utilizing various platforms, databases and reporting tools. Intermediate to advanced knowledge of Excel and database applications is required, while knowledge of Power BI, Crystal Reports and BI Launchpad is preferred.

Essential Duties and Responsibilities

The following duties and responsibilities are illustrative of the primary functions of this position and are not intended to be all inclusive.

• Prepare, review and edit budget vs. actual variance analysis and narrative assessment reports.
• Validate variance root causes, develop recommendations for course of action, and review and communicate impacts and results with upper management and cross functional stakeholders.
• Drive budget development and forecast projections with management team. Develop alternatives for most effective utilization of resources.
• Document and review team details and rationale for use in periodic variance reporting.
• Analyze, interpret and communicate complex data utilizing broad advanced accounting and finance conceptual knowledge.
• Data mine, compile, model and lead teams in analysis of data from various sources and systems (including ERP). Proactively identify and highlight business issue concerns and opportunities.
• Develop recommendations on business decisions based on broad knowledge of best practices and data supported financial analysis, and lead implementation of solutions.
• Participates and leads service area in capital improvement plan for core City infrastructure, coordination, validation, and assessment. Designs and actively seeks process improvements and cost-effective efficiencies.
• Oversee teams and manage financial ad hoc projects of complex nature, capital estimates, grant research and reporting, and process improvement initiatives with service area and organization-wide implications.
• Using wide experience and subject knowledge, helps to identify and explain complex issues of a financial nature, makes recommendations for resolution and works with operational and cross functional leadership to implement corrective and policy actions as needed.
• Performs and reviews standard financial and accounting work procedures while continuously looking for ways to improve processes and methods; implement improvements.
• Reconcile accounts, verify and ensure data integrity across service area.
• Establish and analyze performance metrics and measures. Identifies opportunities for improvements and recommends solutions.
• Review data entries, accounting journals, payments (AP), invoices (AR), and general bookkeeping per documented procedures, Recommends process improvements to department staff

Required Knowledge Skills and Abilities

Knowledge of local government accounting principles, Governmental Accounting Standard Board (GASB) pronouncements and interpretations. Knowledge of fund accounting Accomplished and proven critical thinking skills, analytical thought processes and business acumen. Effectively able to manage multiple projects, diverse team members and competing priorities. Advanced / Expert skill level in Excel and Microsoft Office software. Advanced statistical analysis. Strategic critical thinking in approach to problem solving, issue resolution and solution development drawing upon seasoned business acumen and perspective gained from a wide range of experience. Ability to effectively summarize and communicate financial issues, complex problems and analytics to highest level of organization and public. Advanced / Expert in data query, extraction, and normalizing. Adept and efficient at incorporating and utilizing data in a variety of reporting tools and financial software packages. Ability to lead cross-functional teams. Ability to communicate at executive level and influence both up / down the chain of command as well as cross functionally.

Required Qualifications

Minimum College degree or equivalent work experience. Some positions may require functionally related certification or advanced degrees Preferred Bachelor's degree in Accounting, Finance, Business or closely related field MBA or equivalent graduate degree.

Experience Requirements

5 years related experience or equivalent combination of education and experience. Studies have shown that women and people of color are less likely to apply for jobs unless they believe they can perform every job description task. We are most interested in finding the best candidate for the job, and that candidate may come from a less traditional background. The City of Fort Collins will make reasonable accommodations for access to City services, programs and activities and will make special communication arrangements for persons with disabilities. Please call (970) 221-6535 for assistance.