Data Analyst, Global Finance Operations

The International Rescue Committee (IRC) responds to the world's worst humanitarian crises, helping to restore health, safety, education, economic wellbeing, and power to people devastated by conflict and disaster. Founded in 1933 at the call of Albert Einstein, the IRC is one of the world's largest international humanitarian non-governmental organizations (INGO), at work in more than 40 countries and 29 U.S. cities helping people to survive, reclaim control of their future and strengthen their communities. A force for humanity, IRC employees deliver lasting impact by restoring safety, dignity and hope to millions. If you're a solutions-driven, passionate change-maker, come join us in positively impacting the lives of millions of people world-wide for a better future.Job OverviewThe 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 ResponsibilitiesCoordinating data to develop financial queries, templates, and reports to improve budgeting, forecasting and reporting processesWith mentorship from the Sr Data Analyst and Sr. Director, Global Finance Operations, identifying and implementing solutions that meet the reporting and analysis needs of finance team membersWorking with business users, solutions architects, and business analysts to understand the requirements for reportsCrafting and building the Excel data automation tools using Power Query EditorDeveloping new Power BI reportsPerform quality assurance on reports to ensure accurate dataImplementing updates to maintain existing reports and toolsAssist business users with using published reports and toolsDevelopment ValueExposure to IRC leadership at a headquarters, regional and local levelAcquire deep understanding of IRC’s business model, finances, and operations through dataAdvise colleagues to make informed organizational decisions with data and reportsJob RequirementsWork Experience: Bachelor’s degree in Data Analytics, Business, Finance, or AccountingData analytics or finance experience creating reports with Power BI, using a variety of data sources (SQL, Excel, Power BI Datasets, dataflows)Demonstrated Skills And CompetenciesAbility to handle and manipulate large data setsHighly skilled with Microsoft ExcelCoding knowledge and experience querying databases (SQL, DAX, M Language)Good communication skills to collaborate with team and business users to develop new reports and toolsGood analytical and problem-solving skillsAbility to work independently and organize time efficiently to meet project deadlinesPreferred Experience And SkillsExperience with the MS SQL Server, Microsoft Power BI Suite including DAX, Power Query (M Language), Power Platform (Power Apps & Power Automate), Data Model integration with ExcelExperience with data preparation and transformationKnowledge of relational data modelling conceptsAbility to translate raw data from various sources into relevant reportsUnderstanding of dimensional modelling conceptsAbility to research discrepancies between report outputs and user expectationThe 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.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.Standard of Professional Conduct: The IRC and the IRC workers must adhere to the values and principles outlined in the IRC Way – our Code of Conduct. These are Integrity, Service, Accountability, and Equality.Cookies: https://careers.rescue.org/us/en/cookiesettings