Data Analytics Engineer

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.

We are seeking a skilled and proactive Data Analytics Engineer to design, build, and maintain our organization’s analytics and data ecosystem, while supporting data-driven solutions built on the Microsoft Power Platform. This role is critical to delivering reliable, scalable data pipelines and analytics solutions that support reporting, insights, and operational workflows across departments.

The successful candidate will have hands-on experience in data modeling, transformation, and analytics engineering, strong SQL proficiency, Python scripting skills, and the ability to collaborate effectively with both technical and non-technical stakeholders. They will translate business needs into well-structured datasets, analytical outputs, and Power Platform solutions such as Power BI, Power Apps, and Power Automate that leverage analytics outputs.

Major Responsibilities:

Core Analytics & Data Engineering
•    Design, build, and maintain analytics-ready datasets and data models to support reporting, dashboards, and advanced analytics.
•    Develop and optimize data transformation logic to ensure performant and reliable analytical outputs.
•    Support the creation of curated analytics layers that enable consistent and reusable insights across teams.
•    Troubleshoot and resolve data quality, performance, and pipeline issues impacting analytics delivery.

Analytics & Reporting Enablement
•    Partner with business and technical stakeholders to translate analytical requirements into datasets, metrics, and visualizations.
•    Enable downstream consumption of analytics outputs through reporting tools and dashboards.
•    Support ad-hoc analysis and exploratory data needs as required.
Power Platform Enablement (Secondary Scope)
•    Enable and support analytics-driven solutions built using Power BI, Power Apps, and Power Automate.
•    Design and maintain data integrations that allow Power Platform solutions to consume analytics datasets efficiently.
•    Collaborate with Power Platform developers to ensure analytics outputs are structured and optimized for application and automation use cases.
•    Assist in troubleshooting data-related issues impacting Power Platform apps, flows, and reports.

Collaboration & Continuous Improvement
•    Work closely with cross-functional teams to improve analytics workflows and delivery processes.
•    Contribute to continuous improvement of analytics practices, performance, and usability.
•    Document analytics solutions, datasets, and integration patterns to support maintainability and knowledge sharing.
•    Write and maintain SQL-based data transformations and automated data quality tests to ensure data integrity.
•    Mentor junior team members and contribute to team knowledge development and technical growth.

Job Requirements: 

Education: Bachelor’s degree in Computer Science, Data Science, Information Systems, Statistics, or a related STEM field; or an equivalent combination of education, certifications, and professional experience.

•    3–5 years of experience in data analytics engineering, analytics development, or related roles supporting enterprise analytics solutions.
•    Advanced SQL proficiency, including CTEs, window functions, complex joins, and query performance optimization.
•    Proficiency in Python for data manipulation, pipeline scripting, and automation tasks.
•    Experience with Git version control for collaborative development and code management.
•    Experience designing and maintaining ETL/ELT pipelines and data warehouse solutions.
•    Strong understanding of data warehousing concepts, dimensional modeling, and star/snowflake schema design.
•    Hands-on experience working with Power BI and integrating analytics datasets into Power Apps and Power Automate solutions.
•    Strong understanding of data modeling, analytical datasets, and how analytics outputs are consumed by reporting tools and applications.
•    Familiarity with Microsoft 365 and Azure Entra ID for secure access to analytics and Power Platform solutions.
•    Experience collaborating with Power Platform developers to support analytics-driven apps, reports, and automations.
•    Strong communication and teamwork skills, with the ability to explain analytical concepts to non-technical audiences.
•    Experience supporting business users and analysts by enabling self-service analytics and data-driven innovation.
•    Certifications such as (preferred but not required):
•    Microsoft Certified: Power BI Data Analyst Associate
•    Microsoft Certified: Azure Data Engineer Associate
•    Microsoft Certified: Power Platform Functional Consultant Associate
•    dbt Analytics Engineering Certification

Language Skills:  Professional working proficiency in English (written and spoken).

Preferred experience & skills: 
•     Advanced experience designing and optimizing Power BI datasets and enterprise reporting models
•     Experience integrating analytics outputs into Power Apps and Power Automate solutions
•     Working knowledge of Azure data services and cloud-based analytics platforms
•     Experience implementing data security, access controls, and governance best practices
•     Familiarity with DevOps or structured release management for analytics solutions
•     Ability to translate business needs into scalable analytics designs
•     Ability to balance technical depth with user-centered solution design
•     Ability to collaborate across technical and non-technical teams
•     Ability to influence decisions through data and structured reasoning
•     Ability to prioritize competing demands in fast-moving environments
•     Ability to simplify complex analytical concepts for diverse audiences
•     Ability to continuously improve analytics processes and standards
•     Strong ownership mindset and accountability for solution outcomes
•     Experience with dbt (data build tool) or similar SQL-based transformation frameworks
•     Experience implementing automated data quality testing and validation frameworks
•     Familiarity with data pipeline orchestration tools (e.g., Apache Airflow, Dagster)
•     Familiarity with machine learning concepts and AI-assisted data workflows

PROFESSIONAL STANDARDS

All International Rescue Committee workers must adhere to the core values and principles outlined in IRC Way - Standards for Professional Conduct. Our Standards are Integrity, Service, Equality and Accountability. In accordance with these values, the IRC operates and enforces policies on Safeguarding, Conflicts of Interest, Fiscal Integrity, and Reporting Wrongdoing and Protection from Retaliation. IRC is committed to take all necessary preventive measures and create an environment where people feel safe, and to take all necessary actions and corrective measures when harm occurs. IRC builds teams of professionals who promote critical reflection, power sharing, debate, and objectivity to deliver the best possible services to our clients.

Cookies: https://careers.rescue.org/us/en/cookiesettings

#li-1