Data Solutions Designer

ConvaTec Inc.; Greater London; Hybrid; GBP 90,000 - 120,000; Full time

Job summary

ConvaTec is seeking a Data Solution Designer to join the Data & Analytics team in London. The role translates business requirements and architecture into build-ready data designs, guiding engineers on ingestion, transformation, storage, access, security and non-functional aspects in a Microsoft Fabric landscape.

As a senior individual contributor, you will balance architecture discussions with detailed design work, mentoring junior team members and collaborating with Enterprise Architecture and

Qualifications

• 5+ years’ experience in data engineering, solution design, data architecture, BI or analytics.

Responsibilities

• Lead detailed design for data and BI solutions with source-to-target mapping and non-functional requirements.

Skills

Data engineering

Solution design

Data architecture

BI analytics

Cloud data platforms

Data governance

Communication

Stakeholder collaboration

Education

Bachelor's or Master's degree in Computer Science, Data Science, Information Systems, Engineering

Tools

Microsoft Fabric

SAP ECC 6.0

SAP BW

S/4HANA

Job description

Position Overview

ConvaTec is recruiting a Data Solution Designer to join the Data & Analytics team, reporting to the Head of Data Platform & Business Intelligence and partnering closely with Enterprise Architecture. The Data Solution Designer is responsible for translating business requirements and high-level architecture into detailed, build-ready data solution designs. The role ensures engineers have clear specifications covering data ingestion, transformation, storage, consumption, security, integration and non-functional requirements. Working primarily within a Microsoft Fabric landscape, the role will maintain design consistency across data solutions, establish reusable patterns and standards, and ensure solutions developed for one domain can be effectively reused across others. This is a senior, hands-on individual contributor role operating at the intersection of architecture and engineering. The role requires the ability to work independently on complex design challenges, provide credible technical challenge, and move confidently between architecture-level discussions and detailed solution design. The Data Solution Designer may also lead design activities or technical processes, review the work of other professionals, and provide coaching and technical guidance to junior team members, engineers and contractors.

Key Responsibilities

1. Solution & Detailed Design Lead detailed design for data and BI solutions, including source-to-target mapping, transformation logic, orchestration, error handling, security and access requirements, and non-functional requirements. Translate high-level architecture and business requirements into clear, build-ready technical designs. Produce and maintain robust design artefacts, including data models, interface specifications, lineage and dependency documentation, and architecture decision records. Ensure designs provide engineers with sufficient detail to implement solutions consistently and effectively.
2. Patterns, Standards & Reuse Establish and maintain reusable data design patterns and standards that can be adopted across the team. Identify duplication across data ingestion, modelling and reporting, and design solutions that enable reuse across multiple domains and consumers. Work closely with Lead Engineering and DevOps to ensure solutions are testable, deployable and CI/CD-ready. Embed data quality, reconciliation and observability into solution designs from the outset.
3. Design Assurance & Technical Governance Represent the Data & Analytics team at the Design Review Board, presenting designs for approval and reviewing relevant designs from other teams, projects and delivery partners. Provide credible technical challenge, identifying unnecessary duplication, complexity, dependencies or design risks and recommending appropriate alternatives. Provide design assurance to ensure delivered solutions align with approved designs and standards. Conduct impact assessments for changes, migrations and decommissioning, identifying downstream dependencies and required sequencing.
4. Architecture Partnership & Solution Lifecycle Partner closely with Enterprise Architecture, aligning detailed solution design with high-level architecture, target-state architecture, tooling direction and enterprise standards. Provide implementation insight to Enterprise Architecture and elevate decisions with wider architectural implications when required. Provide detailed data design expertise to support wider architecture initiatives. Support the design of data migrations and system decommissioning, ensuring dependencies and downstream impacts are understood.

Supervisory Responsibility

This role does not typically have direct people management responsibility but may provide technical guidance and mentoring to junior team members, engineers and contractors.

