BI and Data Warehouse Developer

Direct message the job poster from 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.

• Associate

• Full-time

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