Data Quality Assurance Lead

Great American Insurance Group

Cincinnati, OH

Full Time

Senior

5 days ago

Job Description

About the Role

The Data Quality Assurance Lead at Great American Insurance Group is responsible for overseeing data testing processes within the P&C IT Services team. The role involves leading a small team, ensuring quality in ETL and data warehouse validation, and working in a hybrid schedule out of the Cincinnati office. The company values diversity, inclusion, and a collaborative culture, combining small company agility with large company expertise to foster employee growth and success.

Key Responsibilities

Provide expertise in ETL, Snowflake, Python, and test automation in data testing.
Perform moderately complex test case and procedure development, test management functions, and tasks.
Analyze requirements, test coverage, and impact of proposed requirement changes.
Conduct peer reviews of test artifacts.
Lead and mentor a small team of employees and contractors.
Create, design, and execute test plans and test cases covering ETL processes and Data Warehouse validation.
Collaborate with project teams to understand business use cases and develop data testing strategies.
Coordinate User Acceptance Testing (UAT) in their end-to-end testing process.
Work on continuous process improvements.
Champion quality improvement across the Software Development Lifecycle.
Participate as an agile development team member, creating and testing product increments.

Requirements

8 to 10+ years of experience in ETL testing and BI testing.
3 to 5 years of experience in leading a team.
Experience in creating and analyzing SQL, from simple to complex.
Knowledge of database objects and relational data models.
Good understanding of various database technologies such as DB2, Teradata, Oracle 10g/11g, SQL Server, Big Data/Hadoop.
Knowledge of cloud-based testing environments like MS Azure, IICS, Snowflake.
Exposure to Oracle SQL Developer, Toad, Hive, Toad Data Point, etc.
Experience with data automation validation tools like Informatica DVO, Katalon, and Python (preferred).
Experience in executing functional, regression, integration, and end-to-end testing.
Good understanding of agile testing processes, test strategy planning, and reporting.
Excellent verbal and written communication skills.
Experience and desire to work in a global delivery environment.

Nice to Have

Knowledge of the insurance domain.

Qualifications

Formal experience in ETL and BI testing.
Leadership experience in managing testing teams.

Benefits & Perks

Competitive Total Rewards package including medical, dental, and vision plans starting on day one.
Paid time off (PTO), holidays, and commuter benefits.
Employee stock purchase plan.
Education reimbursement.
Paid parental leave and adoption assistance.
401(k) plan with company match.

Working at Great American Insurance Group

Great American Insurance Group values diversity and fosters an inclusive culture where employees from different backgrounds work collaboratively. The company combines a 'small company' culture where ideas are heard with 'big company' expertise, emphasizing employee growth, inclusion, empowerment, and high performance.

Apply Now