Join to apply for the Data Engineer – Trade Promotion Management (TPM) role at The Compleat Food Group
5 days ago Be among the first 25 applicants
Join to apply for the Data Engineer – Trade Promotion Management (TPM) role at The Compleat Food Group
Get AI-powered advice on this job and more exclusive features.
(12-Month FTC)
(12-Month FTC)
Location: Home-based with travel to UK sites
Salary: £40,000 – £45,000 + Benefits
Contract: Initial 12-month Fixed-Term Contract
Hours: Full-time, Monday to Friday
About The Role
We are seeking a Data Engineer to join our team in a key role supporting the deployment of our Trade Promotion Management (TPM) system, UpClear BluePlanner. This is a data-intensive position where the Data Engineer will play a foundational role in ensuring the right data flows into and out of the TPM platform, enabling forecasting, ROI calculations, accruals, and more.
You’ll be integral to building and optimizing data pipelines, integrating systems, and ensuring data quality and consistency, with a focus on the smooth operation of our TPM system to drive business performance.
Key Responsibilities
Data Integration & Connectivity
* Source Data Ingestion: Build pipelines to extract data from systems such as ERP (SAP, Oracle) for shipments, actuals, pricing, CRM (for customer hierarchies and sales teams), POS/Syndicated Data Providers (e.g., Nielsen, IRI, Retail Link), and Financial Systems (budgets, accruals).
* Integration Targets: Work with TPM platforms like Salesforce TPM, SAP TPM, o9, Blacksmith, Eversight, Anaplan.
Data Transformation & Mapping
* Data Harmonization: Align product and customer hierarchies across systems and match event-level POS or shipment data to planned promotions.
* Business Logic Implementation: Apply business calculation logic (e.g., lift factors, cannibalization, baseline vs incremental volume) and complex accrual and ROI logic, particularly when not natively handled by the TPM system.
Data Modeling & Storage
* Data Warehouse/Lake Setup: Design data models to support promotion master data, actual vs forecasted volume/financials, claim reconciliation, and KPIs for ROI and effectiveness.
* Performance Optimization: Ensure that queries for reporting dashboards and AI/ML models perform efficiently.
Data Quality & Validation
* Validation Rules: Build checks to validate promotion dates vs shipment timelines, identify duplicate promotions, and ensure valid account-product combinations.
* Error Handling: Develop monitoring and logging systems for failed data loads or mismatches.
Ongoing Maintenance & Enhancements
* Job Scheduling & Automation: Utilize tools such as Airflow, Azure Data Factory, or Informatica to automate and schedule data pipelines.
* Change Management: Adapt data models as business rules or TPM system logic evolves.
* User Feedback Loop: Collaborate with TPM analysts and business users to refine data outputs and resolve discrepancies.
Knowledge, Skills And Experience
Essential Experience & Skills:
* 5+ years’ experience in a data engineering role within mid-to-large enterprises (FMCG or manufacturing experience is a plus).
* Strong expertise in modern data platforms and cloud technologies (Azure preferred; AWS/GCP also considered).
* Proven experience with:
o Data lakehouse architectures (e.g., Delta Lake, Snowflake)
o ETL/ELT tools (e.g., dbt, Azure Data Factory, Airflow, Informatica, Talend)
o SQL and programming languages (Python, Spark)
o Real-time data streaming (e.g., Kafka, Azure Event Hub)
o Integration with Planning Tools (ERP, REST/SOAP APIs, flat file interfaces)
o Data Quality Tools (Great Expectations, dbt tests)
o Familiarity with analytics platforms such as Power BI
o Knowledge of DevOps, CI/CD, and infrastructure-as-code for data pipelines
What We Offer
* Salary: £40,000 – £45,000 + Benefits
* Hybrid Working: Flexibility to work from home with occasional travel to the office or other UK sites.
* Growth Opportunity: An initial 12-month contract with the potential to transition to a permanent position based on performance.
* Collaborative Culture: Work with a dynamic, cross-functional team within a leading food business.
About The Compleat Food Group
We are a forward-thinking company focused on innovation and sustainable practices in the food industry. Join us to contribute to exciting transformation projects and play a key role in shaping the future of our demand planning and data infrastructure.
What You’ll Get In Return
* Flexible hybrid working with a home base
* Travel to UK sites as part of a collaborative, people-first business
* Opportunity to make a tangible impact in a business investing in transformation
* Competitive salary, benefits, and the potential to move into a permanent role
Why Join Us?
At The Compleat Food Group we’re on a mission to create tasty food that’s better for people and the planet — we call it ‘Food to Feel Good’.
We pride ourselves on being a business that gives equal emphasis to HOW we operate as well as the financial results we achieve.
Our 5,500 (and growing) fantastic people make this possible. They are passionate about creating delicious products for UK consumers, leading retailers, and our exciting, market-leading brands, including Wall’s Pastry, Vadasz, Squeaky Bean, and Unearthed.
Benefits To Include
* 33 Days annual leave
* 2 Employee Volunteering Days per year
* Online and High-street retailer discount scheme
* Employee well-being and community support groups
* Informal and Formal training opportunities with personalised online LMS platform
* Charity Initiatives and Team events
* 24/7 Access to Grocery Aid (Free Financial, Emotional and Practical Support)
* Physical Wellbeing Benefits – Free on demand exercise hub and various gym discounts.
* Online Wellbeing benefits
* Free Financial wellbeing – mortgage calculators, budget tools, financial aid tools
* Holiday Discounts via Online Retail Discount
The Compleat Food Group are proud to have built an inclusive and respectful culture where our colleagues feel safe, supported and valued. A place where they can bring their whole selves to work to achieve exceptional results and thrive. We continue to attract diverse talent into our teams, because we know greater diversity leads to exceptional results and provides a better working life. That’s why we’re committed to ensuring Fairness, Equity, Inclusivity, and Respect in all that we do.
Recruitment Agencies We have an active and trusted Preferred Supplier List to assist us if required. We do not acknowledge any speculative CVs or unsolicited candidate introductions from agencies.
Apply now
Seniority level
* Seniority level
Mid-Senior level
Employment type
* Employment type
Full-time
Job function
* Job function
Information Technology
* Industries
Food and Beverage Manufacturing
Referrals increase your chances of interviewing at The Compleat Food Group by 2x
Get notified about new Data Engineer jobs in Imola, Emilia-Romagna, Italy.
Bologna, Emilia-Romagna, Italy 2 weeks ago
Bologna, Emilia-Romagna, Italy 1 month ago
Bologna, Emilia-Romagna, Italy 2 months ago
Bologna, Emilia-Romagna, Italy 6 days ago
Bologna, Emilia-Romagna, Italy 2 weeks ago
Bologna, Emilia-Romagna, Italy 1 month ago
Data Engineer – Demand Planning (12-Month FTC)
Bologna, Emilia-Romagna, Italy 20 hours ago
Greater Bologna Metropolitan Area 6 days ago
Bologna, Emilia-Romagna, Italy 2 weeks ago
Bologna, Emilia-Romagna, Italy 2 weeks ago
Bologna, Emilia-Romagna, Italy 2 months ago
Bologna, Emilia-Romagna, Italy 2 days ago
Metropolitan City of Bologna, Emilia-Romagna, Italy 1 day ago
Bologna, Emilia-Romagna, Italy 3 weeks ago
Bologna, Emilia-Romagna, Italy 4 days ago
Bologna, Emilia-Romagna, Italy 4 days ago
Bologna, Emilia-Romagna, Italy 4 days ago
Maranello, Emilia-Romagna, Italy 2 weeks ago
Modena, Emilia-Romagna, Italy 3 weeks ago
Bologna, Emilia-Romagna, Italy 2 weeks ago
Greater Bologna Metropolitan Area 3 months ago
Business Intelligence Specialist Internship
Bologna, Emilia-Romagna, Italy 3 months ago
Bologna, Emilia-Romagna, Italy 3 weeks ago
Modena, Emilia-Romagna, Italy 1 month ago
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr