Lead IT QA Analyst

• Validate enterprise BI solutions aligned to Kimball dimensional modeling (facts, dimensions, conformed dimensions, SCD handling).
• Work with business teams to confirm business rules, acceptance criteria, KPIs, and reconciliation logic for BI/analytics outputs.
• Perform end to end QA across ingestion → transformation → semantic layer → reporting/consumption.
• Analyze TPA client files and record variances.

• Define QA standards, guidelines, and best practices for analytics engineering and reporting teams.
• Use AI tools to build test cases, test data and testing plans wherever applicable.
• Create and maintain test frameworks for:
  • Data correctness (row counts, aggregates, null handling, duplicates)
  • Business rule validation (KPI logic, exclusions, thresholds)
  • Regression testing (pipeline and reporting changes)
  • Data reconciliation (source to target, cross system checks)
• Automate QA activities wherever possible to reduce manual effort and improve release velocity.

• Validate Databricks pipelines (Delta tables, notebooks, jobs, workflows) and SQL transformations (Spark SQL / T-SQL).
• Perform QA of ETL/ELT patterns including incremental loads, CDC patterns, and partitioning strategies.
• Validate SQL Server objects such as stored procedures, views, tables, indexing strategies, and job schedules where applicable.

• Execute performance testing for Databricks jobs and SQL Server queries (query tuning, indexing suggestions, cluster sizing guidance).
• Recommend strategies to improve platform performance, cost efficiency, and workload stability.

• Provide support for production execution and delivery of BI/analytics solutions.
• Support platform upgrades and migrations (Databricks runtime upgrades, cluster policies, SQL Server version changes) in dev/test, including QA sign off and documentation.

• Maintain accurate and complete QA documentation: test plans, test evidence, defect logs, reconciliation results.
• Ensure adherence to corporate policies, governance, and established practices.

• Mentor team members on QA methods, automation, and data validation patterns.

Helping People Thrive in a Connected World
Connect with us. Bring us your best work and your brightest ideas. And we’ll bring you a place where you can thrive. Learn more at jobs.assurant.com.

What’s the culture like at Assurant?
Our unique culture is a big reason why talented people choose Assurant. Named a Best/Great Place to Work in 14 countries and awarded the Fortune America’s Most Innovative Companies recognition, we bring together top talent around the world. Although we have a wide variety of skills and experiences, we share common characteristics that are uniquely Assurant. A passion for service. An ability to innovate in practical ways. And a willingness to take chances. We call our culture The Assurant Way.

Company Overview
Assurant is a leading global business services company that supports, protects, and connects major consumer purchases. A Fortune 500 company with a presence in 21 countries, Assurant supports the advancement of the connected world by partnering with the world’s leading brands to develop innovative solutions and deliver an enhanced customer experience through mobile device solutions, extended service contracts, vehicle protection services, renters insurance, lender-placed insurance products, and other specialty products.

AI and Biometric Usage

Assurant supports the responsible use of Artificial Intelligence (AI), but we want to know the real you. Visit our AI Usage Guidelines page to understand what we expect from applicants regarding their use of AI during the application process.

Employment is contingent upon completion of a required identity verification process, which may include biometric technology, where permitted by applicable law and subject to applicable notice and consent requirements. See our Privacy Notice to learn about Assurant’s privacy practices, including our use of AI-enabled technology, automated decision making, and biometric information.

Equal Opportunity Statement
Assurant is an Equal Employment Opportunity employer and does not use or consider race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, gender identity, or any other characteristic protected by federal, state, or local law in employment decisions.

Job Scam Alert
Please be aware that during Assurant's application process, we will never ask for personal information such as your Social Security number, bank account details, or passwords. Learn more about what to look out for and how to report a scam here.