Explore Career Opportunities with GSV’s world-class partners

28
companies
3,360
Jobs

Senior Data Engineer, IT Enterprise Data Solutions

Bill & Melinda Gates Foundation

Bill & Melinda Gates Foundation

IT, Data Science
Seattle, WA, USA
Posted on Wednesday, September 20, 2023

The Foundation

We are the largest nonprofit fighting 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

As part of the IT Enterprise Data Solutions (EDS) department, the Data Platform team’s mission is to lead on data technology and utilization, enabling informed decision-making and strategic insights across the foundation. We are committed to providing a robust, secure, and scalable data platform that empowers data-driven initiatives and cultivate collaboration.

Working with our business operations and foundation strategy program partners, the team supports the management of the EDW, data engineering and integration, shared data exchange, data platform operations and data architecture support.

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, solution architects, data architect, 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, transform, and load (ETL) 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, product teams and assist with data-related issues.

  • Work with knowledge management and Analytics and Insights functional 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 data 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, ETL frameworks, programming languages (Python, SQL), and both SQL and NoSQL databases.

  • Experience working with Azure cloud data services 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, lead incident triage, solve issues, and providing 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.

  • The typical salary range for this role is $101,100 to $188,100 USD. The exact offer will be determined by a variety of factors such as the candidate’s individual skills, qualifications, and experience relative to the requirements of the role.

#L1-SL1

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.