Senior Data and Reporting Analyst

Location: Portland, OR; Washington D.C.; or US Remote

Position Status: Full-time, Exempt, Regular

Salary Level: US Starting Salary for this role will be USD $64,000 to $76,000 commensurate on experience.

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.      

About Mercy Corps

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.

Department Summary

The People Team ensures that Mercy Corps attracts, develops, and retains the best global talent who will enable it to be a world-class, cutting edge, humanitarian organization, creating transformational change in the world. Our aim is to drive strategic thinking and planning at all levels of the organization; create a talent management framework that supports team members achieve their highest potential, drive people practice that promote the organizational culture. To achieve this, we align conversations on developing team members and leaders; enhance team member experience with HR services; keep the organization focused on what has the greatest impact; leverage our comparative advantages in the crowded and competitive international relief and development landscape; and assure we are constantly learning from our work and the external environment.

Position Summary

The Senior Data and Reporting Analyst – People Systems will support the development, resourcing, and execution of a long-term data and reporting strategy for the global People team. The goal is to report on and analyze the employee life cycle and elevate the use of and be the ambassador or people data in decision making. This will be accomplished through the implementation of the data strategy created by the People Systems and Analytics Director. This encompasses data definitions, data cleanse and data use and optimization. The focus will include the design and development of reports, data visualizations, integrations, and data quality improvements using tools including UKG Cognos, Jobvite Analytics, and Power BI. This role involves ongoing and focused engagement with stakeholders globally to analyze business processes and gather requirements. In addition to the technical aspects, this role will lead training and engagement efforts to elevate organizational understanding and utilization of People data.

Essential Responsibilities:

PEOPLE DATA AMBASSADOR

• Support the implementation of the holistic global people data and reporting strategy that contributes to organizational and People team goals.
• Identify and include enhancements to the people data strategy.
• Be an ambassador of people data and reporting across the agency.
• Partner with the Data Reporting & Analytics team, developing strength in knowledge of complex data and systems topics, functional reporting and analysis capabilities, and stakeholder engagement skills.
• Build relationships and partner with global/agency wide teams to assess what the needs, opportunities, and challenges are and how people data can support. 

BUSINESS ANALYSIS AND ENGAGEMENT

• Work with global teams to help them identify the questions they want to answer and problems they want to solve using People data.
• Analyze business processes and systems, identifying opportunities to improve data quality and integrity through system configuration and user training.
• Design and monitor engagement, communications, and training efforts to increase organizational understanding and utilization of People data.
• Update, enhance and maintain internal documentation, user guides, and training content related to data and reporting within people systems.
• Develop a suite of training assets in line with strategic goals in partnership with System Admin & Operations function (guides, manuals, videos, etc.).
• Supports system admins and end users on newly implemented functional and ongoing process improvements. 

REPORT DEVELOPMENT & ANALYSIS

• Oversee the development and maintenance of People data reports that identify trends throughout the employee lifecycle, including but not limited to recruitment, onboarding, internal movement, performance, turnover, and diversity & inclusion.
• Partner with the People Systems and Analytics Team, subject matter experts, and system vendors to design and develop data, integration, and reporting products 
• Partner with PSTA Director to develop and improve complex reports in UKG Cognos that meet stakeholder requirements, with a focus on solutions that can be consistently produced on demand and that can track key metrics over time.
• Develop and improve data visualizations and dashboards directly in UKG Cognos and external tools including Power BI.
• Manage data conversion and systems integration (extraction, transformation, load, validation).
• Manage the configuration, testing, and deployment of reporting and business intelligence capabilities based on approved designs in collaboration with partner systems admins, SMEs, and IT. 

PRODUCTION SUPPORT

• Oversee the intake and prioritization of report requests in Jira, defining and maintaining criteria and service level agreements for the development of new reports.
• Coordinate resolution of system and report defects with the People Systems team, other system owners, and external vendors
• Provide support to the broader People Systems team for system support requests during high volume periods.

SYSTEM/DATA SECURITY AND PRIVACY

• Maintain integrity for the privacy and security of people's data, identifying risks and creating structures and safeguards to protect team member information.
• Maintain compliance with security procedures and policies as determined by IT and operational leadership.
• Implement improvements to people data security, privacy, and retention policies and procedures 
• Develop user guides and training materials on the proper access and use of People systems and data with knowledge of data protection laws across the countries we operate.

SAFEGUARDING RESPONSIBILITIES

• Actively learns about safeguarding and integrates it into their work, including safeguarding risks and mitigations related to their area of work
• Practices the values of Mercy Corps including respecting the dignity and well-being of participants and fellow team members
• Encourages openness and communication in their team; encourages team members to submit reports if they have any concerns using reporting mechanisms e.g., Integrity Hotline and other options

Supervisory Responsibility

The Senior Data and Reporting Analyst has no supervisory responsibilities.

Accountability 

Reports Directly To: Director - People Systems and Analytics

Works Directly With: People Team Leaders, All Country HR Teams, Strategy and Learning, Finance, IT, PSAT Managers, UKG 

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 

• Bachelor’s degree in Human Resources, Information Systems, Business Administration, or a related field.
• 4+ years of professional experience in process analysis and/or systems implementation in a global analyst role.
• 3+ years of experience in reporting, information analysis, and problem-solving within an HR and/or systems environment.
• Experience in UKG Pro, Jobvite, Informatica, or Cognos BI is required.
• International/multi-country/continent HCM experience is strongly preferred.
• Experience with an HR, recruiting, or learning management system is preferred.
• Demonstrated experience in enhancing data strategy and implementing data strategies.
• Proven history of strong stakeholder and vendor management.
• Proven history of providing excellent customer service.
• Ability to communicate with technical and non-technical users, and an understanding of cloud-based applications, data governance, and BI are required.
• English fluency is required.
• Ability to follow procedures, complete tasks with high-quality outputs, meet deadlines, and work cooperatively with team members.
• Effective organizational and interpersonal skills; strong written and verbal communication.
• Experience or certification in project management is a plus.
• Proficiency in SQL, C# or JavaScript is a plus.

Success Factors 

A successful candidate will be able to support technical and non-technical stakeholders towards effective data driven decision making.  They will be action-oriented, adaptable, results-driven, and comfortable with change. The Senior Data and Reporting Analyst will be able to meet deadlines through strong organizational skills, attention to detail and the ability to successfully manage multiple priorities and tasks while having an even temper, a problem-solving attitude, and the ability to maintain positive relationships under difficult or heated circumstances. 

A successful Senior Data and Reporting Analyst can demonstrate a strong ability to develop and oversee an array of diverse analysis works and reporting projects with the aim of delivering successful business outcomes. They can influence, energize, and motivate others, regardless of position. An authentic passion for work is important along with a resilient spirit and ability to gracefully deal with adversity and ambiguity, making sense out of chaos. They should have the comfort and ability to interact with senior leaders, team members from different backgrounds and countries, a sense of humor is always appreciated.