Senior Data Engineer

The Senior Data Engineer will be responsible for designing, developing, and maintaining ETLprocesses to extract, transform, and load data from various sources into our data warehouse.

The ideal candidate should have hands-on experience with ETL tools as noted below with strong data analysis skills, and the ability to work with large datasets.

• Design, develop, and maintain ETL automations using Informatica Cloud and Azure Data Factory

• Develop and Maintain Datawarehouse objects like tables, views and security roles in MS Azure Data Warehouse and Snowflake.

• Extract data from various sources, such as databases, flat files, and APIs, process and post it to required destination storage such as SQL database, Azure blob, Azure table storage, Azure Service Bus, Snowflake, FTP, API etc.

• Transform and cleanse data to ensure data quality and integrity across the data platform.

• Load data into the data warehouses, ensuring data consistency and accuracy.

• Optimize ETL processes for performance, scalability, and reliability.

• Design and develop data dashboards using Microsoft Power BI. 

• Work closely with data architects, analysts, and developers to support data integration initiatives.

• Implement data validation, data quality checks, and data security measures across all databases.

• Troubleshoot and resolve data issues, performance bottlenecks, and ETL failures.

• Implement best practices for data warehousing, data modeling, and ETL development.

• Document ETL processes, data mappings, and configurations.

• Strong expertise in writing SQL queries and SQL stored procedures.

• Benefits, subject to election and eligibility: Medical, Dental, Vision, Disability, Paid Time Off (including paid parental leave, vacation, and sick time), 401k with company match, Tuition Reimbursement, and Mileage Reimbursement
• Annual bonus based on performance and eligibility
• It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

• A minimum of 5 years of experience with relational databases, ETL, and data warehouse required.

• Advanced level knowledge of industry leading ETL tools such as Informatica and Azure Data Factory

• Experience in designing and developing complex near real-time and/or batch data.

• integration solutions using cloud based ETL and integration tools

• Proficiency in SQL programming and relational database concepts.

• Experience with loading and maintaining a data warehouse.

• Bachelor’s degree in Computer Science or a related field with five years of related experience, or Master’s degree in Computer Science or a related field with at least three years of related experience required.

• Ability to work with different functional groups and levels of employees to effectively and professionally achieve results.

• Strong organizational skills; ability to accomplish multiple tasks within the agreed upon timeframes through effective prioritization of duties and functions in a fast-paced

Keurig Dr Pepper (NASDAQ: KDP) is a leading beverage company in North America, with a portfolio of more than 125 owned, licensed and partners brands and powerful distribution capabilities to provide a beverage for every need, anytime, anywhere. We operate with a differentiated business model and world-class brand portfolio, powered by a talented and engaged team that is anchored in our values. We work with big, exciting beverage brands and the #1 single-serve coffee brewing system in North America at KDP, and we have fun doing it!

Together, we have built a leading beverage company in North America offering hot and cold beverages together at scale. Whatever your area of expertise, at KDP you can be a part of a team that’s proud of its brands, partnerships, innovation, and growth. Will you join us?

We strive to be an employer of choice, providing a culture and opportunities that empower our team of ~29,000 employees to grow and develop. We offer robust benefits to support your health and wellness as well as your personal and financial well-being. We also provide employee programs designed to enhance your professional growth and development, while ensuring you feel valued, inspired and appreciated at work.

Keurig Dr Pepper is an equal opportunity employer and recruits qualified applicants and advances in employment its employees without regard to race, color, religion, gender, sexual orientation, gender identity, gender expression, age, disability or association with a person with a disability, medical condition, genetic information, ethnic or national origin, marital status, veteran status, or any other status protected by law.