Full Stack Data Engineer
convatec.wd1.myworkdayjobs.com
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 time zones. Flexibility in working hours is to be expected About Role 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, organize, 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 optimization, and scalable design. Apply data quality checks, validation rules, and monitoring to proactively identify issues.
3. Semantic Models, Reporting, and Visualization Design dimensional and star schemas optimized 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, parameterized views, and security (row-level and object-level) as required. Optimize 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 priorities 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 Micro