Data Engineer

Title:  Data EngineerReporting to: Data Operations Manager Location: Grand Canal Dock, Dublin 2 Contract: Full time Permanent. Working Model: Hybrid Working Model (two days in the office, three days working remote on a weekly basis post probation, potentially three or four days in the office for the first 6 months during probation). Flexibility to work additional days in the office will be required depending on business demands.*Kindly note we do not offer visas or sponsorship for this role. You must have the right to work in Ireland and provide a valid Visa to be considered for this role.About IPB:Founded in 1926, we are the leading insurer of Ireland’s public sector. As Irelands only indigenous mutual insurer, we exist to protect and safeguard the interests of our Members, consisting of all 31 Local Authorities, 16 Education and Training Boards, the HSE and Regional Assemblies and the Land Development Agency. In doing so, we play an important role in supporting our Members in serving the needs of their local communities across the length and breadth of Ireland. Our purpose is as relevant today as it was when we were founded. We have maintained this purpose by attracting the very best talent to meet the evolving needs of our Members and customers.About the Role:Reporting to the Data Operations Manager, the Data Engineer will be responsible for the ongoing maintenance and development of the on premise MS SQL IPB Enterprise data warehouse (EDW) and will be part of a Data Management & Support (DMS) team tasked with maintaining and improving the IPB Data Strategy, ongoing maintenance, and enhancement of the data assets, associated infrastructure, and tools in conjunction with other IT resources. The role includes liaising with Business Departments to understand their reporting requirements and making the necessary changes in the warehouse environment to deliver on those requirements. To be successful in the role you will be accountable for:End to End EDW Change Management – establishing and clarifying requirements, analysis of the EDW to establish what changes need to be made and where, to the Operational Data Store, Data Warehouse, SSAS Tabular models and Data Integration Framework, provide work estimates to effect those changes, updating the necessary stored procedures, creating/amending tables & views, validating and testing the changes, liaising with the Business to verify the changes and aligning with the deployment process to implement the changes into a live environment and keeping all the associated documentation in order. Contributing to the planning for monthly deployments.Provision of consultancy and advisory services to project managers, business analysts, data analysts and developers on making best use of the data architecture.Proposing high-level data architecture enhancements to meet requirements for changes to source systems that flow into the EDW.Contribute to the design, build and support of the components of data warehouse (EDW) such as ETL processes, databases, reports, and reporting environments.Contributing to the design of dimensional models with conformed dimensions, following the business’ processes.Contributing to the development and automation of ETL processes including error & reconciliation handling.Contributing to the review and ensure data loaded into EDW is accurate (Ensure the integrity, validity, and reproducibility of all data in the EDW).Contributing to the delivery of Governance & Management framework (Data Life Cycle, Data Quality, Access Control, Documentation – Data dictionary, model etc).Analysis and implementation of Audit controls.Contributing to the ongoing development of the IPB data strategy technologically and procedurally and supporting the business in delivering quality MI.The role will not be responsible for the design or content of Business reports, this responsibility will continue to lie with the business.What we're looking for:BSc Computer Science, Software Engineering, Data Analytics, or relevant professional experience.Relevant experience with a focus on Data Engineering, Data Analysis, Warehouse Design and development, and Business Intelligence, preferably within the Financial Services / Insurance Industry.In depth knowledge and experience of the end-to-end Change and Release Management process for delivering Enterprise Data Warehouse change requestsProject Management Lead of or major contributor to large transformational or strategic projects (preferably Data related)Technical background to include proficiency in Data warehousing skills, Data Integration & Manipulation techniques, database design, ETL and SQL Reporting Services, SQL Database & Schema planning, design, and optimisation.Excellent knowledge of and proven experience in the following technologies: MS SQL SSMS, Visual Studio, Azure DevOps, Source Control (Git), SSAS & SSIS and DAXProficient working technical knowledge of SQL development, SQL Server (All Editions), PowerBI, Power Platform, Power Pivot for supporting End user self-service. Excellent organisational, planning, time management and collaboration skills.Ability to drive change and secure consensus collaboratively without resorting to defensiveness.Ability to work on multiple initiatives simultaneously.Desirable: Experience with both on-premises and cloud-based SQL Warehouse implementation, including migrations. Data Base Administration (DBA) skills would be a definite advantage.What you’ll get:An opportunity to develop your data engineering skills in an insurance setting with a range of stakeholders.An opportunity to determine the technical direction of MI reporting in the organisationAn opportunity to play an active role in setting the companies Data Strategy as part of the Data Management Support team.We offer you a culture that is underpinned and supported by our values and behaviours of ‘Passionate’, ‘Service Driven’, ‘Respectful’, ‘Trustworthy’ and ‘Collaborative’. These values underpin how we interact with each other across everything that we do. They guide our thinking, decisions, and actions, creating a truly unique place to work. Every employee is responsible for the creation of our culture which focuses on creating a psychologically safe ‘Speak Up’ environment, promoting an inclusive and diverse workplace and enhancing our journey in employee engagement and sustained performance improvement. Lots of benefits including:Competitive Salary.Discretionary Bonus.Health Allowance for employees and dependents where applicable.Holidays - 25 days annual leave plus the option to purchase more.10 public holidays plus 2 additional company days.Generous Pension Scheme.A suite of family leave policies. Life assurance cover.Income Protection Insurance.Discounted Home and Car Insurance.Learning and Development Opportunities.Exam and Study Leave.Easy access to our Employee Assistance Programme and suite of Employee Wellness Initiatives including annual Flu vaccine.Bike to Work Scheme.Active Sports and Social Club.IPB is committed to attracting, developing, and retaining the very best people by offering a motivating and inclusive workplace in which talent is truly recognised and rewarded. We are committed to promoting Inclusion for All with the belief that diversity plays an important role in the success of our business. We actively encourage everyone to consider becoming a part of our journey. We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of gender, race, religion, sexual orientation, age, marital status, family status, disability, or membership of the Traveller community. We bring out the best in each other.IPB is proud to be recognised as a Great Place to Work category.IPB is dedicated to Sustainability and safeguarding your future. We focus on Environmental, Social, and Governance commitments, and invite you to join us in creating a better world for generations to come.Individuals who are interested in applying for a job opportunity in IPB can request reasonable accommodations to be made throughout the recruitment process. To learn more about us, please visit here.If this sounds like you:Apply if you think we're a good match for you and you believe in our values. We’ll get in touch to let you know what the next steps are.Interviews:Interviews will be conducted in-person, in addition to virtually where required.