Data Engineering Lead (Fabric)

Convatec

United States

Remote

USD 120,000 - 180,000

Full time

7 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Convatec is seeking a Lead Full Stack Data Engineer to own data products from ingestion to semantic modelling, reporting, and user adoption. You will work with commercial, operations, finance, and clinical stakeholders to deliver scalable Analytics solutions built on Microsoft Fabric and Power BI.

The role requires strong data engineering and analytics capabilities, a structured mindset, and the ability to collaborate with both technical and non-technical stakeholders to drive value across the

Qualifications

  • Strong SQL/Python for data transformation and modelling.
  • Hands-on with Microsoft Fabric components (Data Factory pipelines, dataflows Gen2, lakehouse/warehouse).
  • Strong Power BI skills including DAX and performance optimization.

Responsibilities

  • Design and implement full-stack data solutions from ingestion to user-facing reports.
  • Translate ambiguous business questions into data products with models and dashboards.
  • Deliver end-to-end BI solutions and maintain data quality and lineage.
  • Develop semantic models and optimize Power BI reports for performance.
  • Collaborate with stakeholders and ensure governance and security standards.

Skills

SQL/Python
Data modelling
Power BI
Fabric (Microsoft)
Data governance
CI/CD
Stakeholder collaboration
Leadership

Education

Bachelor’s or Master’s in CS/DS/IS

Tools

Microsoft Fabric
Power BI (DAX)
Data Factory pipelines Gen2
Lakehouse/Data Warehouse
GitHub CI/CD

Job description

The Lead Full Stack Data Engineer owns Data products across the full lifecycle: from data ingestion and transformation through to semantic modelling, reporting, documentation, and user adoption. Working closely with commercial, operations, finance, and clinical stakeholders, the role translates complex and often ambiguous business requirements into clear, reliable, and scalable Analytics solutions built on Microsoft Fabric and Power BI.

This position requires strong technical capability across data engineering and Analytics, a structured analytical mindset, and the ability to collaborate effectively with both technical and non-technical stakeholders.

About Role
1. End-to-End BI Solution Development
  • Design, develop, and implement full-stack Data solutions from data ingestion through to user-facing reports and apps.
  • Take ambiguous business questions and translate them into well-defined data products, including data models, semantic layers, dashboards, and supporting documentation.
  • Manage delivery from discovery and prototyping through validation and production support.
  • Ensure data accuracy, integrity, and reliability across all Data solutions.
2. Data Pipelines, Modelling, and ETL
  • Develop and maintain ingestion and transformation pipelines using Microsoft Fabric (Data Factory pipelines, dataflows Gen2, copy activities).
  • Land, organise, and structure data using Fabric Lakehouse and/or Data Warehouse patterns.
  • Implement layered data architectures (e.g. bronze / silver / gold) to ensure modular, reusable, and testable transformations.
  • Set ETL/ELT standards, performance optimisation, and scalable design.
  • Apply data quality checks, validation rules, and monitoring to proactively identify issues.
  • Build and govern the data foundations that AI and ML depend on – clean, well-modelled, well-documented datasets and feature-ready
  • CI/CD for the data platform (GitHub) - branching, automated testing deployment pipelines and raise the bar on engineering discipline
3. Semantic Models, Reporting, and Visualisation
  • Design dimensional and star schemas optimised for Analytics use cases (facts, dimensions, SCDs, conformed dimensions).
  • Build and maintain Power BI semantic models (datasets) with clear, consistent business logic using DAX measures and calculated columns.
  • Develop high-quality Power BI reports, dashboards, and apps that are intuitive, performant, and aligned to real business workflows.
  • Implement navigation, drill-through, parameterised views, and security (row-level and object-level) as required.
  • Optimise models and reports for performance, maintainability, and scalability.
4. Data Analysis and Insights
  • Perform data analysis to identify trends, patterns, and opportunities that support decision-making.
  • Collaborate with stakeholders to understand analytical needs and deliver actionable insights.
  • Support advanced analytics use cases where appropriate, including predictive or statistical models in partnership with other specialists.
  • Enable AI-assisted analytics (e.g. Power BI Copilot) by ensuring semantic models are well-structured, described, and governed enough for AI to query reliably.
