Senior Reporting Analyst

City Of Seattle, WA Seattle , WA 98113

Posted 3 months ago

Position Description Benefits Supplemental Questions

The City of Seattle Finance and Administrative Services Department (FAS) has the most diverse set of responsibilities of any City department. Our 630 employees are responsible for a broad array of operations, including but not limited to: building and renovating fire stations; negotiating contracts for City-funded construction projects; operating and maintaining more than 100 City facilities; managing the City's investments; overseeing its central accounting system; servicing police and fire vehicles; issuing business licenses; collecting taxes; and advocating for animal welfare. FAS Shared Accounting Services also provides the accounting support services for fifteen Small Departments and Executive Offices (SDEOs).

We are seeking a Senior Reporting Analyst to maintain existing reporting files and create new reporting options in support of FAS business units. The Senior Reporting Analyst will be responsible for generating and maintaining standardized financial reports enabling informed spending decisions and financial management for all FAS divisions and SDEOs. The position will also be responsible for preparing complex financial ad hoc reports based on business needs and upon requests.

Job Responsibilities:

  • Serve as resident budget system expert and lead for budget system implementation, upgrade and/or enhancement; prepare and provide system related training, and research system issues; serve as system administrator.

  • Responsible for leveraging available data sources to create financial reports; designing, running and maintaining ad hoc queries; maintaining data integrity through consistent monitoring, testing and auditing of financial data.

  • Responsible for development, validation, delivery, and maintenance of standard financial reports. Develop, maintain, and execute ad hoc reports and standardized queries against financial systems.

  • Ensure data integrity of reports by consistent monitoring, testing and auditing the financial data. Create reports and financial analysis documents that are clear, complete and user friendly. Utilize multiple reporting platforms to create and publish financial reports on an ongoing basis.

  • Liaison with financial staff, project managers, and FAS divisions to identify reporting needs and identify solutions. Support customers by providing timely and accurate financial reports. Represent FAS in relevant citywide data and reporting meetings.

  • Perform high level financial analysis and prepare related budget and accounting reports. Assist the budget team in the development of all phases of the annual FAS operating budget. Assist the team in monitoring and reporting on budget, expenditures, and revenues for FAS operating budget and adjunct funds, including variance analysis, resource utilization, and position management.

  • This position will perform other related duties commensurate with classification level.

NOTE: Equivalent combinations of education and experience will be considered for the required qualifications.

Education: Bachelor's degree in accounting, finance, economics, business or public administration, information systems or related field.

Experience: Three years' professional experience in budget and finance management reporting including experience working with enterprise resource planning (ERP) / financial management systems (PeopleSoft, Oracle, etc.) with a focus on report preparation, and experience writing queries using tools such as SQL.

Desired Qualifications:

  • Excellent interpersonal, written, and oral communication skills, with the ability to present complex material to various audiences. Experience in creating visualizations and dashboards using tools such as Tableau or Power BI.

  • Ability to manage multiple projects simultaneously and meet rapidly changing deadlines in a fast-paced technical environment.

  • Ability to manage and manipulate large datasets in Excel. Strong data analysis and data modeling skills using Excel PowerPivot and knowledge in using advanced functions.

  • Strong analytical and organizational skills, creative problem-solving and negotiation skills and proven ability to work collaboratively, as well as independently. Ability to interface with diverse work force within City government and other entities.

  • Strong understanding of project activity based costing and internal cost recovery allocation processes. Working knowledge in government budget/accounting standards and principles.

Additional Information: Please submit cover letter and resume to be considered.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Accountant Financial Reporting


Posted 1 week ago

VIEW JOBS 9/11/2019 12:00:00 AM 2019-12-10T00:00 Redfin is redefining real estate in the consumer's favor by combining our own technology and agents to create a service that's better, faster, and costs less. As a Redfinnian, you'll make a difference in one of life's most important events—buying or selling a home. Our hiring standards are high, yet our culture is humble. We've got all the perks, but if what you value most is doing great work in a creative, collaborative, and disciplined environment, join us. As a Senior Accountant for Financial Reporting, you'll be part of the Accounting & Finance team responsible for corporate accounting, internal and external reporting, and financial controls. Working with folks across the company, you'll take on interesting challenges while demonstrating your entrepreneurial drive and willingness to embrace ambiguity. This position reports to the Manager of Technical Accounting and Compliance. The Role * Generate internal and external financial statements and participate in the reviews of monthly financial reporting package. * Engage with other finance team members and cross functional business partners in the preparation and review of SEC (10-K, 10-Q, 8-K) filings. * Support the annual and quarterly audits and SEC reporting requirements, as well as annual statutory audits. * Perform technical accounting research on new pronouncements from the FASB, SEC and other authoritative bodies to identify the potential impact of new accounting and SEC reporting guidance. * Develop and maintain key accounting policies and procedures, including the design and implementation of internal controls. * Perform quarterly analytics to assess financial results and to improve financial processes that support the business. Desired Skills & Experience * Bachelor's Degree in Accounting (or equivalent) required; CPA preferred * Minimum of five (5) years of progressive accounting experience; public accounting experience a plus * SEC reporting experience and knowledge of US GAAP required * eCommerce industry knowledge preferred (or other fast-paced startup environment) * Experience with Workiva or other financial reporting software preferred What We Offer * Competitive compensation packages with a salary, bonuses, and restricked stock grants * Generous benefits, including three weeks of paid vacation, medical, dental, and vision insurance, and fully paid family leave * Strong startup culture with catered lunches, casual dress code, happy hours, and more To make sure we hire the most qualified people, we've designed a multi-step selection process which may include interviews, a homework assignment, and a reference check. We're excited to get to know you and hope you're ready to give this opportunity everything you've got! Redfin is an equal opportunity employer committed to hiring a diverse workforce. Redfin Seattle WA

Senior Reporting Analyst

City Of Seattle, WA