Quality Assurance Engineer

Bowhead Specialty; Massachusetts; Presencial; USD 90.000 - 120.000; Jornada completa

Descripción de la vacante

Bowhead Specialty, partnering with American Family, is seeking a Quality Assurance Engineer to support data-focused testing efforts in an agile environment. You will design and execute data quality tests for ETL pipelines and data warehouses, blending manual and automated approaches.

You will collaborate with engineers, data scientists, and business analysts to validate data accuracy, lineage, and governance, while contributing to test strategy and documenting results.

Formación

• 3–5 years of software testing experience.
• Experience with agile development practices.
• Experience with manual testing.
• Experience with automation testing.
• Proficiency writing SQL and working with relational databases.
• Experience with RESTful APIs and Jira.

Responsabilidades

• Develop data process and control improvements with data design.
• Design, develop, and execute test plans for data pipelines and ETL.
• Validate data accuracy, completeness, consistency, and integrity across systems.
• Identify, document, and track data quality issues with engineering.
• Perform data profiling and statistical analysis to detect anomalies.
• Create and maintain automated data quality tests using SQL.
• Develop data validation rules and monitoring for ongoing checks.
• Conduct regression testing for database changes and pipeline mods.
• Validate data transformations and calculations against requirements.
• Partner with data architects to establish data quality standards.

Conocimientos

SQL

Python/Java/C#

Automation testing

Manual testing

Agile practices

Data quality

Herramientas

Jira

REST API testing

Descripción del empleo

Bowhead Specialty, partnering with American Family (rated A XV by A.M. Best) is a best in class insurance underwriting operation focused on Management Liability, Excess Casualty, Errors & Omissions and Healthcare. Our company is dynamic and growing. We encourage those who join us to be active participants in building our future.

Position Summary

We are looking for an experienced Quality Assurance Engineer to assist the QA Lead with both manual and automation testing efforts. They should feel comfortable working independently when needed to design and implement a test plan on their own, as well as working collaboratively in a group. Although at times they will be responsible for writing and executing their own manual and automation test cases, on occasion they will also be asked to execute, monitor, and report on existing test cases. Strong verbal and written communication skills are imperative. The ideal candidate needs a willingness to learn new things, stay focus and up to date on changing requirements, and be passionate about quality assurance. Because of how quickly tasks may change in an agile development approach, it is important that the person in this position is well organized. To succeed at this position, the candidate should have strong, well-rounded, technical skills, be inquisitive, and be able to adapt quickly as the role evolves.

Responsibilities

• Develop data process and control improvements along with data process design.
• Design, develop, and execute comprehensive test plans for data pipelines, ETL processes, and data warehouse solutions.
• Validate data accuracy, completeness, consistency, and integrity across multiple systems and platforms.
• Identify, document, and track data quality issues and work with engineering teams to resolve them.
• Perform data profiling and statistical analysis to detect anomalies and data drift.
• Create and maintain automated data quality tests using SQL and testing frameworks.
• Develop data validation rules and implement monitoring solutions for ongoing data quality checks.
• Conduct regression testing for database changes, schema updates, and pipeline modifications.
• Validate data transformations, aggregations, and calculations against business requirements.
• Partner with data architects to establish data quality standards and best practices.
• Work with business analysts and stakeholders to understand data requirements and acceptance criteria.
• Document test cases, test results, and data quality metrics.
• Participate in code reviews and provide feedback on data pipeline designs from a QA perspective.

Qualifications

• 3 - 5 years of experience in software testing
• Knowledge and experience with agile software development practices
• Experience with manual testing
• Experience with automation testing
• Ability to write code in at least one high level, object-oriented, programming language i.e. Java, Python, C#, etc.
• Proficiency writing SQL and working with relational databases
• Experience with Jira
• Knowledge and experience working with RESTful APIs
• Strong written and verbal communication skills
• Proficient with standard Microsoft office products such as Word, Excel, and Outlook
• Experience with Office 365 tools such as MS Teams, Power Automate, Power Apps
• Knowledge and experience working in the Insurance Industry