Job Details

We are seeking a talented and experienced senior Data Warehouse Developer to join our dynamic team. The ideal candidate will be responsible for designing, developing and maintaining our organisation's data warehouse infrastructure. You will work closely with cross-functional teams to gather requirements, design data models, and implement ETL processes to ensure data integrity, availability, and usability. The role requires strong technical expertise in data warehousing concepts, SQL, ETL tools, and a proactive approach to problem-solving.

Please note this role is flexible in location and can be based in Ireland, Isle of Man or Guernsey, and is a permanent role within the company.

Key Responsibilities

• Collaborate with stakeholders to understand business requirements and translate them into technical specifications for data warehouse solutions.
• Design and develop data models, schemas and architecture for optimal performance and scalability.
• Develop and maintain ETL processes to extract, transform and load data from various source systems into the data warehouse.
• Optimise and tune SQL queries to ensure efficient data retrieval and processing.
• Implement data quality controls and validation checks to ensure accuracy and reliability of data.
• Perform data profiling, analysis, and troubleshooting to identify and resolve data issues.
• Work closely with analysts and other stakeholders to support data-driven decision-making across the organisation.
• Stay updated on emerging technologies and best practices in data warehousing and analytics.
• Effective and timely communication with all involved parties.

Key Tasks

Development

• Developing quality solutions in support of the business within the required service level agreements and schedule
• Providing solutions that meet the IT organisation's architecture and security standards ensuring secure, robust, maintainable, testable and extendable applications.
• Writing technical specification documents.
• Understanding complex applications and their integrations with other systems.

Support

• Providing 3rd level support for the production DWH.
• Working with other teams in order to resolve issues and deliver solutions.
• Ensuring the smooth transition from project phase to live environments with a detailed handover and training for the application support team.

Governance

• Adhering to IT processes and guidelines.
• Writing and maintaining system documentation.
• Defining and driving continuous improvement within the context of strategic objectives.

Release and Deployment

• Ensuring that release processes and procedures are maintained.
• Preparing and deploying releases for non-production environments.
• Preparing releases for production environments.
• Providing input into CAB process.
• Automating releases where feasible.

Capacity Management

• Providing estimates for work.
• Participating in capacity planning with line manager.
• Providing clear MI to line manager.

Key Requirements

Essential

• Computer science degree or equivalent.
• Minimum of 4 years’ experience in data warehousing development.
• Understanding of the full software development life cycle.
• Proficiency in SQL programming and database technologies.
• Strong understanding of data warehousing concepts, methodologies, and best practices.
• Hands-on experience with ETL tools and data integration techniques.
• Experience with dimensional modelling, star schemas, and data normalisation techniques.
• Strong communication and collaboration skills with the ability to work effectively in a team environment or under own initiative.
• Experience using SSIS & SSRS/PowerBI.
• Proactive attitude towards learning new technologies and adapting to evolving business requirements.
• Ability to problem solve and be proactive when faced with a challenge.
• The ability to analyse business needs and conceive, design, and develop innovative solutions.
• The ability to manage multiple projects simultaneously.

Desirable

• Knowledge and experience of Agile.
• Experience with Git, Jira, Azure Devops or similar.
• Experience with .Net and C#
• Experience of WhereScape Red.
• Experience working in the insurance or financial services industry.
• MS certification or equivalent.