Financial Analyst I (X) (Payroll)

City of Las Vegas; Las Vegas (NV); On-site; USD 55,000 - 75,000; Full time

Job summary

City of Las Vegas seeks a Financial Analyst I to support payroll processing, budgeting, and financial reporting within the Finance Department. The role emphasizes accuracy in payroll data, tax compliance, and reconciliation of multiple ledgers, with collaboration across IT and PERS reporting teams.

The ideal candidate will have a strong Excel skill set, familiarity with Oracle EBS, and the ability to audit and balance financial information while applying federal and state tax rules.

Qualifications

• At least 3 years of payroll processing and payroll reporting experience.
• Experience with Oracle E-Business Suite (EBS) preferred.
• Proficient in Microsoft Excel; able to audit, balance, reconcile payroll data and GL activity.
• Knowledge of federal/state tax regulations, wage garnishments, and PERS.

Responsibilities

• Analyze and prepare financial statements; maintain accounts incl. general ledger and reconciliations.
• Monitor revenues and expenditures; assist with budget amendments and forecasts.
• Support cash flow projections and grant-related financial reporting.
• Provide financial information to City Council, departments, and managers.
• Assist in audits and ensure compliance with internal controls.

Skills

Payroll processing

Payroll reporting

Tax compliance

Excel

Audit

General ledger

Problem solving

Analytical thinking

SQL/VBA

Education

Bachelor's degree in accounting/finance

Tools

Oracle EBS

SQL

VBA

Job description

Career Opportunity

The city of Las Vegas invites applications for Financial Analyst I (X) within the Finance Department. This position prepares and monitors budget activities; administers and maintains a variety of accounts and financial records and provides budgetary forecasts, detailed and complex reports and modifications; administers banking relations; administers the cash handling functions throughout the city; and performs a variety of technical tasks relative to assigned area of responsibility.

Ideal Candidate

The ideal candidate is an experienced, analytical, and solutions-oriented professional with a strong background in payroll processing, payroll reporting, and tax compliance, preferably in an organization utilizing Oracle E-Business Suite (EBS). The successful candidate will be highly proficient in Microsoft Excel and able to audit, balance, reconcile, and analyze payroll data, reports, invoices, bills, pension and statistical reporting, and general ledger activity, including identifying discrepancies and making appropriate adjustments or journal entries. This position requires the ability to understand and apply complex requirements related to federal and state tax regulations, wage garnishments, FLSA, PERS, personnel rules, Collective Bargaining Agreements, and memoranda of understanding. The ideal candidate will also be a strong problem solver and critical thinker who enjoys researching issues, identifying root causes, and developing effective solutions. This position works closely with IT in the development, testing, implementation, and troubleshooting of payroll-related system changes, software patches, and requests, and works collaboratively with Position Management and PERS reporting to ensure the accuracy and integrity of payroll and employee data. SQL or VBA experience is a plus. The ideal candidate will be detail-oriented, resourceful, adaptable, and able to learn new systems, processes, and requirements quickly, while also being comfortable working independently and documenting solutions and processes. A minimum of three years of progressively responsible experience in payroll processing and payroll records/reporting is desirable, with experience in an Oracle EBS environment preferred.

Financial Analyst I

This is the entry-level class within the Financial Analyst series. This class is distinguished from the Financial Analyst II classification by the performance of the more routine tasks and duties assigned to positions within the series including preparing and monitoring smaller budget accounts, assisting auditors in the audits of the city and various grant programs and funds, assisting departments in researching and obtaining grants, preparing year-end expenditure projections, assisting with the preparation of financial statements and conducting monthly analyses of expenditures, revenues, expected revenues. This class may be used as a training class, wherein employees need only limited or no directly related work experience, or the class may contain positions wherein employees perform routine tasks on a permanent basis, and therefore remain at an entry-level.

Supervision Received

Receives direct supervision from higher level supervisory or management staff. May receive functional and technical supervision from Financial Analyst II or Senior Financial Analyst.

Selection Process

The selection process will include a review of all applications to identify the most qualified candidates, who will be invited to participate in a hiring interview. Any individual offered employment must successfully complete a pre employment drug test and all required background checks for the position.

