Senior Financial Planning & Analysis & Financial Systems Analyst

Sound Transit9 months ago
Seattle, WA, United States
Hybrid
Full-time
Junior Level (1-3 years)

Job Description

Position Overview

Salary: $81k to $170k, with a midpoint of $118k. New hires typically receive between the minimum and midpoint, with potential adjustments based on experience, internal equity, and market.

Under general direction, this role serves as the global administrator for the Agency’s financial planning, reporting, and budgeting application. You will oversee all aspects of change management, application upgrades, data integrity, configuration, security, and reports management. The position supports the FP&A Director and managers by developing, producing, and maintaining a wide range of financial reports, ad hoc queries, and data analysis to aid in the annual budget process and long-term financial planning.

Key Responsibilities

  • Establish, document, and validate FP&A system requirements to support monthly, quarterly, and annual operating and project budgets, forecasts, and budget versus actual reports.
  • Act as FP&A’s technical support liaison with IT, vendors, and other departments to troubleshoot system issues, create new reports, and update system configurations.
  • Perform global administrator functions including user security/permissions, system configuration, and maintenance of lookups, custom fields, and organizational structures.
  • Lead testing for system updates and changes, ensuring proper integration of data from other Agency systems and conducting quality control to maintain data accuracy.
  • Upload annual budgets into the ERP system and project cash flows to the long-term financial plan, while maintaining comprehensive system documentation.
  • Perform service desk functions, including triage, escalation, and stakeholder communication; conduct root cause analysis and implement mitigation actions for continuous improvement.
  • Deliver timely, accurate ad hoc financial reports, develop financial models, forecasts, and variance analyses to support budget reviews and decision-making processes.
  • Collaborate with various divisions, contribute to Agency committees, and promote a culture of diversity, safety, and sustainability.

Required Qualifications

  • Education: Bachelor’s degree in Finance, Accounting, Economics, Business Administration, Computer Science, Math, Statistics, Information Technology, or a closely related field; or an equivalent combination of education and experience.
  • Experience Required: At least five years of experience in financial analysis, data management, reporting, and administering enterprise-level software.
  • Proven knowledge of computer and network systems, enterprise financial systems, business intelligence tools, and reporting software (e.g., advanced Microsoft Excel, Power BI, SQL, etc.).
  • Strong understanding of financial planning and analysis concepts, accounting principles, and report writing techniques.
  • Excellent analytical, communication, project management, and problem-solving skills with the ability to manage multiple tasks and collaborate effectively with cross-functional teams.
  • Must be capable of working in a standard hybrid office environment while adhering to all safety protocols.

Benefits & Perks

  • Health Benefits: Two choices of medical plans, a dental plan, and a vision plan provided at no cost for employee coverage; comprehensive benefits for eligible dependents.
  • Long-Term Disability and Life Insurance.
  • Employee Assistance Program.
  • Retirement Plans: 401a (10% of employee contribution with a 12% match) and 457b (up to IRS maximum based on employee contribution).
  • Paid Time Off: Accrual of 25 days annually with additional days based on years of service, plus 12 paid holidays, floating holidays, and volunteer days.
  • Parental Leave: 12 weeks of leave for new parents.
  • Pet Insurance.
  • ORCA Card: Provided at no cost to all full-time employees.
  • Tuition Reimbursement: Up to $5,000 annually for approved tuition expenses.
  • Inclusive Reproductive Health Support Services.

Required Skills

Budgeting
Financial Analysis
Data Management
FP&A
Financial Reporting
Project Management
SQL
System Administration
Advanced Microsoft Excel
Power BI