BI and Data Warehouse Developer

Advanced Medical Solutions
Winsford
21 hours ago
Create job alert

Direct message the job poster from Advanced Medical Solutions

Head of Global Recruitment at Advanced Medical Solutions

Who are Advanced Medical Solutions?

AMS is a world-leading independent developer and manufacturer of innovative tissue-healing technology, focused on quality outcomes for patients and value for payers. AMS has a wide range of surgical products including tissue adhesives, sutures, haemostats, internal fixation devices and internal sealants, which it markets under its brands LiquiBand®, RESORBA®, LiquiBandFix8®, LIQUIFIX™, Peters Surgical, Ifabond, Vitalitec and Seal-G®. AMS also supplies wound care dressings such as silver alginates, alginates, and foams through its ActivHeal® brand as well as under white label. Since 2019, the Group has made seven acquisitions: Sealantis, an Israeli developer of innovative internal sealants, Biomatlante, a French developer and manufacturer of surgical biomaterials, Raleigh, a leading UK coater and converter of woundcare and bio-diagnostics materials, AFS Medical, an Austrian specialist surgical business, Connexicon, an Irish tissue adhesives specialist, Syntacoll a German specialist in collagen-based absorbable surgical implants and Peters Surgical a global provider of specialty surgical sutures, mechanical haemostasis and internal cyanoacrylate devices. AMS's products, manufactured in the UK, Germany, France, the Netherlands, Thailand, India, the Czech Republic and Israel, are sold globally via a network of multinational or regional partners and distributors, as well as via AMS's own direct sales forces in the UK, Germany, Austria, France, Poland, Benelux, India, the Czech Republic and Russia. The Group has R&D innovation hubs in the UK, Ireland, Germany, France and Israel. Established in 1991, the Group has more than 1,500 employees. For more information, please see www.admedsol.com

AMS provides equal employment opportunities for all applicants. We highly value and encourage diversity across our workforce meaning that no one will be discriminated against because of their gender, race, age, nationality, disability, or any other protected characteristic as prohibited by law.

Our team is looking for a passionate and driven professional to join us as an BI and Data Warehouse Developer. If you're ready to make an impact, collaborate across teams, and grow in a dynamic environment this could be your next move.

The continuing expansion of AMS has driven the need to build a more robust data foundation to combine many disparate data sources from around the globe and provide a single source of truth. This role provides a great opportunity to positively impact this process.

As a key contributor to our company’s digital transformation, you will drive the design, development, and implementation of our data warehouse solution by providing seamless integrations, and sophisticated data extraction and transformation processes. Your expertise will provide a robust platform to enable the creation of dynamic BI dashboards and insightful reports, empowering our stakeholders with actionable intelligence to support better strategic business decisions and foster continuous improvement across the organisation.

What the role involves:

  • Collaborate with cross-functional teams and stakeholders to gather and translate requirements into effective technical solutions.
  • Data Warehouse Design & Architecture - Design, develop, and implement secure, robust, and scalable data warehouse solutions and integrations by defining and executing the overall architecture, including schema design and storage structures.
  • ETL/ELT Development - Build and maintain robust data extraction, transformation, and loading processes from multiple source systems.
  • Data Modelling & Integration - Create and optimise dimensional models for analytics and reporting and integrate data sources into a unified, governed and secure repository.
  • BI Development: Provide clean, analytics‑ready datasets for BI tools by writing complex database queries, stored procedures, and functions that robustly support analytics and reporting needs.
  • BI Reporting - Partner with business stakeholders to design and develop high-quality, interactive dashboards and reports, following UX standards, while establishing reporting best practices, refresh strategies, and documentation to drive self-service BI with appropriate guardrails.
  • Provide technical support for company forecasting system John Galt as a key data source for BI Sales Reporting.
  • Performance Tuning & Maintenance - Conduct regular health checks, capacity planning and monitoring performance & tuning for the warehouse & BI environments.
  • Perform technical troubleshooting, root cause analysis, and consultation to ensure the smooth running of applications used within the AMS Group of companies, responding to technical problems in a timely manner.
  • Work with external suppliers to resolve technical issues when required.
  • Provide user training to support the adoption of implemented solutions.
  • Ensure scalability, performance, and compliance with organisational standards.
  • Create and update any relevant documentation associated with system changes.
  • Proactively seek out any areas for improvement and make recommendations to enhance BI capabilities and user experience.

