Cloud Data Platform Architect

Cloud Data Platform Architect FTC 3-6 month contract High Wycombe HP11 2EE Hybrid working IPC International, the purchasing and supply chain organisation for Subway Franchisees in Europe, has an excellent opportunity for a Cloud Data Platform Architect (FTC) to join our Enterprise Systems team on a 3-6 month contract. About the Role o transition our EDI message-driven Azure Data Platform from pilot to full business service by addressing barriers to reporting completeness and accuracy. Seeking candidates with experience in integrated cloud data platforms (Azure Fabric, Synapse, Redshift, BigQuery, DataBricks, Snowflake). Must be proficient in data warehousing (star schemas, surrogate keys, slowly changing dimensions) and storage concepts (data lakes, lakehouses, marts). Excellent SQL skills required; PowerQuery and Power BI experience is a plus. With strong problem-solving skills to identify and address root causes of adverse reporting outcomes. Excellent analysis skills, interpersonal abilities to discuss and resolve issues with data providers, consultants, architects, and the in-house master data management team. Proficient in setting up and tracking improvement metrics, with a drive to eliminate issues. Please note unfortunately, we cannot accept applications from candidates who require visa support. Responsibilities Gain a thorough understanding of the existing business objective, data transformation and target data model. Understand and prove existing root cause conjectures. Detect and describe deeper problems revealed by resolution of the initial. Design and implement a cyclical data quality study that lists and quantifies problem data by its root cause and presents a dashboard to stakeholders. Work with the following, to drive a demonstrable improvement in reportability: Supply Chain Digitalisation; resolving issues in upstream data feeds. Data Management; resolving mastering system and process issues Architecture; specifying additional data entry and mapping services. External build partners; specifying script and data model improvements Provide evidence through trial queries that the programme has entered its reporting phase. Work with Architecture and Analytics to ensure this translates to an optimal reporting architecture, specifying views, marts and connectivity models as required. Repeat the approach (which is initially across EDI Inventory Reports) on EDI Orders and Invoices, absorbing the additional complexity of multi-party messaging and correct identification of supply leg. Assist and advise on the target models that will accommodate this N-Party model. Qualifications proven experience as an architect or lead designer/developer working with star schema designs, data and analytics. Required Skills Self-starting problem solver Star schema design concepts Data Quality analysis and remediation Data Modelling Data Analysis Data Analytics and Reporting (SQL mandatory, Power BI preferred) Presentation to stakeholders; explaining, persuading, driving change Team player, experienced in multi-consultancy, multi-team environments Excellent PowerPoint & Excel, interpersonal abilities, modelling, diagramming, writing Use-case scoped data mart specification Resolution of reporting performance issues Supply Chain, Logistics, Retail, Hospitality, Food & Drink experience an advantage Previous exposure to EDI messages and EDIFACT an advantage What is important to us Our culture and values are at the heart of everything we do and are an important part of our hiring process. Our three values are: We are empowered - we have the freedom to make a difference together. We collaborate - we trust and depend on each other. We contribute. We succeed together. We deliver on our commitments - we deliver on our commitments together, individually, today and tomorrow. Our ground rules: Be courageous in being vulnerable Be open minded and curious. Open to others perspectives Say what we mean Be ourselves. Bring our opinions and thoughts Speak up. Get our itches scratched. Surface concerns Provide support, understanding and empathy if we slip down the ladder Watch for subgroups within our group Nurture ourselves and others How we support our employees Joining a new company can be daunting; we support everyone who has chosen IPC International to develop their career, with: A structured onboarding programme. Time with the senior leadership team, as well as your colleagues and our Culture Champions. Training programmes to develop your skills and ways of working, focusing on feedback and management of work. Flexible working between the hours 8am - 6.30pm. We appreciate the juggle of life and home can be challenging and provide opportunities to flex your start and leave times. Excellent benefits package including enhanced pension contribution, healthcare, 25 days holiday, salary sacrifice schemes. Plus, we also provide breakfast and lunch items in the office! On-site parking A chance to volunteer at our nominated charities. In addition, you will get one volunteer day a year to work with your chosen charity. Recognition award schemes and a Summer and Winter event each year We actively support diversity, equity and inclusion and make sure that our employees are valued and treated with dignity and respect. We encourage everyone in our business to reach their potential. About us IPC International, created by bringing together two strong teams, IPC EMEA and IPC Asia Pacific, is a go-to and trusted supply chain partner, with over 20 years proven experience supporting Subway Franchisees and rapidly scaling store growth across complex markets. With international coverage through our vast supplier and distributor base, and an unmatched portfolio of services, we support the end-to-end supply chain. All of this is powered by great people, execution and technology. https://www.ipcinternational.com/ IPC International Mission, Benefits, and Work Culture | Indeed.com