Please note, employment offered to residents in the following states only: Connecticut, Delaware, Massachusetts, Maryland, Maine, New Hampshire, New Jersey, New York, Pennsylvania, Rhode Island, Vermont.

At Preferred, we understand the importance of holistic health. To meet the diverse needs of our employees, we offer a comprehensive set of benefits:

Financial

• Short-term disability, long-term disability, and life insurance coverage are provided at no cost
• Optional benefits include enhanced life insurance and critical illness plans
• 401k plan with an employer contribution that you will receive regardless of your own contribution to the plan
• Pension Plan
• Certain positions may also be eligible for short-term incentive plans.

Social

• Generous paid time off, offering of 25 days at hire (prorated based on start date for the first year)
• 7 days of paid sick leave
• 10 paid company holidays
• Personalized paid time off after 3 years!

Emotional

• Access to Modern Health, a provider of accessible, personalized mental health care

Physical

• Medical, dental, and vision coverage options begin on the first day of employment
• Flex Spending Accounts and Health Savings Accounts (with employer contribution) are available based on the medical plan you choose

YOUR PURPOSE AND FUNCTION IN OUR COMPANY:

The Data Quality Assurance (QA) Analyst II is responsible for leading medium to large Agile functional test projects, including the hands-on design, build, and execution of comprehensive functional and automation test strategies, test plans, test cases, and test data for Enterprise data solutions.

This role requires a self-driven individual who is proactive, demonstrates a clear initiative and desire to lead IT and Business team members through key project test efforts (Dev, QA, UAT, Prod) utilizing various techniques and technologies, and sharing this knowledge with others.

You will work closely with data engineers (ETL developers), database administrators, data scientists, and other stakeholders to develop and execute comprehensive testing strategies that guarantee the integrity, accuracy, availability, reliability, and performance of our data solutions.

KEY CAPABILITIES FOR SUCCESS:

• 4 - 6 years’ experience leading and executing Data Quality Assurance testing which includes hands-on experience in manual and automated testing and test data generation for Data Lakes; Data Warehouse models (Star Schemas); ETL; tables; views; cubes; reports; dashboards and inbound/outbound feeds and integrations; applications, and inter-connected systems.
• Ability to self-lead, guide, and direct other team members and coworkers through testing and testing related activities with minimal supervision.
• Strong analytical skills and the demonstrated ability to translate a set of project requirements (for associated and disparate systems) into a cohesive test plan; test strategy; test suite; end to end test; user acceptance test; and/or other similar holistic quality solution for a suite of data lake; data warehouse and business intelligence developed systems; applications, and workflow changes.

KEY Responsibilities:

• Data Validation and Testing:
  • Develop and execute test plans, test cases, and scripts to validate data pipelines, BI reports, dashboards, ETL processes, schemas, tables, stored procedures, queries, jobs and ETL in support of all data lake, data warehouse feeds, functions, data layers and integrations for on-premises and cloud environments.
  • Perform through data quality checks, including data completeness, accuracy, consistency, and timeliness.
  • Identify, document, and track data defects, and work with data engineers (ETL developers) to resolve issues.
• Automation and Continuous Integration:
  • Develop automated test scripts using tools like Python, SQL, or cloud-native testing frameworks.
  • Integrate automated tests into CI/CD pipelines to ensure continuous testing and monitoring of data quality in real-time.
  • Maintain and enhance the automation framework, ensuring it is scalable and adaptable to changing data requirements.
• Reporting and Analytics:
  • Generate reports on data quality metrics, test coverage, and defect rates, providing insights to drive continuous improvement.
  • Develop dashboards and visualizations to track data quality trends over time.

QUALIFICATIONS:

Education

• Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field.
• Relevant experience will be considered in-lieu of a college degree or advanced certification
• Certifications in cloud platforms preferred

Experience

• 5+ years’ experience as a Data QA Analyst, with a focus on cloud environments.
• Proven experience with cloud platforms (preferably Azure) and cloud-native services.
• Strong background in data testing, including ETL, data lakes, data warehousing, and data pipeline validation.
• Predictive analytics experience.

Technical Skills:

• 5+ years’ proficiency in complex SQL, Python, or any other scripting languages used for data testing/data test automation.
• Direct experience with cloud-based data services such as Azure DevOps, Azure Blob Storage, Azure Data Factory, Cloud PowerBI, etc.
• Familiarity with CI/CD tools (Jenkins, GitLab, etc.) and integrating testing into deployment pipelines.
• Knowledge of data quality frameworks and tools.

Other Skills:

• Strong analytical and problem-solving skills, with keen attention to detail.
• Excellent communication skills, with the ability to articulate complex technical concepts to non-technical stakeholders.
• Experience in the Property and Casualty Insurance or Finance industry is a plus.

• Ability to work independently and as part of a team in a fast-paced, dynamic environment.

ABOUT US: As a mutual company, we are independent by nature, so we think about insurance solutions a little differently. Through listening, problem solving, examining your challenges and collaborating on the right solutions for you, Preferred Mutual independent agents provide flexible solutions and adapt to your evolving needs. We do the same for our employees. We are process and domain experts, focused on the solutions that deliver results for our clients and our company. We offer a great work environment, professional development, challenging careers, and competitive compensation. With Preferred, there are no surprises. You can count on us to deliver on our promises and be there when you need us, as your insurance provider and your employer. Preferred Mutual is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, religion, national or ethnic origin, sex, sexual orientation, gender identity or expression, age, disability, protected veteran status or other characteristics protected by law.

DISCLAIMER: This role (job) description indicates in general terms, the type and level of work performed as well as the typical responsibilities of employees in this classification. The duties described are not to be interpreted as being all-inclusive to any specific employee. Management reserves the rights to add, modify, change or rescind the work assignments of different positions and to make reasonable accommodations so that qualified employees can perform the essential functions of the job. Nothing in this position description changes the at-will employment relationship existing between Preferred Mutual Insurance Company and its employees.

The salary range for the role is $78,500 to $120,800 per year paid on a salaried basis. The rate offered to any candidate will be reflective of the candidate’s experience and any relevant education, certification, or qualifications related to their ability to perform the responsibilities of this position as permitted by law.