Job Description:
- 3rd Party System Integrations: Design, develop, and manage integrations between the CDP and various 3rd party systems, ensuring seamless data flow and compatibility.
- ETL Development and Management: Design, build, and maintain efficient and scalable ETL processes to extract, transform, and load data from diverse sources into the CDP.
- Data Orchestration Pipeline Management: Develop, manage, and optimize data orchestration pipelines using tools like Digdag, ensuring reliable and timely data delivery.
- Data Pipeline Validation and Testing: Develop and execute comprehensive test plans to validate the accuracy and performance of data orchestration pipelines
- CDP Instance Maintenance: Perform general maintenance and troubleshooting of the CDP instance, ensuring optimal performance and stability.
- Data Quality and Governance: Implement data quality checks, validation processes, and data governance policies to ensure data accuracy, consistency, and compliance.
- Performance Optimization: Optimize data pipelines and queries for performance and efficiency, ensuring timely data delivery for business needs.
- Collaboration and Communication: Collaborate with product owners, data analysts, and other engineers to understand data requirements and deliver effective solutions. Communicate technical concepts and findings clearly to both technical and non-technical stakeholders.
- Documentation: Create and maintain technical documentation as needed for data pipelines, data models, and data processes, etc.
- Setup and configure data source authentications
- Implement and manage data ingestion processes from multiple sources
- Assist in setting up and maintaining the customer unification workflows
- Set up and manage the parent segment
- Assist in validating and testing segment creation processes
- Proficiency in SQL: Expert-level knowledge and experience in writing complex SQL queries and optimizing database performance.
- Proficiency in Python: Strong programming skills in Python for data manipulation, automation, and scripting.
- Experience with Digdag: Hands-on experience with Digdag for building and managing data orchestration pipelines.
- Experience managing 3rd party system integrations: Proven ability to design and implement integrations with various external systems.
- Strong understanding of ETL processes and data warehousing concepts.
- Experience building and maintaining data pipelines.
- Understanding of data integration and data governance principles.
- Excellent problem-solving and analytical skills.
- Strong communication and collaboration skills.
- Experience with Agile methodologies.
- Understanding of data privacy regulations.
- Experience working with Customer Data Platforms (CDPs)
- Understanding of data warehousing concepts and data modeling techniques.
- Experience with cloud-based data platforms (e.g., Azure).
- Experience with real-time data processing and streaming technologies.
- Experience working in a global, multi-brand company.
- Relevant certifications in data engineering or cloud platforms.
- Work with diverse and talented Associates, all guided by the Five Principles.
- Join a purpose driven company, where we’re striving to build the world we want tomorrow, today.
- Best-in-class learning and development support from day one, including access to our in-house Mars University.
- An industry competitive salary and benefits package, including company bonus.
Mars is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law. If you need assistance or an accommodation during the application process because of a disability, it is available upon request. The company is pleased to provide such assistance, and no applicant will be penalized as a result of such a request.
Top Skills
What We Do
For more than a century, Mars, Incorporated has been driven by the belief that the world we want tomorrow starts with how we do business today. This idea is at the center of who we have always been as a global, family-owned business. Today, Mars is transforming, innovating and evolving in ways that affirm our commitment to making a positive impact on the world around us.
Across our diverse and expanding portfolio of confectionery, food, and petcare products and services, we employ 133,000 dedicated Associates who are all moving in the same direction: forward. With $40 billion in annual sales, we produce some of the world’s best-loved brands including DOVE®, EXTRA®, M&M’s®, MILKY WAY®, SNICKERS®, TWIX®, ORBIT®, PEDIGREE®, ROYAL CANIN®, SKITTLES®, WHISKAS®, COCOAVIA®, and 5™; and take care of half of the world’s pets through our pet health services AniCura, Banfield Pet Hospitals™, BluePearl®, Linnaeus, Pet Partners™, and VCA™.
We know we can only be truly successful if our partners and the communities in which we operate prosper as well. The Mars Five Principles – Quality, Responsibility, Mutuality, Efficiency and Freedom – inspire our Associates to take action every day to help create a world tomorrow in which the planet, its people and pets can thrive.