Senior Data Engineer, IT Enterprise Solutions

The Foundation

We are the largest nonprofitfighting poverty, disease, and inequity around the world. Founded on a simple premise: people everywhere, regardless of identity or circumstances, should have the chance to live healthy, productive lives. We believe our employees should reflect the rich diversity of the global populations we aim to serve. We provide an exceptional benefits package to employees and their families which include comprehensive medical, dental, and vision coverage with no premiums, generous paid time off, paid family leave, foundation-paid retirement contribution, regional holidays, and opportunities to engage in several employee communities. As a workplace, we're committed to creating an environment for you to thrive both personally and professionally.

The Team

Your Role

You will be the primary domain expert for the data platforms and Systems for the team. The role will develop and support the data engineering needs of the Enterprise Data solution team to improve the quality and availability of information to drive better search and reporting capabilities. The hire will be responsible for growing and optimizing our data and data repository as well as optimizing data flow and collection for multi-functional teams. The ideal candidate is an expert data wrangler and builder on the cloud data platform who enjoys optimizing data systems and building them from the ground up. The Senior Data Engineer will work with a team consisting of business partners, business and data analysts, architects, data engineers, quality engineers and other technical roles in an agile delivery environment.

What You'll Do

• Lead and develop data pipelines and transformations to extract, load and transform (ELT) data from source systems into data platforms for further processing and analysis.

• Identify, design, and implement process improvements including designing data quality reports, infrastructure for greater scalability, optimizing data delivery, and automating manual processes.

• Work with customers including data, design, and product teams and assist with data-related issues.

• Work with knowledge management, Business Intelligence, Data Infrastructure and data science teams to optimize data for search, reporting and insight capabilities.

• Ensure data accuracy, integrity, privacy, security, and compliance through quality control procedures.

• Designing and implementing data integration solutions to ingest and process data from various semi-structured and structured data sources such as JSON, XML, CSV, excel, foundation systems or relational databases.

• Configuring and optimizing Storage to efficiently store and handle the ingested data. This includes defining containers and access controls. Partner with Architects to craft the data duplication strategy for durability and availability.

• Implementing data normalization techniques to eliminate data duplication and ensure data integrity within normalized databases.

• Collaborating with architects, business systems analysts, and customers to understand data requirements and support the design of efficient data models that align with business needs.

• Implementing dimensional databases using techniques such as star or snowflake schemas to support analytical reporting and data analysis.

• Monitoring and optimizing data pipelines, storage, and databases for performance, scalability, and reliability.

• Implementing security measures and standard processes to protect critical data throughout the data integration and storage processes, ensuring compliance with data protection regulations and internal security requirements.

Your Experience

• Bachelor's or master's degree in computer science, Data Engineering, or related field.

• 5+ years of experience in data engineering or related roles, with a focus on designing and maintaining data platforms.

• Strong proficiency in data processing tools (Azure Data Factory, Fivetran, DBT, Snowpark , Databricks notebook), ELT frameworks, programming languages (Python, SQL, Scala), and both SQL and NoSQL databases.

• Experience working with Azure cloud data services, Databricks DBT labs, and Snowflake, including designing, developing, and optimizing of data integration within these platforms.

• Deep understanding of data security practices, access controls, encryption, and compliance.

• Experience in implementing Continuous Integration and Continuous Deployment (CI/CD) solutions for data pipelines, ensuring automated testing, deployment, and monitoring processes.

• Demonstrable ability to quickly respond to incidents by assessing the situation, leading incident triage, solving issues, and provide immediate short-term solutions. Capable of formulating and implementing medium and long-term strategies to prevent similar incidents in the future.

• Experience with Agile, Scrum, and Jira required.

• Experience supporting and working with multi-functional teams in a dynamic environment.

• Excellent leadership, communication, and collaboration skills.

• A dedication to diversity, equality, and inclusion, proven through past experiences or initiatives.

• Experience with analytics tools, data modeling, and visualization platforms (e.g., Power BI) is a plus.

*Must be able to legally work in the country where this position is located without visa sponsorship.

#Li-SC2

The salary range for this role is $140,200 to $210,200 USD. We recognize high-wage market differences in Seattle and Washington D.C., where our offices are located. The range for this role in these locations is $152,800 to $229,200 USD. As a mission-driven organization, we strive to balance competitive pay with our mission. New hires salaries are typically between the range minimum and the salary range midpoint. Actual placement in the range will depend on a candidate's job-related skills, experience, and expertise, as evaluated during the interview process.

Hiring Requirements

As part of our standard hiring process for new employees, employment will be contingent upon successful completion of a background check.

Candidate Accommodations

If you require assistance due to a disability in the application or recruitment process, please submit a request here.

Inclusion Statement

We are dedicated to the belief that all lives have equal value. We strive for a global and cultural workplace that supports ever greater diversity, equity, and inclusion - of voices, ideas, and approaches - and we support this diversity through all our employment practices.

All applicants and employees who are drawn to serve our mission will enjoy equality of opportunity and fair treatment without regard to race, color, age, religion, pregnancy, sex, sexual orientation, disability, gender identity, gender expression, national origin, genetic information, veteran status, marital status, and prior protected activity.