Sr Analyst, Finance (Financial Services) (Finance)

POSITION TITLE: Sr Analyst, Finance (Financial Services) (Full-Time Regular) (Classified)
REQUISITION #: req8102
DEPARTMENT: Finance Administration
LOCATION: 215 OFFICE BLDG
BENEFIT CATEGORY: Classified (Non-CBU) View Classifications & Benefits
EMPLOYMENT TYPE: Full-Time Regular
ANNUAL SALARY RANGE: $70,601.00 - 117,662.00 (Salaries are paid biweekly)
ANNUAL ANTICIPATED HIRING RANGE: $87,000.00 - 107,000.00 (Salaries are paid biweekly)
SELECTION PROCESS: Application deadline is 3:00 p.m. MT on 5/16/2025.

The City of Fort Collins is a bias-conscious employer. We ask that you please avoid the use of photos when submitting a resume and/or an application for employment. You will receive an email acknowledgment when you have successfully submitted an application. Your completed application will be forwarded to the hiring manager. You will be notified if you are selected for further testing or interviews. Please keep your contact information up-to-date. The status of your application will be updated in your applicant profile. Post-offer background check required.

Why Work For the City of Fort Collins?

• Medical, dental, vision (for self, spouse, children) - eligible on the 1st of the month following date of hire
• Paid vacation, paid holidays, sick leave, and additional one-time bank of 40 PTO hours for new, full-time, Classified and Unclassified Management hires
• Retirement + company contributions - after 6 month probation period and immediate vesting
• Flexible spending: Medical expenses FSA, dependent FSA or both
• Employee Assistance Program: counseling, legal, financial assistance
• Life insurance, short-term and long-term disability
• Wellness program, workout facilities
• Employee/family onsite health clinic
• Learning and development opportunities at all levels in the organization with opportunities for career mobility
• Collaborative work environment

To learn more about The City of Fort Collins and Our Community, please read Our Community and Our Organization Brochure

Job Summary

The City of Fort Collins is looking for a seasoned financial analyst professional to support our central Financial Services organization (Budget, Purchasing, Sales Tax, Accounting, FP&A, Grants Administration and City Give). Financial Services is committed to strengthening the community and city departments we serve through trusted stewardship, partnership, decision support, and compliance. The Sr. Analyst, Finance reports to the Budget Director and provides support to the Chief Financial Officer as well as other citywide service area leadership.

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

Management Responsibilities

No

City Competencies

• Demonstrated cultural competence to effectively interact, work, and develop meaningful relationships with people of diverse identities, perspectives, and cultural backgrounds.
• Strong learning orientation. Leverages all resources and is creative in ways of learning for self to continue adapting to changing issues and trends.
• A desire and ability to understand the diverse needs of internal and external customers, and to create experiences and deliver services that exceed their expectations.
• A desire and ability to utilize digital tools for organizational information, individual, and teamwork.

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

MinimumPreferredCollege degree or equivalent work experience. Some positions may require functionally related certification or advanced degrees 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 may consider an equivalent combination of knowledge, skills, education, and experience to meet minimum qualifications. If you are interested in applying, we encourage you to think broadly about your background and skill set for the role.

The content in this posting was created for recruitment purposes. To view the full job description click the link below.

Sr Analyst, Finance

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.

Notice Regarding Medical and/or Recreational Marijuana Use:
Because the possession and use of marijuana, whether for medical use or otherwise, constitutes a federal offense and because the City is a drug free workplace, the City will not accommodate the medical use of marijuana and enforces written policy prohibiting working for the City while marijuana is in the body. The fact that state law recognizes medical marijuana as a prescribed, or otherwise permitted, medication does not alter or otherwise change this policy.

The City of Fort Collins is an Equal Opportunity Employer. Applicants are considered for positions for which they have applied without regard to race, color, religion, creed, national origin or ancestry, sex, sexual orientation (including perceived sexual orientation), gender identity and expression, disability, age 40 years or older, pregnancy or related condition, genetic information, and, in certain specific circumstances, marriage to a coworker or any other status protected under federal, state, or local law.

BACKGROUND CHECK REQUIRED.

Note: Some information in your application may be public information under the Colorado Open Records Act.Job Summary

The City of Fort Collins is looking for a seasoned financial analyst professional to support our central Financial Services organization (Budget, Purchasing, Sales Tax, Accounting, FP&A, Grants Administration and City Give). Financial Services is committed to strengthening the community and city departments we serve through trusted stewardship, partnership, decision support, and compliance. The Sr. Analyst, Finance reports to the Budget Director and provides support to the Chief Financial Officer as well as other citywide service area leadership.

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
Management Responsibilities

No