Senior Data Quality Assurance Engineer

Senior Data QA Engineer

Position Overview

Great American Insurance Group's member companies are subsidiaries of American Financial Group. We combine a "small company" culture where your ideas will be heard with "big company" expertise to help you succeed. With over 30 specialty and property and casualty operations, there are always opportunities here to learn and grow.

P&C IT Services provides professional services to help our business units and corporate functions use technology to create, manage, and optimize information and business processes. The Quality Assurance team within P&C IT Services is seeking a Senior Data QA Engineer to work a hybrid schedule out of the Cincinnati office.

Scope of Job

Performs moderately complex test case/procedure development, test management functions and tasks. Performs moderately complex analysis of requirements, test coverage and impact of proposed requirements changes. Conducts peer reviews of test artifacts. Performs work under moderate supervision. May serve as an agile development team member, creating and testing the product increment.

Knowledge, Skills and Experience

Essential Job Functions and Responsibilities:

• 3 to 6+ years of experience in ETL testing, BI testing.
• Planning, Monitoring and Control of Testing Activities and Tasks.
• Experience in creating/analyzing simple to complex SQL.
• Create, design, and execute the test plans and test cases which covers ETL process and Data Warehouse validation.
• Knowledge on Database objects and relational data models.
• Good understanding of various database technologies (DB2, Teradata, Oracle 10g/11g, SQL server, Big data/Hadoop).
• Knowledge of any Cloud (MS Azure, IICS, Snowflake) based testing.
• Should have exposure to Oracle SQL Developer, Toad, Hive, Toad Data point etc.
• Good exposure to Data automation validation tools like Informatica DVO, Katalon etc.
• Data automation using Python is good to have.
• Good exposure in executing Functional, Regression, Integration and E2E testing.
• Knowledge on Insurance Domain is a plus.
• Good exposure to agile testing process, test strategy planning and implementation, test execution monitoring and reporting.
• Play a major role in championing the importance in quality improvement across all areas of Software Development Lifecycle.
• Excellent verbal and written communication skills.
• Experience and desire to work in a Global delivery environment.

Company Information

Great American Insurance Group is a leader in the insurance industry. We value diversity and recognize the benefits gained when people from different cultures, backgrounds and experiences work collaboratively to achieve business results. We are intentionally focused on fostering an inclusive culture and know valuing diversity is an essential leadership quality. Our goal is to create a workplace where all employees feel included, empowered and enabled to perform at their best.

Employment Type

Full time

Location Type

Hybrid (Cincinnati office)

Benefits

Compensation varies by role, position level, and location. Individual pay is influenced by skills, education, training, certifications, experience, and the role's scope and complexity, along with business needs.

We offer a competitive Total Rewards package, including:

• Medical, dental, and vision plans starting on day one
• Paid Time Off (PTO)
• Paid holidays
• Commuter benefits
• Employee stock purchase plan
• Education reimbursement
• Paid parental leave/adoption assistance
• 401(k) plan with company match