IT Quality Engineer

Ohio Farmers Insurance Company
United States, Ohio, Westfield Center
Mar 17, 2025
Job Summary The IT Quality Engineer, working under moderate supervision, is responsible to deliver testing solutions utilizing automation, performance, or manual testing techniques for Extract, Transform and Load processes across multiple environments for data warehouses, data marts, fit for purpose marts and landed data. The role is also responsible for validating data, UI, and non-functional requirements for reports, dashboards, and visualizations. The role works to translate business and system requirements into technical requirements for the proposed solution and participates in and increases skill levels in quality planning, quality design and execution. The role also executes the proper mix of manual, automated and exploratory testing methods adhering to automation governance processes. #LI-DNI Job Responsibilities Understand fundamental concepts of data warehousing and data marts and its place in an information management environment, including star schemas, subject areas, and Medallion architecture. Understand how the testing process fits into the data development process. Ability to develop data test strategies, solutions, test plans and test cases - what they are and how to develop them, specifically for data warehouses and decision support systems. Create effective test cases and scenarios based on business and user requirements. Participate in reviews of requirements, data models, data mapping documents, ETL design and ETL coding; providing feedback to product owners, designers and developers. Participates in continuous improvement efforts within the organization research/evaluates new testing technologies and tools. Leverages business knowledge to translate business and system requirements into technical requirements for the proposed solution and participates in and increases skill levels in quality planning, quality design and execution. Identifies quality issues and risks and works with team members to resolve them while adhering to automation governance processes. Participates in and furthers knowledge on the strategic direction of automation or performance discipline and process improvements and builds relationship with product team(s) members and pair programming with software developers to gain an understanding of the code being delivered. Evaluates test data against expected scenarios and create data models as required maintaining documentation of test results to assist in debugging and modification of software. Provides solutions for automated data flow and integration testing and provides test estimates to scrum masters, development leads in preparation of the delivery timelines for sprint/release. Supports for improvements in unit testing coverage, develops test suites, expands automated testing harness, and automates end to end tests conduct for all types of application testing as needed, such as system, unit, regression, load, and acceptance testing methods. Adheres to or learns agile methodology by contributing to team estimation, story card details, acceptance criteria definition and test approach and retrospectives. Job Qualifications 3-5 years of automation and manual testing experience or application programming and/or coding experience. Bachelor's degree in Computer Science, Information Technology, or a related field and/or commensurate experience. Intermediate to Advanced SQL. Beginner to Intermediate Python. Demonstrated working knowledge or experience of Power BI and Cognos tools (Analysis Studio, Query Studio and Standard Reporting). Preferred experience in Property & Casualty and Specialty Insurance. Applicants must be currently authorized to work in the United States on a full-time basis. Location Hybrid defined as three (3) or more days per week in the office preferred. Behavioral Competencies: Collaborates Communicates Effectively Customer Focus Decision Quality Nimble Learning Technical Skills Software Development Lifecycle Data Analysis Manual Testing IT Troubleshooting Software Testing Frameworks Programming Languages Debugging Automation Agile Methodologies Quality Assurance Technical Documentation This job description describes the general nature and level of work performed in this role. It is not intended to be an exhaustive list of all duties, skills, responsibilities, knowledge, etc. These may be subject to change and additional functions may be assigned as needed by management.