Title: Data Engineer

Employee Status: Full Time-Exempt

Salary: Grade 5

Starts at $81,200 | Chicago

Reports to: Senior Vice President of Strategic Insights & Chief Data Officer

Department: Social Impact Accelerator-Strategic Insights

Location: Chicago, IL

Department Function: The Social Impact Accelerator (SIA) develops and implements processes, systems, and structures to facilitate, coordinate, and hold IFF accountable for equity in practice, cross-functional collaboration, innovation, scaling of impact, and systems change. SIA comprises five interdependent functions: Strategic Insights; Strategic Response; Organizational Learning; Sector-Based Strategy; and Equity, Diversity, and Inclusion. Strategic Insights leads IFF’s knowledge gathering and sense-making and stewards a data-informed culture by growing, developing and nurturing IFF’s data assets and supporting data-informed decision making and strategy for IFF, as well as our customers and the communities we serve.

The Organization

IFF is a mission-driven lender, real estate consultant, and developer that helps communities thrive. Key to our success has been a deep sense of purpose, a broad perspective, and a relentless focus on achieving positive results. Across the Midwest we help clients from every sector, including human service agencies, health centers, schools, affordable housing developers, and healthy food grocery operators. Staff contribute extensive business experience and an unrivaled connection to the mission of IFF to the clients we serve.

IFF is looking for candidates with a commitment to the work we do who can demonstrate their creativity, diligence, enthusiasm, growth-mindset, thoughtfulness, and passion to make meaningful change in the areas of economic and racial justice.

Equity, Diversity, and Inclusion

Partnering to create thriving communities is at the heart of everything we do. We leverage knowledge, capital, and resources to advance equitable and transformational outcomes in under-resourced communities, guided by our commitment to be an inclusive, anti-racist and anti-oppressive institution that honors communities as asset-rich and as experts in their own stories.

Basic Job Function

The Data Engineer is responsible for creating, maintaining, and supporting synchronization of data both across core business applications and between those applications and data warehouses.

Job Duties and Responsibilities:

1. Collaborates with Data Architect and Chief Data Officer to select vendors/products/methods for data integration and synchronization.
2. Build and execute ETL processes from multiple, disparate data sources such as flat files, web services/APIs, databases, etc.
3. Develop and deploy data pipelines using Python, Fivetran, and Microsoft Azure (Synapse, SQL Server, etc…) best practices.
4. Creates, manages, and maintains pipelines necessary to achieve error-free data integration/synchronization, both across core business applications and between those applications and data warehouses.
5. Provides training and support for IFF technical staff regarding data integration and synchronization.
6. Receives and resolves escalated incident reports involving data integration and synchronization.
7. Assists Applications Administrator and Data Architect, as needed.
8. Performs related duties, as required.

Performance Measures:

1. Ensures error-free data integration/synchronization across core business applications and between those applications and data warehouses.
2. Cultivates a culture of openness in information sharing. Encourages open communication, cooperation, and the sharing of knowledge.
3. Models personal accountability that promotes ownership and engagement.
4. Builds and maintains effective working relationships with colleagues, peers and team members.
5. Values and supports differences in others, contributing to an inclusive work environment. Demonstrates the ability and willingness to communicate effectively with people of diverse backgrounds and experiences to create a collaborative, collegial, and caring community.
6. High level of satisfaction with both internal colleagues and external contacts.

Position Qualifications:

Education: Bachelor’s Degree required in computer science, engineering, or applied mathematics. Or equivalent experience in a similar position. Highly proficient programmer, particularly as it relates to API coding, data integration, and data synchronization.

Previous Experience: Two years of experience in data engineering, or a closely related field. Experience with Microsoft Azure, Amazon Web Services, or Google Cloud Services strongly preferred.

Additional Requirements: Occasional evening and weekend work.

IFF does not offer the following:

• relocation package
• 100% remote
• provide sponsorship to applicants who require or will require a work permit.

Check off only some boxes in the requirements listed above. Studies have shown that marginalized communities - such as women, LGBTQ+ and people of color - are less likely to apply to jobs unless they meet every qualification. So, if you're excited about this role, we encourage you to apply.

Application Instructions: Please visit the Careers section of our website to apply online. Both a resume and cover letter are required.

IFF values equity, diversity, and inclusion as part of its mission to strengthen nonprofits and the communities they serve. IFF is an equal opportunity employer and is committed to building and maintaining a culturally diverse workplace that is free of discrimination and harassment of any kind. We encourage women, minorities, individuals with disabilities and veterans to apply. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, sexual orientation, gender identity, age, veteran status, or any other status protected by the laws or regulations in the locations where we operate.