Essential Functions

1. Analyzes and prepares financial statements; maintains a variety of accounts to include general ledger and reconciliation of all city financial transactions, including bank accounts; prepares monthly fiscal reports and special reports relating to the progress of assigned accounts or area of responsibility.
2. Analyzes revenues and expenditures of city or grant funds; recommends amendments to the budget as appropriate; prepares final cost estimates for the annual budget, special funds or grants being sought.
3. Participates in the compilation and preparation of the city's annual budget; prepares cash flow and expenditure projections and various budget-related forecasts and reports; provides personnel costs from salary projections.
4. Prepares annual financial reports for city departments or revenue sources; monitors interlocal agreements with other governmental agencies; prepares statistical financial reports; prepares necessary work papers for annual budget.
5. Serves as a financial resource to the City Council, City Manager and city departments; provides information regarding a variety of accounts, revenues and expenditures.
6. Analyzes, accounts for and audits grant monies and special revenues received by the city; acts as liaison between the division of assignment and grantors; processes requests for funds and obtains authorized signature of approval.
7. Assists the Budget & Treasury Manager to maintain a city-wide cash handling policy and procedures manual; administers and enforces the policy and procedures; trains city employees who handle cash in proper procedures; conducts audits to determine compliance; prepares required reports.
8. Assists departments in the proper classification of revenues and expenditures; provides technical assistance and training to city staff in matters related to financial accounting, budget administration, and financial and operational performance management.
9. Monitors various accounts verifying availability of funds and classification of expenditures; researches and analyzes transactions to resolve problems.
10. Recommends and implements changes in accounting, budgeting and auditing systems and procedures.
11. Monitors daily activity in all city bank accounts and performs cash management duties; forecasts short term cash flow. Participates in maintaining positive banking relationships.
12. Maintains required records and assists with records retention.
13. Assists in developing costing pools, allocation rates and allocation definitions to ensure proper distribution of costs.
14. Operates an automated financial system and acts as liaison with Information Technologies staff as needed.

Marginal Functions

1. Attends and participates in professional group meetings; stays abreast of trends and innovations in the field of finance and budget.
2. Performs related duties and responsibilities as required.

Experience

One year of experience in accounting, auditing, finance, budgeting, grants, or investments.

Training

Bachelor's degree from an accredited college or university with major course work in accounting, finance or a field related to the essential functions. A combination of formal education and directly related work experience may substitute for the degree. The city assesses 1.5 years of fulltime experience as equivalent to one year of education.

Knowledge of

• Generally accepted accounting and finance practices, principles and procedures.
• Principles and practices of budgeting.
• Principles and practices of financial auditing.
• Principles and procedures of financial record keeping and reporting.
• Principles and procedures of internal control systems.
• Cash handling procedures.
• Principles of report preparation.
• Modern office methods, practices, procedures and computer equipment.
• Pertinent federal, state and local laws and regulations.

Ability to

• Learn governmental accounting principles and practices.
• Learn principles and practices specific to municipal budget preparation and monitoring, and cash management.
• Learn the city's automated financial management system.
• Operate a variety of general office software applications and applications specific to the assignment.
• Communicate clearly and concisely, both orally and in writing.
• Establish and maintain effective, cooperative working relationships with those contacted in the course of work.
• Use initiative and independent judgment within established guidelines.
• Plan, organize and prioritize assignments.
• Meet critical deadlines.
• Manage multiple assignments.

WORKING CONDITIONS

Environmental Conditions

Work primarily in an office environment; occasional travel from site to site; exposure to computer screens.

Physical Conditions

Essential and marginal functions require:
Maintaining physical condition appropriate to the performance of assigned duties and responsibilities which may include the following:
-- Walking, standing, or sitting for extended periods of time; and
-- Operating assigned equipment.
Maintaining effective audio-visual discrimination and perception needed for:
-- Making observations;
-- Communicating with others;
-- Reading and writing; and
-- Operating assigned equipment.
Maintaining mental capacity which allows the capability of:
-- Making sound decisions;
-- Effective interaction and communication with others; and
-- Demonstrating intellectual capabilities.