Data Analytics Engineer

Job Posting Organization:
The International Rescue Committee (IRC) is a prominent humanitarian organization that was founded in 1933 at the behest of Albert Einstein. The IRC operates in over 40 countries and 29 U.S. cities, focusing on responding to the world's most severe humanitarian crises. The organization aims to restore health, safety, education, economic wellbeing, and empowerment to individuals affected by conflict and disaster. With a mission to deliver lasting impact, the IRC employs a diverse workforce dedicated to helping millions regain control over their lives and strengthen their communities. The IRC is recognized as one of the largest international non-governmental organizations (INGOs) and is committed to fostering a culture of integrity, service, equality, and accountability among its employees, ensuring that they adhere to professional standards and values.

Job Overview:
The Data Analytics Engineer position at the IRC is a critical role that involves designing, building, and maintaining the organization's analytics and data ecosystem. This position is essential for developing reliable and scalable data pipelines and analytics solutions that facilitate reporting, insights, and operational workflows across various departments. The successful candidate will be responsible for translating business needs into well-structured datasets and analytical outputs, utilizing tools from the Microsoft Power Platform, including Power BI, Power Apps, and Power Automate. The role requires a proactive approach to data modeling, transformation, and analytics engineering, with a strong emphasis on collaboration with both technical and non-technical stakeholders to ensure that analytics outputs are effectively utilized across the organization.

Duties and Responsibilities:
The Data Analytics Engineer will have a diverse set of responsibilities, including:

• Designing, building, and maintaining analytics-ready datasets and data models to support reporting, dashboards, and advanced analytics.
• Developing and optimizing data transformation logic to ensure that analytical outputs are both performant and reliable.
• Supporting the creation of curated analytics layers that enable consistent and reusable insights across teams.
• Troubleshooting and resolving data quality, performance, and pipeline issues that impact analytics delivery.
• Partnering with business and technical stakeholders to translate analytical requirements into datasets, metrics, and visualizations.
• Enabling downstream consumption of analytics outputs through reporting tools and dashboards.
• Supporting ad-hoc analysis and exploratory data needs as required.
• Enabling and supporting analytics-driven solutions built using Power BI, Power Apps, and Power Automate.
• Designing and maintaining data integrations that allow Power Platform solutions to efficiently consume analytics datasets. 1
• Collaborating with Power Platform developers to ensure that analytics outputs are structured and optimized for application and automation use cases. 1
• Assisting in troubleshooting data-related issues impacting Power Platform apps, flows, and reports. 1
• Working closely with cross-functional teams to improve analytics workflows and delivery processes. 1
• Contributing to the continuous improvement of analytics practices, performance, and usability. 1
• Documenting analytics solutions, datasets, and integration patterns to support maintainability and knowledge sharing. 1
• Writing and maintaining SQL-based data transformations and automated data quality tests to ensure data integrity. 1
• Mentoring junior team members and contributing to team knowledge development and technical growth.

Required Qualifications:
Candidates for the Data Analytics Engineer position must possess the following qualifications:

• A 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 that support enterprise analytics solutions.
• Advanced proficiency in SQL, including the use of Common Table Expressions (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.
• A 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.
• A strong understanding of data modeling, analytical datasets, and how analytics outputs are consumed by reporting tools and applications. 1
• Familiarity with Microsoft 365 and Azure Entra ID for secure access to analytics and Power Platform solutions. 1
• Experience collaborating with Power Platform developers to support analytics-driven apps, reports, and automations. 1
• Strong communication and teamwork skills, with the ability to explain analytical concepts to non-technical audiences. 1
• Experience supporting business users and analysts by enabling self-service analytics and data-driven innovation.

Educational Background:
The educational background required for the Data Analytics Engineer position includes a Bachelor’s degree in a relevant field such as Computer Science, Data Science, Information Systems, Statistics, or a related STEM discipline. Alternatively, candidates may qualify through an equivalent combination of education, certifications, and professional experience that demonstrates their capability in data analytics and engineering.

Experience:
The position requires candidates to have 3–5 years of relevant experience in data analytics engineering, analytics development, or similar roles that support enterprise analytics solutions. This experience should encompass a range of responsibilities related to data modeling, transformation, and analytics engineering, with a focus on delivering data-driven solutions.

Languages:
Professional working proficiency in English, both written and spoken, is mandatory for this position. This proficiency is essential for effective communication and collaboration within the organization and with external stakeholders. While English is the primary language required, familiarity with additional languages may be considered a plus, particularly in regions where the IRC operates.

Additional Notes:
The Data Analytics Engineer position is a full-time role that may involve collaboration with international teams, given the IRC's global presence. The organization is committed to creating a diverse and inclusive work environment and encourages applications from individuals of all backgrounds. Compensation and benefits details are not specified in the job ad, but candidates can expect a competitive package commensurate with their experience and qualifications. The IRC emphasizes the importance of professional standards and ethical conduct, and all employees are expected to adhere to the core values and principles outlined in the IRC Way - Standards for Professional Conduct.