Data Engineer

Develop and optimize data infrastructure for analytics needs

This opening is not available anymore. Do not try to apply for this job.

IRC - The International Rescue Committee

Open positions at IRC
Logo of IRC

Overview

Develop and optimize data infrastructure for analytics needs

You have:

  • Demonstrated ability writing SQL scripts
  • Some experience with Python
  • Exposure to Databricks is a significant advantage
  • Experience working in a cloud environment
  • Experience with DBT Core or DBT Cloud is a major plus
  • Ability to quickly learn and absorb existing and new data structures
  • Excellent interpersonal and communication skills (both written and verbal)
  • Ability to work independently and collaboratively within a team

Technology and Operations supports the organization’s work by providing reliable and scalable solutions for the IRC’s offices around the world. The Data Team at IRC is responsible for the design and delivery of global data strategy and the systems and products that deliver on it.

Job Summary:

The Data Engineer will play a pivotal role in the development, maintenance, and optimization of our data infrastructure, focusing on data integration, ETL/ELT processes, and management of Data Warehouses, and Lakehouse.

The successful candidate will be responsible for building and maintaining data pipelines using Databricks, Synapse, and Fabric environments, using tools like DBT and Databricks pipelines. Key responsibilities include ensuring system readiness in terms of security, performance, and health, completing data loads, and implementing data modeling to support various business domains. This hands-on role demands strong technical expertise alongside excellent communication and collaboration skills.

Major Responsibilities:

1. Develop Python, SQL, and PySpark-based applications and data flows within Databricks.

2. Build and maintain data pipelines using DBT and Databricks, ensuring efficient and scalable data processes.

3. Design and implement real-time and batch data processing systems to support analytics, reporting, and business needs.

4. Monitor and analyze data pipelines for performance, reliability, cost, and efficiency.

5. Proactively address any issues or bottlenecks to ensure smooth operations.

6. Discover opportunities for process improvements, including redesigning pipelines and optimizing data delivery mechanisms.

7. Manage and maintain Azure cloud services and monitor alerts to ensure system availability and performance.

Minimum Requirements:

• Demonstrated ability writing SQL scripts (required).

• Some experience with Python (strong plus).

• Exposure to Databricks is a significant advantage.

• Experience working in a cloud environment (strong plus).

• Experience with DBT Core or DBT Cloud is a major plus.

• Ability to quickly learn and absorb existing and new data structures.

• Excellent interpersonal and communication skills (both written and verbal).

• Ability to work independently and collaboratively within a team.

Preferred Additional Requirements

• Experience with cloud platforms (Azure preferred).

• Databricks Data Engineer Certification or similar.

• Software development

Key Working Relationships:

• Data Team

• Enterprise systems owners and technical and analytics teams under their leadership

Position Reports to: Data Architect

Position Supervises: None

Travel Requirements:

• Special projects may require travel to facilitate hands-on learning that will contribute to our data strategy efforts.

Working Environment:

• Remote. Location is flexible but must be within an approved IRC country of operation.

Compensation:

Posted pay ranges apply to UK-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.

#LI-6 #LI-HYBRID

Qualifications

Potential interview questions

Can you describe a challenging data pipeline you worked on? This assesses your problem-solving skills in data engineering. Detail the project, your specific contributions, and the outcome.
How do you ensure the security and performance of data pipelines? The interviewer wants to know your approach to data integrity and efficiency. Pro members can see the explanation.
What experience do you have with cloud platforms, specifically Azure? Pro members can see the explanation. Pro members can see the explanation.
Can you explain how you would design a batch data processing system? Pro members can see the explanation. Pro members can see the explanation.
Describe a time you optimized a process and the impact it had. Pro members can see the explanation. Pro members can see the explanation.
Added 1 year ago - Updated 1 year ago - Source: rescue.org