QA Analyst

Header

FBD is Ireland’s largest homegrown insurer, supporting consumers, farmers, and businesses nationwide for over 50 years. With a local network of 34 branches and a commitment to genuine customer service, we are uniquely positioned to meet our customers’ needs.

As an Irish-owned company, we take pride in fostering an inclusive environment, evidenced by our Gold Accreditation from Investors in Diversity (IiD) through the Irish Centre for Diversity. Our culturevalues work-life balance and creates a friendly atmosphere where our people can thrive, feel valued and contribute to achieving FBD’s strategic goals.

Job Overview

We are seeking an experienced QA Analyst with a strong focus on SQL and Data Warehouse testing to join our expanding IT team. This individual will play a pivotal role in ensuring the quality of our data warehouse solutions, including the testing of ETL processes, database integrity, and data transformations. The ideal candidate will have a keen eye for detail and a thorough understanding of database architecture, SQL, and data pipeline testing, ensuring that the data solutions we deliver are accurate, consistent, and of the highest quality. This role sits within the pay band C of the IT department.

Job Responsibilities

• Work closely with data engineers, business analysts, and developers to gather both functional and non-functional testing requirements for the data warehouse and related data systems.
• Analyze business and technical requirements, user stories, and data specifications to create comprehensive, traceable test cases for SQL-based data processes, ensuring complete coverage of the data flows from source to destination.
• Write complex SQL queries to verify data transformations, data quality, and data accuracy across various stages of the ETL process, ensuring that data loaded into the data warehouse meets business needs.
• Perform end-to-end testing of ETL processes to ensure data is correctly extracted, transformed, and loaded (ETL) from source systems to the data warehouse.
• Take ownership of data-related defects encountered during testing, logging them clearly in the defect management system and working closely with development teams to resolve issues swiftly.
• Verify data integrity by comparing source data with transformed data, ensuring the consistency, accuracy, and correctness of data in reports, dashboards, and other data outputs.
• Develop detailed test plans, test scripts, and test data for validating SQL-based data systems, ensuring all activities are traceable to requirements and reporting on progress.
• Provide ongoing testing support for data systems and help resolve any issues that arise post-implementation related to data quality.

Job Responsibilities

Education

Experiences

Competencies

This role sits within Pay Band C of FBD’s Pay band.

Footer

FBD is proud to be an Equal Opportunity Employer. We welcome applicants of all ages, genders, ethnicities, cultures, religions, languages, sexual orientations, abilities, disabilities, and social backgrounds.

We are dedicated to fostering a diverse, equitable, and inclusive workplace where everyone is encouraged to bring their whole, authentic self to work. Our approach to inclusion is embedded in our hiring practices, pay structures, leadership development, and workplace policies. At FBD, we believe that when our people feel valued and supported, they thrive, and so does our business. We are proud to foster a culture of collaboration, respect, and shared success at every stage of your career.