Salary: $6,915 - $9,354, monthly
Location: Tigard, OR
This position serves as primary system administrator for the District’s enterprise resource planning (ERP) software including maintenance of finance-related data. Performs analysis on accounting information utilizing internally and externally derived financial data. Supports the annual operating and capital budget processes.
Further details on the ideal candidate profile and the recruitment timeline can be found in the Sr. Financial Analyst flyer.
Example of Duties
RESEARCH, REPORTING, AND ANALYSIS:
Designs, builds, publishes, and maintains a variety of reports for internal auditing and budgeting. Provides information to Finance leadership on assigned aspects of the financial function to ensure operational efficiency. Performs forecasting and other statistical analysis useful in the strategic planning and management of the District’s finances and in making policy improvements. Researches data trends to determine possible impacts to District business operations. Extracts, manipulates, and analyzes data from internal and external sources. Provides accurate and timely data analysis and reporting in responses to questions from Finance department leadership on urgent financial business issues. Compiles and reconciles all data for Capital Bond Program for arbitrage analysis. Regularly analyzes budget-to-actual variances and investigates unusual items. Creates annual financial statements, assigned footnotes, and tables and charts for ACFR. Researches, gathers, and prepares statistical section of ACFR. Designs content for the PAFR as assigned.
ERP ADMINISTRATION: Ensures financial system quality and continuity through problem identification, reporting, tracking, analysis and resolution. Acts as primary liaison between the Finance and Information Technology departments and the ERP software provider and works in partnership with Information and Technology in troubleshooting and maintaining software and system upgrades. Creates user attributes for all ERP users, including security, workflow and permissions. Maintains and updates system codes and system integrity using diagnostic tools. Troubleshoots and resolves issues within system modules and sub-ledgers. Researches, recommends, and assists in implementation of new system functionality. Facilitates assigned committee meetings.
MONTH END/YEAR END PROCESSING: Performs monthly and annual financial close processes in District’s ERP and prepares the monthly financial statements and analysis reports for presentation to District leadership and Board of Directors. Plans processes and system readiness in advance of all closings, including surfacing observed discrepancies. Identifies and supports closing and forecast process improvement initiatives.
BUDGET PROCESS AND DOCUMENT SUPPORT: Supports annual budget process from calendar development up to adoption of the final budget document. This includes preparing, consolidating, and distributing budgets and related reports. Formulates and uses data extraction for historical analysis and cost projections for budget. Prepares estimated FTE, wage and benefit budget projections and fund overviews. Creates and maintains budget user guides for budget development. Supports successful department budget development by providing budget training and guides to budget managers and staff. Analyzes budget requests and verifies accurate entry into District’s ERP software. Maintains entirety of ERP budget system, including configuration of budget modeling, uploading budget figures, and confirming balanced status. Provides information to external budget committee as assigned. Processes budget adjustments and amendments. Maintains Chart of Accounts for new budget and other items. Prepares and files all required forms with state and county governments in accordance with Oregon budget law.
SPECIAL PROJECTS: Collects property tax information from all counties for analytical purposes. Prepares analysis of collection rates and compression for review by District management. Conducts analysis of actual property tax collection and compiles data and supporting documentation for the annual audit. Researches and analyzes new accounting standards specific to property tax standards. Prepares reports, registers, and work papers to support the annual audit process. Manages assigned projects, including, but not limited to, performing needs assessments and analysis, gathering project requirements, creating project plan with deadlines, communicating with stakeholder groups, executing plan, testing/evaluating solutions, and adapting approach to changing conditions.
Complete information about the functions and secondary functions can be found in the job description.
Bachelor’s degree. Degree in accounting, finance, business administration, or business information systems preferred.
Five years of experience performing business analysis and financial reporting using data extraction and structured query language (SQL).
Experience with SQL report writing.
Experience in budget development processes preferred.
ERP system administration and workflow experience highly preferred.
Tyler Munis ERP experience is preferred.
Complete information about the qualifications can be found in the job description.
The selection process will comprise of a minimum qualification review, Sparkhire one-way video interview and an on-site panel interview and skills demonstration.
Applications accepted through - May 10, 2022 or sooner
Invitation to complete SparkHire video interview Starting - April 25
One-way video interviews completed by May 15
Onsite panel interview and skills demonstration Week of June 2
Anticipated start - Late June - early July 2022
*Consideration of candidates will begin immediately and the posting may close without notice when a sufficient number of qualified candidates are received.
The monthly salary range within a step system for this position is $6,915 - $9,354 per month. The starting pay assignment, based on a candidate's bona fide factor analysis in accordance with the District's pay equity system and the Oregon Equal Pay Act and will be in the range of $6,915 - $8,292 per month. The maximum of $9,354 can be attained after five years contingent on performance.
TVF&R evaluates each applicant's work history and responses to supplemental questions. Please be sure to thoroughly answer the application's supplemental questions to ensure our subject matter experts can appropriately evaluate your experience and qualifications. To reduce barriers to entry, TVF&R evaluates an applicant's work history and responses to these supplemental questions rather than requiring cover letters and resumes.
It is the District's policy to provide eligible veterans with preference as required by law. Applicants must provide certification of eligibility for entitlement to the preference (e.g. DD-214 long form clearly showing discharge status) with the application submission by the closing date of the posting.
The location for this position is the Command and Business Operations Center, located in Tigard, OR.
Tualatin Valley Fire & Rescue strives to provide exceptional internal and external customer service. To ensure a collaborative and supportive environment with both the public we serve and our coworkers, employees perform their work on-site at the assigned work location.
TVF&R is an equal employment opportunity employer and seeks to attract a diverse workforce that reflects the community we serve in order to deliver safe, profession, and high-performance service.
How to apply: