Data Engineer

Job Description

Background/IRC Summary

Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius – and a lot of courage – to move in the opposite direction." (Albert Einstein)

The International Rescue Committee responds to the world’s worst humanitarian crises and helps people to survive and rebuild their lives. Founded in 1933 at the request of Albert Einstein, the IRC offers lifesaving care and life-changing assistance to refugees forced to flee from war or disaster. At work today in over 40 countries and in 22 US cities, the IRC restores safety, dignity and hope to millions who are uprooted and struggling to endure. The IRC leads the way from harm to home.

The IT department supports the organization’s work by providing reliable and scalable applications and infrastructure for the IRC’s offices in the US and around the world, including many technologically challenging locations.

Job Overview/Summary

The Data Engineer will be responsible for the implementation, configuration, maintenance, and performance of key data technologies including Data Integrations, ETL/ELT, Data Lakes, Databases, and Data Marts and Warehouses to ensure availability and consistent performance. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills.

The successful candidate will be responsible for the development and maintenance of the SQL Servers and Data Warehouse on-prem and Cloud environment, ensuring its operational readiness (security, health, and performance), executing data loads, and performing data modeling in support of multiple domains. Must be capable of working independently and collaboratively.

Major responsibilities

· Write and maintain T-SQL, Python scripts and ETL pipelines

· Research and deploy data technologies in support of strategic organizational data needs

· Develop databases, data warehouses, and ETL processes on-prem and Cloud environments

· Apply data modeling techniques to ensure development and implementation support efforts meet business needs and performance expectations

· Manage SQL Server databases on-prem or Cloud environments through multiple product lifecycle, from development to mission-critical production systems

· Monitor and troubleshoot performance issues related to SQL queries, ETL processes or Database Systems

· Monitor and evaluate SQL Servers performance, to ensure high levels of performance, availability, and security

· Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end

· Refine and automate regular processes, track issues, and document changes

· Assist developers with complex query tuning and schema refinement

· Provide 24x7 support for critical production systems.

· Perform scheduled maintenance and support release deployment activities after hours.

· Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

Required Skills

- Humanitarian first mindset - Positive outlook and compassionate communications - Ability to lead and be flexible to change course through ambiguity and change

· 5+ years’ experience as data engineer, data developer or data administrator (Required)

· 5+ years of writing complex SQL code

· 1+ years of writing one of these codes: Python, JAVA, R, C#, or Scala (Preferred Python)

· In depth knowledge of data warehousing and ETL processes

· Preferred Azure Cloud experience

· Experience with Azure data technologies, such as Data Factory, Data Lake, Azure Synapse

· Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools

· Excellent written and verbal communication

· Flexible, team player, “get-it-done” personality

· Ability to organize and plan work independently

· Ability to work in a rapidly changing environment

· Ability to multi-task and context-switch effectively between different activities and teams

· Azure Microsoft certifications a plus

Working Environment

- Standard office working environment. - Some international travel as needed.

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.

IRC et les employés de IRC doivent adhérer aux valeurs et principes contenus dans le IRC WAY (normes de conduite professionnelle). Ce sont l’Intégrité, le Service, et la Responsabilité. En conformité avec ces valeurs, IRC opère et fait respecter les politiques sur la protection des bénéficiaires contre l’exploitation et les abus, la protection de l’enfant, le harcèlement sur les lieux de travail, l’intégrité financière, et les représailles.

#LI-GR1

Qualifications