IT
Data Warehouse Software Development Engineer
Dublin
← Back to Jobs Board
IT
Data Warehouse Software Development Engineer
Dublin

Responsibilities

  • Devise an environment management strategy for the Data Warehouse and Reporting Test environment instances in collaboration with the team and the QA Practice Lead.
  • Work with the team to define the core QA gates and processes for new Data Warehouse feature development in collaboration with the Quality Practice Lead.
  • Work with the team to define the key QA gates and test approach for functionality delivered by the Data & Analytics team.
  • Build out a core data warehouse regression suite focusing on leveraging automated validation to maximum effect.
  • Validate the source to target mappings using a variety of tools.
  • Reports validation ensuring the finalised reports are an accurate reflection of the source data.
  • Ensure comprehensive and transparent test coverage for new and existing functionality.
  • Ensure the testability of new Data Warehouse features is considered during analysis and development phases.
  • Develop a deep understanding of the E2E flow in the Data Warehouse and the associated BI reporting systems.
  • Test coordination with the relevant User Acceptance Testers to ensure we have an efficient test approach across these phases of test.
  • Implement best of breed, scalable solutions according to defined patterns and practices.
  • Work closely with the Data & Analytics Software Engineers to develop a deep understanding of the underlying SQL Server Integration (SSIS) packages and associated Data transformations.

Key Strengths

  • Excellent MSSQL Server experience and can build and analyse complex SQL queries
  • Experience with Business Intelligence tools such as Microsoft Power BI And SQL Server Reporting Services (SSRS)
  • Experience working with relational data models
  • Experience implementing best-in-class testing strategies, processes, test tools and best practices for databases
  • g strategies and the successful execution of improvement initiatives

Necessary Qualifications / Skills

  • Minimum 3 years’ experience in a similar role.
  • 3rd level qualification (honours degree), preferably in a related discipline.
  • Experience in the financial services background.


Job Reference 130310
Job Duration Permanent
Start Date ASAP
Salary €60000 - €80000 per annum

Apply Now