Lead Full Stack Data Engineer

Convatec; Hyderabad; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Convatec seeks a Lead Full Stack Data Engineer to own data products across the full lifecycle—from ingestion and transformation to semantic modelling and reporting. The role partners with commercial, operations, finance, and clinical stakeholders to deliver analytics solutions built on Microsoft Fabric and Power BI.

You will design data models, manage AI-ready datasets, and ensure governance, data quality, and scalable architectures, including Bronze-Silver-Gold patterns.

Qualifications

• Typically 5+ years in BI, analytics, or data engineering delivering end-to-end data solutions.
• Strong SQL/Python for data transformation, modelling, and performance tuning.
• Hands-on with Microsoft Fabric components: Data Factory pipelines, Lakehouse/Data Warehouse, Power BI datasets/reports/apps.

Responsibilities

• Design, build, and support end-to-end data products from ingestion to reporting and analytics.
• Translate business requirements into scalable data models, semantic layers, dashboards, and insights.
• Own delivery through discovery, development, testing, deployment, and production support.

Skills

SQL

Python

Microsoft Fabric

Data Factory

Lakehouse

Data Warehouse

Power BI

DAX

CI/CD

GitHub

Education

Bachelor’s degree in CS/DS/Engineering

Master’s degree in CS/DS/Engineering

Tools

Power BI Desktop

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

• Design, build, and support end-to-end data products from ingestion through to reporting and analytics.
• Translate complex business requirements into scalable data models, semantic layers, dashboards, and actionable insights.
• Own delivery throughout the full lifecycle, including discovery, development, testing, deployment, and production support.
• Ensure data quality, integrity, reliability, and governance across all data solutions.
• Develop and maintain data ingestion and transformation pipelines using Microsoft Fabric.
• Build and manage Lakehouse and Data Warehouse solutions using modern architectural patterns.
• Implement scalable Bronze, Silver, and Gold data architectures to support reusable and maintainable data products.
• Define and enforce ETL/ELT standards, performance optimization practices, and engineering best practices.
• Build AI-ready datasets by ensuring data is clean, governed, well-modelled, and well-documented.
• Drive CI/CD adoption using GitHub, including branching strategies, automated testing, and deployment pipelines.

Analytics & Reporting

• Design dimensional data models and star schemas optimized for analytics workloads.
• Build and maintain Power BI semantic models, datasets, reports, dashboards, and applications.
• Develop intuitive, high-performing reporting solutions using DAX and modern visualization techniques.
• Implement security controls including Row-Level Security (RLS) and object-level security.
• Continuously optimize reporting and semantic models for scalability and performance.

Data Governance & Quality

• Apply data quality checks, validation frameworks, monitoring, and issue resolution processes.
• Ensure compliance with data governance, security, and regulatory standards.
• Maintain clear documentation covering ownership, lineage, refresh schedules, business definitions, and known limitations.
• Contribute reusable frameworks, templates, standards, and best practices across the Analytics function.
• Lead, mentor, and develop a team of Data Engineers.
• Conduct regular performance reviews, coaching conversations, and development planning.
• Collaborate with Architecture, Security, Governance, and Engineering teams to align on standards and delivery approaches.
• Participate in peer reviews of SQL, Python, DAX, data models, and reporting solutions.
• Foster a culture of engineering excellence, accountability, and continuous improvement.

About You

• Proven experience (typically 5+ years) in a BI, analytics, or data engineering role delivering end-to-end Data solutions.
• 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 optimization.
• 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/Masters in a relevant field (e.g. Computer Science, Data Science, Information Systems, Engineering), or equivalent practical experience.
• 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, apply today and 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.

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.