Key Requirements

• Essential Minimum 5 years’ experience in data engineering, solution design, data architecture, BI or analytics, with experience designing end-to-end data solutions.
• Experience designing at least one substantial data platform or end-to-end data solution, covering ingestion, transformation, storage and consumption.
• Strong experience with cloud data platforms and data solution architecture.
• Evidence of establishing reusable design patterns, standards or architectural approaches for a team, with demonstrated adoption in delivery.
• Strong HLD/LLD design discipline, including interface specifications and architecture decision records, with experience presenting and defending designs to design reviewers, architecture boards or equivalent formal governance forums.
• Strong understanding of data governance, data quality, security and privacy by design.
• Proven ability to translate business needs into technical solutions, working effectively between business stakeholders, engineers and other cross-functional teams.
• Ability to communicate complex technical concepts clearly to both technical and non-technical audiences.
• Strong analytical and problem-solving skills, with good attention to technical detail, documentation and data quality.
• Ability to design with a platform rather than project mindset, making appropriate architectural decisions and credibly challenging technical designs and approaches.
• Desirable Microsoft Fabric experience.
• Experience working with data in SAP environments, such as SAP ECC 6.0, S/4HANA, Business Warehouse (BW), Datasphere or Analytics Cloud.
• Experience working in regulated or compliance-driven environments, ideally healthcare.
• Experience with CI/CD practices.
• Experience holding offshore delivery partners to defined architecture and design standards.

Desirable

Microsoft Fabric experience is considered desirable.

Education/Qualifications

Bachelor’s or Master’s degree in a relevant field (e.g. Computer Science, Data Science, Information Systems, Engineering), or equivalent practical experience.

Travel Requirements

Position may involve travel 5% of the time.

Working Conditions

Hybrid working model from our Paddington, London office.

Equal opportunities

Convatec provides equal employment opportunities for all current employees and applicants for employment. This policy means that no one will be discriminated against because of race, religion, creed, color, national origin, nationality, citizenship, ancestry, sex, age, marital status, physical or mental disability, affectional or sexual orientation, gender identity, military or veteran status, genetic predisposing characteristics or any other basis prohibited by law.

Notice to Agency and Search Firm Representatives

Convatec is not accepting unsolicited resumes from agencies and/or search firms for this job posting. Resumes submitted to any Convatec employee by a third party agency and/or search firm without a valid written and signed search agreement, will become the sole property of Convatec. No fee will be paid if a candidate is hired for this position as a result of an unsolicited agency or search firm referral. Thank you.

Already a Convatec employee?

If you are an active employee at Convatec, please do not apply here. Go to the Career Worklet on your Workday home page and View "Convatec Internal Career Site - Find Jobs". Thank you!

About Convatec

Pioneering trusted medical solutions to improve the lives we touch: Convatec is a global medical products and technologies company, focused on solutions for the management of chronic conditions, with leading positions in Advanced Wound Care, Ostomy Care, Continence Care, and Infusion Care. With over 10,000 colleagues, we provide products and services in around 90 countries, united by a promise to be forever caring. Our solutions provide a range of benefits, from infection prevention, treatment for hard to heal wounds, at-risk skin and ulcerated tissue to supporting debilitating conditions, improved patient outcomes and reduced care costs. Convatec's revenues in 2025 were over $2billion. The company is a constituent of the FTSE 100 Index (LSE:CTEC). To learn more please visit: http://www.convatecgroup.com.

Convatec is a global medical products and technologies company focused on solutions for the management of chronic conditions, with leading market positions in advanced wound care, ostomy care, continence & critical care, and infusion care. Our products provide a range of clinical and economic benefits including infection prevention, protection of at-risk skin, improved patient outcomes and reduced total cost of care. If you would like to know how we intend to use your data following your application please refer to our full data privacy policy on the following link: https://www.convatecgroup.com/privacy-policy/