Arch Capital Group Ltd.

Data Quality Lead – Reinsurance Data Platform (Hybrid - Farmington, CT)

Arch Capital Group Ltd.  •  $140k - $160k/yr  •  Farmington, CT (Hybrid)  •  3 months ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

With a company culture rooted in collaboration, expertise and innovation, we aim to promote progress and inspire our clients, employees, investors and communities to achieve their greatest potential. Our work is the catalyst that helps others achieve their goals. In short, We Enable Possibility℠.

The Position

As a Data Quality Lead – Reinsurance Data Platform, you will be responsible for leading quality assurance efforts of Reinsurance Datawarehouse Application used extensively by Reinsurance business teams. The QA lead will work closely with the rest of the Arch Re product management team and business peers to effectively check quality and prepare evidence for Business and Audit signoff for Datawarehouse and Business intelligence project initiatives. The Role will be overseeing the full QA process to ensure reliable, high-quality software delivery. This role establishes and communicates QA standards, coordinates all aspects of software testing, and ensures alignment with business objectives. The ideal candidate has hands-on experience validating complex data transformations, managing test automation for pipelines, and leading cross-functional teams on cloud data in high scale environments, driving continuous improvement of our data quality and delivery in a fast-paced and deadline-driven environment.

Location / Work Arrangement

This is a hybrid role based in the Farmington, CT office, with an expectation of regular in-office collaboration.

Job Responsibilities

  • Lead QA efforts of Reinsurance Datawarehouse Application releases
  • Critically analyze business requirements, build and execute QA test plan for Datawarehouse solutions.
  • Design the Master Test Plan (MTP) for data projects, choosing between manual spot-checks and automated regression suites
  • Lead a team of QA Analysts, reviewing their SQL scripts and test cases
  • Work with DevOps to integrate automated data tests into the deployment pipeline
  • Implement automated checks for data completeness and referential integrity within Snowflake
  • Verify Role-Based Access Control (RBAC) and data masking (PII/Sensitive financial data) to ensure compliance with GDPR or industry-specific regulations
  • Reconcile Power BI report against Snowflake raw data and source systems using complex SQL
  • Establish, maintain, and communicate quality assurance standards, procedures, and policies, including guidelines and best practices for test environment management.
  • Work closely with product manager to develop and execute action plans to address gaps if any
  • Produce quality control evidence for business and audit approval, as required
  • Lead User Acceptance Testing with Finance, Actuaries and Underwriters to ensure solution meets business needs
  • Communicate effectively with both the business and technical teams
  • Desired Skills

  • Extensive experience in software testing, including large-scale implementations, test automation, and data-driven frameworks.
  • Deep understanding of QA methodologies, tools, and Agile/Scrum practices.
  • Expert SQL skills (Window functions, CTEs, JSON parsing).
  • Proficiency in Power BI Desktop/Service, including DAX, Power Query (M),
  • Strong business orientation, delivering quality results aligned with organizational goals.
  • Excellent communication, organizational, analytical, and problem-solving skills.
  • Experience in Reinsurance or General Insurance (understanding of treaties, premiums, claims, and loss triangles).
  • Strong experience in Agile/Scrum environments and JIRA for defect tracking.
  • Experience with data testing automation.
  • Relevant experience working with 3rd party vendors delivering results.

Required Education/Experience

  • Bachelor’s degree in computer science, Management of Information Systems, or related field required
  • Minimum of 5+ years of Datawarehouse Testing experience.
  • Testing Automation experience.
  • Experience in ReinsuranceInsurance or financial organization
  • Good Communication Skills

Working Conditions/Environment & Physical Demands

  • Normal office environment – The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this Job. Reasonable accommodations will be made to enable qualified individuals with disabilities to perform the essential functions of the Job.
  • Attendance/Punctuality – Is consistently at work and on time; Ensures work responsibilities are covered when absent.

Disclaimer

Incumbent may be asked to perform other duties as required.

#LI-Hybrid
#LI-ZP1

For individuals assigned or hired to work in the location(s) indicated below, the base salary range is provided. Range is as of the time of posting. Position is incentive eligible.

$140,000 - $160,000/year

  • Total individual compensation (base salary, short & long-term incentives) offered will take into account a number of factors including but not limited to geographic location, scope & responsibilities of the role, qualifications, talent availability & specialization as well as business needs. The above pay range may be modified in the future.

  • Arch is committed to helping employees succeed through our comprehensive benefits package that includes multiple medical plans plus dental, vision and prescription drug coverage; a competitive 401k with generous matching; PTO beginning at 20 days per year; up to 12 paid company holidays per year plus 2 paid days of Volunteer Time Offer; basic Life and AD&D Insurance as well as Short and Long-Term Disability; Paid Parental Leave of up to 10 weeks; Student Loan Assistance and Tuition Reimbursement, Backup Child and Elder Care; and more. Click here to learn more on available benefits.

Do you like solving complex business problems, working with talented colleagues and have an innovative mindset? Arch may be a great fit for you. If this job isn’t the right fit but you’re interested in working for Arch, create a job alert! Simply create an account and opt in to receive emails when we have job openings that meet your criteria. Join our talent community to share your preferences directly with Arch’s Talent Acquisition team.

10200 Arch Capital Services LLC

Arch Capital Group Ltd.

About Arch Capital Group Ltd.

Arch is a leading global insurer with operations in more than a dozen countries. We write insurance, reinsurance and mortgage insurance on a worldwide basis, with corporate headquarters in Bermuda.

Our customers value us as an innovative partner and dependable risk manager with decades of fresh ideas and solid results. Since our formation in 2001, Arch has grown organically, by building capacity in diverse lines of insurance, and through targeted acquisitions of businesses that enhance our offerings and fit our culture.

We see our employees as our greatest asset and we’re deeply committed to doing what’s right for our people and the communities where we live and work. That’s why we offer what matters to our expanding, diversifying team — from a collaborative and creative environment, to professional growth opportunities and forums to advocate for one another and spark change.

As a corporation, we support initiatives to improve housing, education and equity around the world. At the same time, we encourage our employees to give to the causes that matter to them by providing Volunteer Time Off and Matching Gifts programs.

Whether you’re looking for an insurance solution, a place to grow your career or simply to better understand what we offer our shareholders, we’re glad you’re here.

ATTENTION JOB SEEKERS

Arch Capital Group Ltd. (Arch) and its affiliates take your interest in working here very seriously.

If you receive a communication or email, please be vigilant to fraudulent activity asking you to submit any personal information. DO NOT send money or share any details with someone suggesting they can provide employment with Arch. Your information should only be entered into our official job portal.

Please know the following about our interviewing and hiring practices:

We never make job offers without a formal interview process. We never ask you to send money of any kind.

Industry
Finance & Insurance
Company Size
1,001-5,000 employees
Headquarters
Bermuda (Pembroke, BM
Year Founded
Unknown
Social Media