Data Engineer (Chicago/Hybrid)

Work. Serve. Thrive.

Imagine a place where your talent can make a meaningful difference in peoples' lives. Working at Feeding America is a uniquely rewarding experience in which our employees work together as vital parts of a much larger mission. We are innovative, mission-focused, diverse, collaborative, values-driven and focused on results.

Feeding America is the nation's largest charity and the leading domestic hunger-relief charity in the United States. Our mission is to feed America's hungry through a nationwide network of member food banks and engage our country in the fight to end hunger.

Learn more about Feeding Americahere.

This is a hybrid position based out of Feeding America's Chicago office location. At Feeding America, we believe in offering a flexible work environment. Employees can be in the office an average of 2 days a week (when not travelling for work) and work from home on other days. Employees also have access to a 30-day "work anywhere" program during the course of each calendar year that can be combined with PTO and/or holidays.

The Opportunity

As a thought leader and highly skilled, hands-on Data Engineer, this role demands a deep understanding of data architecture, cloud technologies, and Structured Query Language (SQL), with a proven ability to translate business requirements into robust, scalable data solutions. Strategic thinker who can develop and execute a comprehensive data vision while also diving deep into the tactical aspects of data engineering.

Compensation

Here at FeedingAmerica national organization,equity is central to our mission andis an integral part of our compensation policies and structures. Historically, systemic racism and sexism in all aspects of our society, including compensation practices, has led to pay inequities that negatively impact people of color, women, and especially women of color. These practices include basing salary offers on previous compensation and negotiating salary offers. As such, we maintain transparent salary ranges and clearly defined practices for how our team, including new hire salary offers, moves through these ranges. You can expect us to offer the best salary up front based on these clearly defined pay practices with little room for negotiation. The salary range listed below represents the starting to mid-point salaries for positions and comparable roles at this level at our organization and candidates should expect to be offered a salary near the starting point of the range that is listed on the job posting. We make exceptions for highly experienced (multiple years of at-level experience) new hires in accordance with our pay practices. Once hired, employees have the opportunity to progress through salary ranges via regular merit increases and step promotions. Salary Range: $125,000 to $130,000 Based on Experience

Responsibilities:

1. Strategy and Leadership: Develop and implement a long-term data architecture strategy aligned with business objectives. Provide architectural direction to integration engineers to direct the future of architecture and data management for the organization.
2. Data Architecture: Design and optimize data models, schemas, and metadata to support complex data pipelines and analytical workloads.
3. Cloud Infrastructure: Leverage Azure cloud platform to build and maintain scalable data solutions. Proficiently utilize Azure cloud databases, data warehouses, and related services.
4. Data Engineering: Develop and execute ETL/ELT processes to efficiently extract, transform, and load data from various sources into target systems. Optimize data pipelines for performance and cost-effectiveness.
5. Data Management: Ensure data quality, integrity, and security through robust data governance practices. Implement data monitoring and alerting mechanisms to proactively identify and resolve data issues.
6. SQL Proficiency: Write complex SQL queries, stored procedures, and functions to analyze and manipulate large datasets. Optimize SQL code for performance and efficiency.
7. Collaboration: Partner with analysts, application development team, and business stakeholders to understand data requirements and translate them into technical solutions.
8. Problem Solving: Identify and resolve complex data challenges through innovative solutions. Conduct root cause analysis and implement corrective actions.

Required Experience and Qualifications:

• 10+ years of hands-on experience in data engineering and/or data warehousing, with a strong focus on SQL and cloud-based data platforms.
• 7+ years of experience building cloud data solutions (Azure, Google Cloud Platform).
• Expertise in Azure cloud platform, including Azure SQL Database, Azure Synapse Analytics, Azure Data Factory, and other relevant services; knowledge of data warehousing and data lake concepts. Familiarity with Informatica Intelligent Cloud Services (IICS), a plus.
• Strong problem-solving and analytical skills; proven ability to design and implement complex data architectures and pipelines; deploying end to end solutions with a cloud platform analytics services including storage, permissions, private cloud, database services, virtual machines, and parallel processing technologies.
• Strong SQL skills, including performance optimization techniques.
• Experience with data modeling, ETL/ELT processes, and data quality best practices.
• Ability to work independently and as part of a team
• Competent and proficient understanding of business tools and platforms. Working familiarity with SharePoint, Microsoft Office productivity tools, Tableau, a plus.

Foundational Requirements

• Mission Focused:Demonstrates a commitment to Feeding America's mission through work and action. Is committed to people keep people facing hunger at the center of our work and strives to translate this commitment into action on a daily basis. Willing to advocate for people facing hunger and serve as an ambassador for Feeding America inside and outside of work.
• Embraces Equity, Diversity and Inclusion:Demonstrates a personal commitment to valuing different background and life experiences through word and action. Takes personal actions to build an inclusive culture that ensures everyone can fully contribute based on their unique talents, skills and perspectives and feels welcomed and valued. Commits to driving equitable solutions to address root cause issues by incorporating an equity framework in their daily work. Committed to continuous personal EDI development.

Required Leadership Competencies:

• Drives Change: Offers suggestions for improving processes or change plans. Discusses concerns with leadership in a productive manner, then regardless of outcome, embraces changes. Reaches out to key stakeholders to understand their perspectives, overcome resistance, and gain buy-in. Speaks positively about changes and helps others understand how to be successful during times of change.
• Operates with Integrity:Builds trust by consistently operating with honesty, openness, and authenticity. Anchors actions and decisions in our mission. Consistently treats others with fairness, dignity, compassion, and respect. Demonstrates courage of convictions while respecting the views of others. Supports organization/department decisions in words and actions. Openly takes responsibility for mistakes, corrects them, and apologizes when appropriate and necessary.
• Understands our 'Business': Uses knowledge of how Feeding America and the not-for-profit services industry work to navigate the organization and get things done. Operates with an awareness of interdependencies between own department/team and others in the organization. Maintains knowledge of, and relationships with, key stakeholders external to the department.
• Collaborates Internally and Externally:Forms and sustains effective working relationships that accelerate goal achievement by reaching out to and engaging people from other functions or from outside the organization. Coordinates projects and plans with others within and outside of own area to ensure the work goes smoothly. Pursues networking opportunities and encourages others to form new relationships that benefit all parties. Handles conflict directly and adeptly, respecting all points of view, and resolves issues to create a united path forward.
  
• Communicates Effectively: Conveys clear and effective messages using verbal and written communication within individual, small group, and formal presentation settings. Communicates project/operating priorities and updates to key stakeholder audiences that may include staff, network food bank members, donors, and other groups. Responds positively to requests to share information while maintaining confidentiality of sensitive content. Adjusts message and content based on feedback provided.