Full Stack Data Engineer

ConvaTec Inc.; Gurugram District; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Convatec is seeking a Full Stack Data Engineer to build end-to-end BI solutions on the Microsoft Fabric ecosystem. You will ingest, transform, model, and visualize data to deliver actionable business insights across Commercial, Operations, Finance, and Corporate Functions.

The role requires hands-on development of data pipelines, semantic models, and secure dashboards while coordinating with EU/US timezones. Prior BI/analytics experience is essential.

Qualifications

• Bachelor or Master in CS, Data Science, or related field.
• 3+ years delivering end-to-end BI/analytics solutions.
• Experience with BI stacks: ingestion, modelling, reporting.

Responsibilities

• Design and implement full-stack BI solutions from ingestion to reports and apps.
• Develop and maintain data pipelines using Microsoft Fabric (Data Factory, dataflows Gen2).
• Build Power BI semantic models, reports, and dashboards with clear logic.
• Ensure data quality, governance, and documented lineage across BI products.
• Collaborate with stakeholders to translate requirements into scalable data products.

Skills

Analytical thinking

Clear communication

Cross-functional collaboration

Education

Bachelor/Master in CS or Data Science

Tools

Microsoft Fabric

Data Factory

Lakehouse/Data Warehouse

Power BI

Job description

Role Overview We are seeking a talented Full Stack Data Engineer to join our growing Data & Analytics team. This is a hands‑on role for someone who enjoys building data solutions end‑to‑end—from ingesting and transforming raw data through to modelling, visualization, and delivering actionable business insights. You will work closely with stakeholders across Commercial, Operations, Finance, and Corporate Functions to translate business requirements into scalable data products built on the Microsoft Fabric ecosystem. The ideal candidate combines strong technical expertise with a business‑oriented mindset and enjoys owning solutions throughout their lifecycle. Note: Role will require supporting EU/US timezones. Flexibility in working hours is to be expected.

About Role

End-to-End BI Solution Development

Design, develop, and implement full‑stack BI solutions from data ingestion through to user‑facing reports and apps. Take ambiguous business questions and translate them into well‑defined BI 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 BI solutions.

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. Partner with Data Engineers to align on ETL standards, performance optimisation, and scalable design. Apply data quality checks, validation rules, and monitoring to proactively identify issues.

Semantic Models, Reporting, and Visualisation Design

Design dimensional and star schemas optimised for BI 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.

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.

Data Governance, Documentation, and Support

Ensure BI 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 BI 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.

Collaboration and Continuous Improvement

Work closely with business stakeholders to prioritise work and agree success measures for BI products. Collaborate with data engineering, architecture, governance, and security teams to align on standards and patterns. Participate in peer reviews of SQL, DAX, data models, and report designs. Support continuous improvement of BI delivery practices, promoting full‑stack ownership and reduced hand‑offs.

About You

• Strong proficiency in SQL 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).

Analytical and Professional Skills

• 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/Master in relevant field (e.g. Computer Science, Data Science, Information Systems, Engineering), or equivalent practical experience.
• Proven experience (typically 3+ years) in a BI, analytics, or data engineering role delivering end‑to‑end BI solutions.
• Demonstrated experience working across the full BI stack, from data ingestion and modelling to reporting and user adoption.

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. 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/