What we’re looking for:

  • Bachelor’s degree in Computer Science, Information Technology or an equivalent experience.
  • Open mind and willingness to learn new technologies and support other systems and applications used within the AMS Group of companies.
  • Strong technical experience with BI & data warehouse technologies and data visualization tools like Qlik Sense, Qlik Talend Cloud, Snowflake, Power Bi.
  • Strong technical experience with databases like MS SQL and/or Oracle.
  • Proficiency in data extractions and transformation - ETL/ELT.
  • Proficiency in SQL and/or PL/SQL.
  • Strong experience with data governance and gap analysis.
  • Strong analytical skills and ability to analyse complex data sets and provide actionable insights.
  • A creative mindset with strong problem-solving skills to address data-related challenges and improve BI solutions.
  • Strong communication skills to effectively collaborate with technical and non-technical teams.
  • A critical thinker, with ability to think both detail- and a big picture-oriented and "can do" attitude.
  • Ability to handle multiple projects and deadlines.
  • Attention to verbal or written detail, good organisational skills, decisive priority management, strong teamwork ethic with the ability to work independently without supervision.
  • Open mind and ability to quickly learn and adopt to new technologies and industry standards.
  • Fluent in English, both written and spoken.
  • Familiarity with AI-driven tools and techniques such as machine learning, predictive analytics or AI-powered BI & data warehouse technologies is a big plus.
  • Day to day interaction with other members of the IT department or members of other departments in the company and externally interact with suppliers and partners.
  • No day to day supervisory responsibility for others.
  • You will be expected to travel occasionally to company sites to work closely with project teams.
  • You will be required to communicate and collaborate via any channel or communication platform used in the company (e.g. telephone, e-mail, MS Teams, etc.).
  • Participate in meetings.
  • Required to write technical and project reports and documentation.
  • You may be required to give training either on a one to one basis or to a group of staff.
  • The jobholder may be expected to run project meetings.
  • The jobholder will ensure to escalate communication to his supervisor or higher level management when required.

Advanced Medical Solutions Group PLC engages recruitment services strictly through executed written agreements. Any unsolicited resumes, candidate profiles, or referrals submitted by agencies or search firms in the absence of such an agreement shall be deemed the property of Advanced Medical Solutions Group PLC. No remuneration or placement fee will be recognized or paid under these circumstances.

Seniority level
  • Associate
Employment type
  • Full-time
Job function
  • Information Technology
  • Industries: Pharmaceutical Manufacturing

Referrals increase your chances of interviewing at Advanced Medical Solutions by 2x

Get notified about new Business Intelligence Developer jobs in Winsford, England, United Kingdom.

Manchester, England, United Kingdom 2 days ago

Warrington, England, United Kingdom 2 days ago

We’re removing extraneous job postings and metadata in this refined description to ensure clarity and relevance.


#J-18808-Ljbffr

Related Jobs

View all jobs

BI & Data Warehouse Developer | Global Data Platform

BI & Data Warehouse Developer — Elevate Analytics

Principal Data Warehouse Developer

Principal Data Warehouse Developer

Principal Data Warehouse Developer

Principal Data Warehouse Developer

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

How to Write a Data Science Job Ad That Attracts the Right People

Data science plays a critical role in how organisations across the UK make decisions, build products and gain competitive advantage. From forecasting and personalisation to risk modelling and experimentation, data scientists help translate data into insight and action. Yet many employers struggle to attract the right data science candidates. Job adverts often generate high volumes of applications, but few applicants have the mix of analytical skill, business understanding and communication ability the role actually requires. At the same time, experienced data scientists skip over adverts that feel vague, inflated or misaligned with real data science work. In most cases, the issue is not a lack of talent — it is the quality and clarity of the job advert. Data scientists are analytical, sceptical of hype and highly selective. A poorly written job ad signals unclear expectations and immature data practices. A well-written one signals credibility, focus and serious intent. This guide explains how to write a data science job ad that attracts the right people, improves applicant quality and positions your organisation as a strong data employer.

Maths for Data Science Jobs: The Only Topics You Actually Need (& How to Learn Them)

If you are applying for data science jobs in the UK, the maths can feel like a moving target. Job descriptions say “strong statistical knowledge” or “solid ML fundamentals” but they rarely tell you which topics you will actually use day to day. Here’s the truth: most UK data science roles do not require advanced pure maths. What they do require is confidence with a tight set of practical topics that come up repeatedly in modelling, experimentation, forecasting, evaluation, stakeholder comms & decision-making. This guide focuses on the only maths most data scientists keep using: Statistics for decision making (confidence intervals, hypothesis tests, power, uncertainty) Probability for real-world data (base rates, noise, sampling, Bayesian intuition) Linear algebra essentials (vectors, matrices, projections, PCA intuition) Calculus & gradients (enough to understand optimisation & backprop) Optimisation & model evaluation (loss functions, cross-validation, metrics, thresholds) You’ll also get a 6-week plan, portfolio projects & a resources section you can follow without getting pulled into unnecessary theory.

Neurodiversity in Data Science Careers: Turning Different Thinking into a Superpower

Data science is all about turning messy, real-world information into decisions, products & insights. It sits at the crossroads of maths, coding, business & communication – which means it needs people who see patterns, ask unusual questions & challenge assumptions. That makes data science a natural fit for many neurodivergent people, including those with ADHD, autism & dyslexia. If you’re neurodivergent & thinking about a data science career, you might have heard comments like “you’re too distracted for complex analysis”, “too literal for stakeholder work” or “too disorganised for large projects”. In reality, the same traits that can make traditional environments difficult often line up beautifully with data science work. This guide is written for data science job seekers in the UK. We’ll explore: What neurodiversity means in a data science context How ADHD, autism & dyslexia strengths map to common data science roles Practical workplace adjustments you can request under UK law How to talk about your neurodivergence in applications & interviews By the end, you’ll have a clearer sense of where you might thrive in data science – & how to turn “different thinking” into a real career advantage.