Cloud Data Platform Architect

OverviewCloud 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 RoleTo 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.

QualificationsProven 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 and Excel, interpersonal abilities, modelling, diagramming, writing

Use-case scoped data mart specification

Resolution of reporting performance issues

Supply Chain, Logistics, Retail, Hospitality, Food and Drink experience an advantage

Previous exposure to EDI messages and EDIFACT an advantage

What is important to usOur 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 employeesJoining 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 usIPC 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 | ..... full job details .....