Business Intelligence Data Warehouse Consultant in Winsford

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, LIQUIFIXTM, 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.

The Group has made seven acquisitions since 2019: Sealantis, Biomatlante, Raleigh, AFS Medical, Connexicon, Syntacoll, and Peters Surgical. AMS's products are manufactured in various countries and sold globally via a network of multinational or regional partners and distributors, as well as via AMS's own direct sales forces.

Established in 1991, the Group has more than 1,500 employees and provides equal employment opportunities for all applicants, valuing diversity across the workforce.

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.
• 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.
• BI Development: Provide clean, analytics‐ready datasets for BI tools.
• Data Governance: Ensure that data remains accurate, secure, compliant, and accessible to permitted users.
• Performance Tuning & Maintenance - Conduct regular data health checks, capacity planning and monitoring performance & tuning for the warehouse & BI environments.
• Provide technical support for company forecasting.
• Work with external suppliers to resolve technical issues when required.
• Be an advocate for best practices with Data.
• 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.
• 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.
• A critical thinker, with ability to think both detail- and big picture-oriented.

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.