My Dublin City Centre based client looking for an experienced Senior Data Warehouse Developer to join a growing data team and help drive the design, development, and optimisation of scalable data warehouse solutions.
This role involves working closely with stakeholders across the business to understand data needs, shape data models, and build robust ETL pipelines that ensure clean, reliable, and accessible data.
The ideal candidate will bring strong technical knowledge in data warehousing, ETL tools, and SQL, along with a proactive approach to solving complex data challenges.
Data Architecture & Development Collaborate with stakeholders to gather and interpret data requirements.
Design and build efficient, scalable data models and structures.
Develop and maintain ETL workflows to consolidate data from multiple sources.
Write and optimise SQL queries for performance and accuracy.
Implement data validation processes to uphold data quality and integrity.
Conduct data profiling and troubleshoot data issues as they arise.
Partner with analysts and business users to support data-driven initiatives.
Stay informed on evolving tools, technologies, and best practices in the data space.
Maintain open and clear communication across teams.
Development Deliver high-quality, timely data solutions in line with business priorities.
Ensure all solutions align with established architecture and security standards.
Create and maintain clear technical documentation.
Understand integrations between systems and manage data flows across platforms.
Support & Troubleshooting Provide expert-level support for data warehouse environments.
Work collaboratively to identify and resolve production issues.
Ensure seamless handovers from development to production, including documentation and knowledge transfer.
Process & Governance Follow established IT processes, standards, and documentation practices.
Drive process improvements and contribute to strategic planning.
Release & Deployment Manage code releases across environments, ensuring stability and consistency.
Participate in deployment planning and contribute to change control processes.
Automate deployment processes wherever practical.
Capacity & Planning Estimate development effort and assist with workload planning.
Support team capacity management through reporting and communication.
Essential Skills & Experience At least 4 years' experience in data warehouse development roles.
Solid understanding of end-to-end software development lifecycle.
Strong SQL expertise and experience with relational databases.
Practical knowledge of data warehousing principles and architecture.
Proficiency with ETL tools and data integration techniques.
Experience with dimensional modelling and data design best practices.
Strong team player with excellent communication skills.
Experience with SSIS and reporting tools such as SSRS or Power BI.
Curious, resourceful, and eager to tackle data challenges head-on.
Ability to manage multiple tasks and projects effectively.
Nice to Have Familiarity with Agile working methods.
Experience using tools like Git, Jira, Azure DevOps.
Background in .NET/C# development.
Hands-on experience with WhereScape RED.
Experience in financial services or insurance sectors.
Microsoft certifications or equivalent qualifications.
Skills:
Data Warehouse SQL Server SSIS SSRS ETL Data Warehouse Development Agile