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 Team
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 Position
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.
Essential Responsibilities
REPORT DEVELOPMENT AND MAINTENANCE
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.
REPORT DISTRIBUTION AND ACCESS
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.
OTHER
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.
Supervisory Responsibility
None
Accountability
Reports Directly To: Finance Systems Manager
Works Directly With: FST members; Finance teams; Information Technology
Accountability to Participants and Stakeholders
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.
Minimum Qualification & Transferable Skills
BA/S or equivalent in finance, accounting, computer or applied sciences or a relevant field is required
5+ 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 required.
Effective spoken and written communication, analytical, organizational and prioritization skills
Highly advanced Microsoft Excel skills
Experience with not-for-profit fund accounting, grant management reporting, and foreign currencies is preferred.
Experience with sophisticated implementation of Microsoft 365, specifically Sharepoint and Teams is preferred
Experience with Adaptive Insights, Sequel Server Reporting Services, and business intelligence tools is preferred.
Success Factors
This position requires initiative, curiosity, attention to detail and process, a zeal for accuracy, and a solid understanding of structured accounting data and construction of financial reports. This position also requires an ability to design and implement business standards and processes to manage report development, maintenance, and distribution, with a focus on internal controls. The successful candidate must be a highly organized self-starter with the ability to communicate clearly and to meet deadlines. Candidate must be able to initiate and maintain positive relationships with business owners on Finance and IT teams. Heavy collaboration and coordination with the business owners means that the ability to work well on a team is crucial to success in this position, alternately leading and following teams when appropriate, always contributing. The successful candidate will be actively committed to the continual advancement of Mercy Corpsโ financial data and reporting systems.
Living Conditions / Environmental Conditions
The position is based in Portland, Oregon. Other work-from-home locations in the U.S. may be considered.
Ongoing Learning
In support of our belief that learning organizations are more effective, efficient and relevant to the communities we serve, we empower all team members to dedicate 5% of their time to learning activities that further their personal and/or professional growth and development
Diversity, Equity & Inclusion
Achieving our mission begins with how we build our team and work together. Through our commitment to enriching our organization with people of different origins, beliefs, backgrounds, and ways of thinking, we are better able to leverage the collective power of our teams and solve the worldโs most complex challenges. We strive for a culture of trust and respect, where everyone contributes their perspectives and authentic selves, reaches their potential as individuals and teams, and collaborates to do the best work of their lives.
We recognize that diversity and inclusion is a journey, and we are committed to learning, listening and evolving to become more diverse, equitable and inclusive than we are today.
Equal Employment Opportunity
Mercy Corps is an equal opportunity employer that does not tolerate discrimination on any basis. We actively seek out diverse backgrounds, perspectives, and skills so that we can be collectively stronger and have sustained global impact.
We are committed to providing an environment of respect and psychological safety where equal employment opportunities are available to all. We do not engage in or tolerate discrimination on the basis of race, color, gender identity, gender expression, religion, age, sexual orientation, national or ethnic origin, disability (including HIV/AIDS status), marital status, military veteran status or any other protected group in the locations where we work.
Safeguarding & Ethics
Mercy Corps is committed to ensuring that all individuals we come into contact with through our work, whether team members, community members, program participants or others, are treated with respect and dignity. We are committed to the core principles regarding prevention of sexual exploitation and abuse laid out by the UN Secretary General and IASC. We will not tolerate child abuse, sexual exploitation, abuse, or harassment by or of our team members. As part of our commitment to a safe and inclusive work environment, team members are expected to conduct themselves in a professional manner, respect local laws and customs, and to adhere to Mercy Corps Code of Conduct Policies and values at all times. Team members are required to complete mandatory Code of Conduct elearning courses upon hire and on an annual basis.
As a safeguarding measure, Mercy Corps screens all potential US-Based employees. This is done following the conclusion of recruitment and prior to assuming full employment.
Our screening process is designed to be transparent and completed in partnership with new Team Members. You will have the opportunity to disclose any prior convictions at the conclusion of the recruitment process before the check is initiated. We ask that you do not disclose any prior convictions in your application materials or during the recruitment process.
Covid-19 Vaccine Policy for US-Based Employees
Mercy Corps has determined that, in an effort to protect the health, safety, and well-being of all Mercy Corps employees working in the United States, all U.S.-based employees must be fully vaccinated for COVID-19, regardless of prior COVID-19 infection status. This policy is necessary to ensure not only the safety of our workforce, but the ongoing functionality of the organization.
This policy will be revised as needed to comply with federal, state, and local requirements, and to respond to changing guidance from public health authorities.
For new employees this requirement goes into effect within 10 business days of employment. Team members that travel are expected to comply with host-country requirements, including vaccinations. Failure to comply may impact your employment. Proof of vaccination or exemption must be provided.