Data Quality Assurance Engineering Lead

Be Here. Be Great. Working for a leader in the insurance industry means opportunity for you. 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. At Great American, we value and recognize the benefits derived when people with different backgrounds and experiences work together to achieve business results. Our goal is to create a workplace where all employees feel included, empowered, and enabled to perform at their best. 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. IT Services can include a wide range of activities such as: software development, data management, Cloud services, IT security, network security, technical support, establishing and overseeing access rights, procuring and maintaining equipment or software, managing the infrastructure, and defining security procedures, The overall goal of IT Services is to provide technology solutions that increase efficiency, reduce costs, and give our company a competitive advantage over our competitors. The Quality Assurance team within P&C IT Services is seeking a Data Quality Assurance Lead. This individual will work a hybrid schedule if in the greater Cincinnati area; if outside of Cincinnati, the expectation will be to come to the office once a week. Scope of Job: Provides Expertise in ETL, Snowflake, Python , test automation in data testing. 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. Planning, Monitoring and Control of Testing Activities and Tasks. Creates, designs, and executes the test plans and test cases which covers ETL process and Data Warehouse validation. Plays a major role in championing the importance in quality improvement across all areas of Software Development Lifecycle. Collaborates with Project teams to understand the business use case and build a data testing strategy. Performs work under moderate supervision and ability to lead and mentor a small team of employees and contractors May serve as an agile development team member, creating and testing the product increment. Knowledge, Skills and Experience Essential Job Functions and Responsibilities: 8 to 10+ years of experience in ETL testing, BI testing, 3 to 5 years of experience in leading teams. Experience in creating/analyzing simple to complex SQL. Knowledge on Database objects and relational data models, and a good understanding of various database technologies (DB2, Teradata, Oracle 10g/11g, SQL server, Big data/Hadoop). Knowledge of Cloud (MS Azure, IICS, Snowflake) based testing. Exposure to Oracle SQL Developer, Toad, Hive, Toad Data point etc. Good exposure to Data automation validation tools like Informatica DVO, Katalon etc., and data automation using Python. Good exposure in executing Functional, Regression, Integration and E2E testing. Good exposure to agile testing process, test strategy planning and implementation, test execution monitoring and reporting. Knowledge on Insurance Domain is plus. Experience and desire to work in a Global delivery environment. Business Unit: Property & Casualty IT Services Salary Range: $107,200.00 -$146,800.00 Benefits: We offer competitive benefits packages for full-time and part-time employees*. Full-time employees have access to medical, dental, and vision coverage, wellness plans, parental leave, adoption assistance, and tuition reimbursement. Full-time and eligible part-time employees also enjoy Paid Time Off and paid holidays, a 401(k) plan with company match, an employee stock purchase plan, and commuter benefits. Compensation varies by role, level, and location and is influenced by skills, experience, and business needs. Your recruiter will provide details about benefits and specific compensation ranges during the hiring process. Learn more at http://www.gaig.com/careers. *Excludes seasonal employees and interns. Great American Insurance Group understands the importance of choosing a financially strong company. We are an organization built for the long term and are committed to giving you that strength. Why can you trust Great American Insurance Group? For nearly 150 years, Americans have trusted us to protect them. Our innovative insurance solutions and specialization serves niche marketplaces that we know well. This expertise gives us a successful foundation that spans generations. You never know where a career in insurance will take you. Whether you are starting your career or are looking for a company to grow your experience, at Great American Insurance Group, you can join our more than 8,500 employees to “Be Here. Be GREAT!” To learn more, visit our Career Page

Back to blog
Ads

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...