BI & Data Warehouse Developer
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.
Job Details
Our team is looking for a passionate and driven professional to join us as a 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.
* Data Governance: Ensure that data remains accurate, secure, compliant, and accessible to permitted users.
* Provide technical support for company forecasting.
* Performance Tuning & Maintenance - Conduct regular data 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.
* Be an advocate for best practices with Data.
* 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.
Essential Skills:
* Degree in Computer Science, IT, or equivalent hands-on experience
* Open mind and willingness to learn new technologies and support other systems and applications used within the AMS Group of companies
* Passion for Data Warehousing
* Experience with Data Warehousing Tools (Snowflake, Redshift, Databricks, Big Query, Fabric)
* Solid experience working with SQL-based databases (MS SQL and/or Oracle)
* Advanced SQL and/or PL/SQL skills
* Experience working with data governance and data quality
* Proven capability designing and maintaining ETL / ELT processes
* Strong analytical and problem-solving mindset with attention to detail
* Strong communication skills to effectively collaborate with technical and non-technical teams, and strong enough to say no to requests when necessary
* A critical thinker, with ability to think both detail- and a big picture-oriented and \"can do\" attitude.
Preferable Skills:
* Strong experience with BI reporting technologies (Qlik Sense, Power BI, or Tableau)
* Ability to manage multiple priorities in a fast-paced environment
* Python
* Linux / PuTTY
* Understanding of Firewalls and IT Security
Nice to Have Skills:
* Language Skills, especially French and German
* AI Skills; Machine Learning, Agents
* Data Science Skills; R, statistical analyses