Data Analyst, Global Finance Operations

The International Rescue Committee helps people, whose lives and livelihoods are shattered by conflict and disaster, to survive, recover, and gain control of their future. Founded in 1933 at the request of Albert Einstein, the IRC works with people forced to flee from war, conflict and disaster and the host communities that support them, as well as with those who remain within their homes and communities. At work today in over 40 countries and 25 U.S. cities, the IRC restores safety, dignity and hope to millions who are uprooted and struggling to endure.

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 Sr Data Analyst, 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

• Coordinating data to develop financial queries, templates, and reports to improve budgeting, forecasting and reporting processes

• With mentorship from the Sr Data Analyst and Director, Global Finance Operations, identifying and implementing solutions that meet the reporting and analysis needs of finance team members

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

• Crafting and building the Excel data automation tools using Power Query Editor

• Developing new Power BI reports

• Perform quality assurance on reports to ensure accurate data

• Implementing updates to maintain existing reports and tools

• Assist business users with using published reports and tools

Development Value

• Exposure to IRC leadership at a headquarters, regional and local level

• Acquire deep understanding of IRC’s business model, finances, and operations through data

• Advise colleagues to make informed organizational decisions with data and reports

Job Requirements

Work Experience:

• Bachelor’s degree in Data Analytics, Business, Finance, or Accounting

• 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 handle 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 organize time efficiently 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 relevant reports

• Understanding of dimensional modelling concepts

• Ability to research discrepancies between report outputs and user expectation

The IRC and IRC workers must adhere to the values and principles outlined in IRC Way - Standards for Professional Conduct. These are Integrity, Service, and Accountability. In accordance with these values, the IRC operates and enforces policies on Beneficiary Protection from Exploitation and Abuse, Child Safeguarding, Anti Workplace Harassment, Fiscal Integrity, and Anti-Retaliation.

Compensation:

Posted pay ranges apply to US-based candidates. Ranges are based on various factors including the labor market, job type, internal equity, and budget. Exact offers are calibrated by work location, individual candidate experience and skills relative to the defined job requirements.

COVID-19 Vaccination Requirement:

In accordance with IRC’s duty to provide and maintain a workplace that is free of known hazards and our commitment to safeguard the health of our employees, clients, and communities, IRC requires new hires to furnish proof of vaccination against COVID-19 in order to be considered for any in-office or hybrid positions. All IRC US offices require full vaccination to attend any in-office functions (e.g., meetings, trainings).

Commitment to Diversity and Inclusivity:

IRC is committed to building a diverse organization and a climate of inclusivity. We strongly encourage applications from candidates who can demonstrate that they can contribute to this goal.

Equal Opportunity Employer:

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.

US Benefits:

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 $145 per month, dental starting at $7 per month, and vision starting at $5 per month, FSA for healthcare, childcare, and commuter costs, a 403b retirement savings plans with up to 4.5% immediately vested matching contribution, plus a 3-7% base IRC contribution (3 year vesting), 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

#LI-REMOTE

Qualifications