ERP Data Analyst

**POSITION TITLE**

ERP Data Analyst

**POSITION LOCATION**

Ottawa preferred, Remote (Canada) available

**REPORTS TO**

Chief Financial Officer

**CONTRACT TERM**

Indeterminate

**SALARY**

77k - 87k

**APPLICATION DEADLINE**

**LANGUAGE REQUIRED**

Fluency in English is required, French an asset

**Are you a data-oriented professional with ERP experience, and interested in the world of international development? WUSC is currently looking for an ERP Data Analyst to provide support with a new system**

**BACKGROUND**

WUSC is a Canadian non-profit organization working to create a better world for all young people. We bring together a diverse network of students, volunteers, schools, governments, and businesses who share this vision. Together, we develop solutions in education, economic opportunities, and empowerment to overcome inequality and exclusion for youth around the world, particularly young women and young refugees. WUSC currently works in 25 countries across Africa, Asia, the Middle East, and the Caribbean, with an annual budget of approximately CAD $40 million. We have over 90 staff in our Ottawa office, and over 200 people overseas implementing 16 development projects in collaboration with donors such as Global Affairs Canada, the UK Department for International Development (DFID), the World Bank, the Asian Development Bank, the MasterCard Foundation, and the African Development Bank.

**RESPONSIBILITIES**

Under the supervision of the Chief Financial Officer, the ERP Data Analyst will be responsible for leading the way to a new ERP system, developing financial reporting capacities and appropriately managing and analyzing data related to finance and programming at WUSC.

More precisely, the ERP Data Analyst will have the following responsibilities:
**ERP**
- Work closely with employees at all levels to understand and document ERP business data, reporting needs and process workflows.
- Determine the requirements of organizational teams and the organization of a new solution
- Translate business requirements into a conceptual system design, including but not limited to business requirements document, high-level use cases and a business case
- Review and assess data requirements to design appropriate architecture for the ERP solution (GL structure, project structure, metadata, dimensions, etc)
- Lead the ERP RFP process including development of the formal request for proposal.
- In conjunction with the selected supplier, lead the new ERP implementation process
- Organize and participate in cross-functional meetings with various levels of management pertaining to workflow design and reporting.
- Lead the development of financial and other reporting from the new ERP system
- In consultation with various teams, identify needs and feasibility of integration of the ERP with other organizational systems, including Google and Salesforce
- Assists in User Acceptance Testing and System Integration Testing
- Providing technical support and training ERP end-users;
- Keep abreast of the latest ERP upgrades and offerings.
- Recommending changes in processes to improve efficiency based on analysis of data from system usage
- Document future state and final state process workflows pre and post implementation
- First line for users in resolving issues or questions related to their use of the ERP system, liaising with the vendor support for routine matters and escalating where required.
- Analyze issues that arise and assist users in determining the best course of action for any corrective measures to be taken, involving appropriate finance or other personnel where appropriate.
- Support the creation and maintenance of internal user documentation as required by software enhancements or updates.
- Maintains some of the system master files for financial-related items including GL accounts, financial statement formats, bank accounts, tax masters, etc.

**Financial Reporting**
- Creation of standardized reports using current ERP and financial reporting tools
- Creation of ad hoc reporting and analysis based on internal and external requirements
- Creation of dashboards to support management decision making
- Improve, automate and simplify existing reporting, and ensure it is clearly communicated to stakeholders
- Assessing requirements, scoping and implementation of an appropriate BI solution for use with current and future ERP
- Build effective forecasting models that provide clear answers to complex scenarios.
- Assist in the development of budgeting and forecasting through building templates and data analysis.
- Plan and conduct analysis of financial data, identify trends, provide assessment of existing and proposed financial plans and provide recommendations

**Program Data**
- Work closely with employees at all levels to document key project management and impact management processes and information flows.
- Work closely with employees to document existing stakeholders for information, including internal and ext