Senior Data / Power BI Engineer
Primary stack
Nice to have's
Job description
About the Position
We are seeking a Senior Data / Power BI Engineer with strong Azure data engineering experience and deep Power BI expertise to modernize a complex data environment for KD Pharma. This role is a Contract position and is fully remote, open to Europe-based candidates.
About the Client
Founded in 1988, KD Pharma is a technology-driven CDMO (Contract Development & Manufacturing Organization) specializing in pharmaceutical and nutraceutical production, including ultra-pure Omega-3 concentrates. The company operates internationally, with locations across Germany, Norway, the UK, the USA, Canada, and Peru, and provides end-to-end solutions from development and custom synthesis through to finished dosage forms.
About the Project
KD Pharma is looking to modernize its current data and reporting environment and establish a scalable, maintainable Microsoft-based data platform supporting multiple business systems and reporting needs. The current landscape spans multiple source systems across Dynamics NAV, Business Central SaaS, QuickBooks, Azure SQL, Excel/SharePoint, and other integrations. Group-wide reporting currently relies heavily on Power BI, with significant transformation and business logic implemented directly within Power BI models and dataflows.
About the Role
This is a highly hands-on Senior Data / Power BI Engineer role combining data engineering, Power BI platform expertise, and technical discovery. You will work closely with the Solution Architect, Delivery Manager, Azure DevOps Engineer, and client stakeholders to understand the current environment, challenge existing patterns, and help define a practical target architecture.
A key objective is to move transformation and data-preparation logic out of complex Power BI models and into scalable upstream pipelines and properly modeled fact/dimension tables, while ensuring that existing business-critical reporting continues to operate during the transition.
Responsibilities
- Assess and reverse-engineer the existing data and Power BI environment, including key data flows, dependencies, and undocumented logic
- Stabilize critical reporting and data processes during the transition, including refresh, performance, and data-flow issues
- Design and build scalable ETL/ELT pipelines that move transformation logic out of Power BI into the appropriate upstream data layer
- Design reusable dimensional models and bronze / silver / gold data structures for reporting and analytics
- Integrate and standardize data across multiple ERP and business systems, including handling inconsistent schemas and master data
- Contribute to the selection and design of the target Azure data platform, evaluating ADF, Databricks, and Microsoft Fabric where appropriate
- Build and validate the initial end-to-end PoC and contribute to the implementation roadmap
- Work closely with the Solution Architect and client stakeholders while operating independently on investigation, technical decisions, and delivery
Requirements
- 6+ years of experience in data engineering, BI, or enterprise data platforms
- Strong hands-on experience with Azure data services, especially Azure Data Factory, Azure SQL, Azure Synapse Analytics, and Azure Data Lake Storage Gen2 (ADLS)
- Strong T-SQL / Microsoft SQL Server experience, including legacy environments
- Strong Power BI expertise beyond dashboard creation, including semantic models, DAX, Power Query/M, and dataflows
- Strong understanding of ETL/ELT, dimensional modeling, and bronze / silver / gold architecture patterns
- Experience modernizing or reverse-engineering complex, poorly documented data environments
- Experience integrating data from multiple enterprise systems and moving transformation logic into scalable upstream pipelines
- Strong English and ability to work independently with both technical and business stakeholders
Nice to Have
- Commercial Microsoft Fabric experience
- Databricks, Python, and/or PySpark experience
- Experience with Dynamics NAV, Business Central, QuickBooks, or similar ERP/accounting systems
- Experience with Power BI platform administration, governance, deployment, or CI/CD
- Experience in manufacturing, pharmaceutical, or other regulated environments
Interview Steps
- GT interview with Recruiter
- Technical interview
- Final interview
- Offer
© GT. This job description was sourced from the employer's public career page. TheJob is not the employer — we index the posting and route candidates to the source. All content rights and hiring decisions belong to the employer.
GT was founded in 2019 by a former executive from Apple, Nest, and Google, Andy Baynes. GT’s mission is to become a meeting point for the world’s best engineers and product companies with a tremendous and meaningful mission to implement in life. Most of our partnering companies are based in the UK, US, Canada, and Europe.You will become a dedicated part of the tech team, working directly with product leadership. Our engineers have worked on products with McLaren, Universal Studios, Jaguar Land Rover, Reevoo, SmartXpo, Rio ESG, Eagle Genomics — to name a few.GT offers hybrid opportunities for everyone, sports, mindfulness practices, great colleagues to work with, fun team parties, and other perks.If we were to describe an image of our ideal candidate, based on our present employees, it would be someone initiative, hard-working, mature, curious, and optimistic! We see a glass-half-full rather than half-empty.Looking forward to having you in our family 💙#WeStandWithUkraineWebsite:gt-hq.comInstagram —www.instagram.com/gt_itcompanyLinkedIn —www.linkedin.com/company/gt-itcompanyReferral program (open for everyone) —www.gt-hq.com/referral
More at GT
All 5 rolesSenior Data Scientist / ML Engineer (Forecasting) | NDA
GT · United Kingdom
Senior ML Engineer / Applied ML Engineer | NDA
GT · Warsaw
Integration Specialist | Live Entertainment Company
GT · Poland
Senior Applied Data Scientist
GT · Poland +1