Full Stack BI Engineer (Hyderabad)

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 more than 10000 colleagues we provide our 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 and protection of at-risk skin to improved patient outcomes and reduced care costs. Convatecs revenues in 2024 were over $2 billion. The company is a constituent of the FTSE 100 Index (LSE:CTEC). To learn more please visit

The Full Stack BI Engineer owns BI 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 BI solutions built on Microsoft Fabric and Power BI.

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

Key duties and responsibilities

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

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.

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

3. Semantic Models Reporting and Visualisation

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

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.

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

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

NOTE: Position will be based in Hyderabad.

Skills & Experience

• 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 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).

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.

Qualifications & education

• Bachelors or Masters degree in a 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.

HOW YOU WORK

• You take ownership from vague ask to delivered documented BI product.

• You value simple repeatable patterns and shared standards.

• You are pragmatic and delivery-focused balancing speed with quality and sustainability.

• You are transparent about trade-offs risks and constraints and communicate them clearly.

At Convatec were pioneering trusted medical solutions to improve the lives we touch. If youre ready to make a real impact apply today and help us bring our Forever Caring promise to life.

#LI-SA1

#LI-Hybrid

Beware of scams online or from individuals claiming to represent Convatec

A formal recruitment process is required for all our opportunities prior to any offer of employment. This will include an interview confirmed by an official Convatec email address.

If you receive a suspicious approach over social media text message email or phone call about recruitment at Convatec do not disclose any personal information or pay any fees whatsoever. If youre unsure please contact us at .

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!