5. Data Governance, Documentation, and Support
  • Ensure Data solutions comply with data governance policies, security standards, and regulatory requirements.
  • Contribute to and follow standards for naming, workspace structure, environments, and deployment flows in Fabric.
  • Document Data products clearly, including purpose, data sources, refresh cadence, ownership, lineage, and known limitations.
  • Contribute to shared libraries of reusable calculations, templates, and visual standards.
  • Provide structured handovers, user support, and occasional training or knowledge-sharing sessions.
6. Collaboration and Continuous Improvement
  • Work closely with business stakeholders to prioritise work and agree success measures for Data products.
  • Collaborate with wider data engineering fuction, architecture, governance, and security teams to align on standards and patterns.
  • Participate in peer reviews of SQL, Python, DAX, data models, and report designs.
  • Support continuous improvement of Data delivery practices, promoting full-stack ownership and reduced hand-offs.
7. Leadership
  • Line manager data engineers (Including activities such as setting objectives, carrying out one to ones, performance reviews and development)
About You
  • Strong proficiency in SQL/Python for data transformation, modelling, and performance tuning.
  • Hands-on experience with Microsoft Fabric components, including:
    • Data Factory (pipelines, dataflows Gen2)
    • Lakehouse and/or Data Warehouse
    • Power BI datasets, reports, and apps
  • Strong Power BI skills, including DAX, semantic modelling, and performance optimisation.
  • Solid understanding of data warehousing and dimensional modelling concepts.
  • Experience implementing BI security models (e.g. RLS).
  • Familiarity with Git-based source control and CI/CD practices for BI and analytics assets.
  • Experience working with enterprise source systems (e.g. ERP, CRM, finance systems).
  • Strong analytical and problem-solving skills, with the ability to translate business needs into technical solutions.
  • Clear communication skills, able to explain complex technical concepts to non-technical audiences.
  • Strong attention to detail, documentation, and data quality.
  • Ability to work effectively in a cross-functional, collaborative environment.
  • Comfortable working in regulated or compliance-driven environments.
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.
  • Proven experience (typically 5+ years) in a BI, analytics, or data engineering role delivering end-to-end Data solutions.
  • Demonstrated experience working across the full Data stack, from data ingestion and modelling to reporting and user adoption.

At Convatec, we’re pioneering trusted medical solutions to improve the lives we touch. If you’re ready to make a real impact, help us bring our Forever Caring promise to life.

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.

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 $2 billion. The company is a constituent of the FTSE 100 Index (LSE:CTEC). To learn more please visit: http://www.convatecgroup.com.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Lead Analyst, Sales Force Effectiveness
Lead Analyst, Sales Force Effectiveness

Convatec • Orlando (FL)

On-site
USD 110,000 - 140,000
Lead Analyst, Sales Force Effectiveness
Lead Analyst, Sales Force Effectiveness

Convatec • United States

On-site
USD 110,000 - 150,000
Lead Analyst, Sales Force Effectiveness
Lead Analyst, Sales Force Effectiveness

Convatec • Maryland

On-site
USD 90,000 - 140,000
Procurement Category Manager
Procurement Category Manager

Convatec • United States

Remote
USD 100,000 - 140,000
Territory Manager, Surgical Wound Care - Kansas City
Territory Manager, Surgical Wound Care - Kansas City

Convatec • United States

Remote
USD 90,000 - 150,000
Quality Manager - Fix term Contract
Quality Manager - Fix term Contract

Convatec • New Jersey

On-site
USD 95,000 - 140,000
Territory Sales Manager - Columbus, Ohio
Territory Sales Manager - Columbus, Ohio

180 Medical • Columbus (OH)

On-site
USD 60,000 - 90,000
Office & Procurement Coordinator
Office & Procurement Coordinator

Convatec • Lexington (MA)

On-site
USD 50,000 - 70,000
Legal Counsel - Employment & Litigation
Legal Counsel - Employment & Litigation

Convatec Group • Atlanta (GA)

Remote
USD 120,000 - 160,000
Legal Counsel - Compliance, Employment and Litigation
Legal Counsel - Compliance, Employment and Litigation

1014 United States of America • United States

Remote
USD 150,000 - 210,000