Senior Financial Report Developer and Administrator

Pay Competitive

Employment type:

Full-Time

Location: Portland, OR or US Remote
Valid unrestricted work authorization in the country in which you will be based (United States) is required at the time of application for this position.
Position Status: Full-time, Exempt, Regular
Salary Level: The salary range for this position is $76,000- $84,000 USD commensurate on experience.

Mercy Corps is powered by the belief that a better world is possible. To do this, we know our teams do their best work when they are diverse and every team member feels that they belong. We welcome diverse backgrounds, perspectives, and skills so that we can be stronger and have long-term impact.

The Finance Systems Team (FST) within the IT team is responsible for leading and coordinating the implementation of Mercy Corps' global financial accounting and reporting software. The team also provides technical user support and is responsible for developing and distributing certain financial reports.

The Senior Financial Report Developer and Administrator will help update the global financial reporting strategy and will define standards and processes for report development and distribution. The position will develop and maintain financial reporting templates in support of Mercy Corps' global financial software implementation, ensuring the accuracy and clarity of all financial reporting information. The position will manage the global distribution process for standard monthly reporting packages to country office locations worldwide as well as maintain the standardized reporting templates to support queries, transaction processing, and management information.

This position will assist with the implementation of reporting and analysis tools to expand and improve Mercy Corps' financial reporting capabilities and use of data.

• Define standards and processes for report template design, development, testing, and management.
• Develop and maintain standardized financial reporting templates for use with Mercy Corps' global financial software, Serenic Navigator, and report writing software, Jet Reports.
• Develop and maintain award-specific budget versus actual (BVA) reports for use by country programs in managing their awards based on specifications provided.
• Develop and maintain the standard set of internal financial management reports for country programs based on specifications.
• Develop ad hoc reports as necessary.
• Develop and maintain report template library and documentation of report specifications.

• Define standards and models for financial report distribution to and access by worldwide country programs and HQ country support teams.
• Administer financial report distribution and access models for worldwide country programs and HQ teams.
• Ensure the proper functioning of automated report distribution methods using the Jet Reports scheduler and other automated tools.
• Ensure timely distribution of country reporting packages and BVA reports, adhering to internal service level agreements.
• Institute and manage practice for archival of published reports.
• Maintain report catalog of all official reports for use by country and HQ teams.

• Test and evaluate new and changing report tool functionalities.
• Serve as resident expert of the reporting tools and provide technical support to other report developers.
• Plan and manage maintenance, including annual upgrades, of Jet Reports software.
• Support the evolution of reporting framework as Mercy Corps plans to build a data warehouse and implement Microsoft 365.
• Other duties as assigned or requested.

None

Reports Directly To: Finance Systems Manager
Works Directly With: FST members;
Finance teams;
Information Technology

Mercy Corps team members are expected to support all efforts toward accountability, specifically to our program participants, community partners, other stakeholders, and to international standards guiding international relief and development work. We are committed to actively engaging communities as equal partners in the design, monitoring and evaluation of our field projects.

• BA/S or equivalent in finance, accounting, computer or applied sciences or a relevant field is required.
• 5+ years of financial reporting experience in a medium to large organization, with an emphasis on management and analytical reporting is required.
• Experience designing financial reports using Excel-based software, Jet Reports is preferred.
• Demonstrated experience developing standards and processes for effective report management is required.
• Demonstrated experience and understanding of generally accepted accounting principles, financial reporting, accounting systems and structured accounting data, budget development and administration is…