Data Analyst, Global Finance Operations

Job Overview:

The Data Analyst, Global Finance Operations, is part of the Global Finance Operations team that is responsible for providing technical solutions and improvements to the IRC’s global finance function.

The Data Analyst will provide technical support on data management and solutions to enable IRC’s budget, forecasting and management reporting processes, and will be responsible for the creation of Power BI reports and building data automation tools in Excel (with Power Query Editor). The Data Analyst will report to the Director, Global Finance Operations and will work closely with other teams from across Finance and the entire organization to deliver data automation tools (reports, templates and models) to manage budget and reporting requirements.

A qualified candidate has experience in Power BI, DAX, Power Query, Excel and a background in data analytics and business intelligence.

Major Responsibilities:

·Organizing data to develop financial queries, templates, and reports to improve budgeting, forecasting and reporting processes

·With guidance from the Director, Global Finance Operations, identifying and implementing solutions that meet the reporting and analysis needs of finance stakeholders

·Working with business users, solutions architects, and business analysts to understand the requirements for reports

·Designing and building the Excel data automation tools using Power Query Editor

·Creating new Power BI reports

·Perform quality assurance on reports to ensure correct data

·Implementing updates to maintain existing reports and tools

·Assist business users with using published reports and tools

Job Requirements:

Work Experience:

·Bachelor’s degree in Data Analytics, Business or Finance

·2+ years of data analytics or finance experience creating reports with Power BI, using a variety of data sources (SQL, Excel, Power BI Datasets, dataflows)           

Demonstrated Skills and Competencies:

·Ability to manage and manipulate large data sets

·Highly skilled with Microsoft Excel;

·Coding knowledge and experience querying databases (SQL, DAX, M Language)

·Good communication skills to collaborate with team and business users to develop new reports and tools

·Good analytical and problem-solving skills

·Ability to work independently and manage time effectively to meet project deadlines

Preferred Experience and Skills:

·Experience with the MS SQL Server, Microsoft Power BI Suite including DAX, Power Query (M Language), Data Model integration with Excel

·Experience with data preparation and transformation

·Knowledge of relational data modelling concepts

·Ability to translate raw data from various sources into meaningful reports

·Understanding of dimensional modelling concepts

·Ability to research discrepancies between report outputs and user expectations

IRC et les employés de IRC doivent adhérer aux valeurs et principes contenus dans le IRC WAY (normes de conduite professionnelle). Ce sont l’Intégrité, le Service, et la Responsabilité. En conformité avec ces valeurs, IRC opère et fait respecter les politiques sur la protection des bénéficiaires contre l’exploitation et les abus, la protection de l’enfant, le harcèlement sur les lieux de travail, l’intégrité financière, et les représailles. 

We offer a comprehensive and highly competitive set of benefits.  In the US, these include: 10 sick days, 10 US holidays, 20-25 paid time off days depending on role and tenure, medical insurance starting at $120 per month, dental starting at $7 per month, and vision starting at $5 per month, FSA for healthcare and commuter costs, a 403b retirement savings plans with immediately vested matching, disability & life insurance, and an Employee Assistance Program which is available to our staff and their families to support counseling and care in times of crisis and mental health struggles.

#LI_GR1