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 culture values 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

• Third Level Qualification in Computer Science / IT or relevant work experience.
• ISTQB foundation level certificate
• MS/Azure certifications desirable

Experiences

• Minimum of 5 years’ experience in QA testing, with a strong focus on SQL and Data Warehouse testing (including ETL and database validation).
• Hands-on experience writing and executing SQL queries for testing purposes, including complex joins, subqueries, and data validation scripts.
• Experience with test management tools such as JIRA, TestRail is highly desirable for tracking defects and managing test cases.
• Experience with data validation and reconciliation, ensuring data in reports and dashboards reflects accurate, real-time information.
• Familiarity with data versioning, data schema validation, and ensuring consistency across different data environments (e.g., development, testing, and production).

Competencies

• Strong analytical skills with the ability to interpret complex requirements, test data flows, and ensure that business logic is correctly implemented in data transformations.
• Experience with database management systems like Microsoft SQL Server, Oracle, MySQL and tableau
• Attention to detail for identifying inconsistencies and defects in large datasets.
• A good understanding of the software development lifecycle (SDLC), particularly within agile environments.
• Proactive mindset with the ability to take ownership of the testing process and ensure quality is embedded at every stage of development.
• Strong communication skills to work effectively with cross-functional teams, providing feedback and clear documentation on test cases and issues.

MCC

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.