> Markdown version of [/jobs/ext/1956604-data-quality-lead-microsoft-azure-power-bi-hybrid-farmington-ct-or-morristown-nj](https://www.wearedevelopers.com/jobs/ext/1956604-data-quality-lead-microsoft-azure-power-bi-hybrid-farmington-ct-or-morristown-nj). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Quality Lead (Microsoft Azure / Power BI) Hybrid - Farmington, CT or Morristown, NJ - **Company:** Arch Capital Group Ltd - **Location:** Morristown, NJ, United States - **Experience:** Expert - **Salary:** $140,000.0 - $160,000.0 - **Contract:** Permanent contract - **Skills:** Testing (Software), Data Analysis, Automation of Tests, Microsoft Azure, Software Bug Management, Cloud Database, Data Validation, Data Integrity, Data Masking, Data Warehousing, Database Testing, DevOps, IBM Cognos Business Intelligence, SQL Azure, Raw Data, Role-Based Access Control, Regression Testing, Release Management, Power BI, Standard Sql, SQL Databases, SQL Server Reporting Services, Tableau (Software), Azure Data Factory, Sql Optimization, Snowflake, Powerquery, Information Technology, Tools for Reporting - **Published:** August 6, 2026 - **Apply:** https://www.careerjet.com/job/usb5b7f5d7bda6b72d7277b461cdc39d69/eaa ## About the Role * Deep understanding of QA methodologies, testing tools, defect management, and Agile/Scrum delivery practices. * Advanced SQL skills, including complex joins, CTEs, window functions, data reconciliation, and data validation techniques. * Strong experience with Power BI Desktop and Service, including DAX, Power Query (M), and report validation; experience with Tableau, Cognos, SSRS, or similar BI tools is beneficial. * Strong analytical and problem-solving skills, with the ability to identify data anomalies, root causes, and reporting issues. * Experience in reinsurance, insurance, or financial services, including familiarity with treaties, premiums, claims, and loss triangles. * Experience working with third-party vendors and cross-functional business and technology teams to deliver quality solutions. * Excellent communication, organizational, and stakeholder management skills. * Strong business orientation with a demonstrated ability to deliver quality outcomes aligned with organizational objectives. Required Education/Experience * Bachelor's degree in Computer Science, Management Information Systems, Information Technology, or a related field required. * Minimum of 5+ years of Data Warehouse, Reporting, Data Quality, or Data Testing experience. * Strong experience with Azure cloud technologies, including Azure Data Factory (ADF), Azure DevOps, Azure SQL, and other Azure-based data platform solutions. * Strong hands-on SQL skills with experience validating, reconciling, and analyzing data used for reporting. * Experience testing and validating reporting data for accuracy, completeness, consistency, and overall data quality. * Experience performing data-focused QA testing, including validation of reporting outputs, business rules, and reporting logic, rather than application UI or workflow testing. * Experience testing financial, insurance, reinsurance, regulatory, or operational reporting solutions. * Experience with Power BI reporting validation and testing strongly preferred; experience with other reporting and BI platforms such as Tableau, Cognos, SSRS, or similar tools will also be considered. * Experience developing, executing, and maintaining QA automation and automated regression testing for data and reporting platforms. * Experience creating audit-ready testing documentation, test evidence, and user sign-off materials to support internal controls, compliance, and external audit requirements. * Experience working within the insurance, reinsurance, financial services, or other regulated industries. * Strong analytical, problem-solving, and communication skills with the ability to work effectively across business and technology teams. #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. ## Description As a Data Quality Lead, 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 or Morristown, NJ, with an expectation of regular in-office collaboration 3x a week., * 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 ## Related Videos - [Data Governance in the Era of AI](https://www.wearedevelopers.com/videos/1622-data-governance-in-the-era-of-ai) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Blueprints for Success: Steering a Global Data & AI Architecture](https://www.wearedevelopers.com/videos/1577-blueprints-for-success-steering-a-global-data-ai-architecture) - [From DevOps to Scaled DevOps: How We’re Rebuilding Continuous Delivery as a Platform](https://www.wearedevelopers.com/videos/100018-from-devops-to-scaled-devops-how-we-re-rebuilding-continuous-delivery-as-a-platform) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Bringing Clarity to Event Streams: Enabling Analytics and AI Through Rich Metadata](https://www.wearedevelopers.com/videos/1616-bringing-clarity-to-event-streams-enabling-analytics-and-ai-through-rich-metadata) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Best Companies to work for in London: Top 25 Companies in 2023](https://www.wearedevelopers.com/magazine/187-best-companies-to-work-for-in-london-top-25-companies-in-2023) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany)