HimalayasHimalayas logo
AssurantAS

Lead IT QA Analyst

Assurant, Inc. is a global leader in risk management solutions, dedicated to protecting major consumer purchases and enhancing customer experiences through innovative products and services.

Assurant

Employee count: 1001-5000

India only

Stay safe on Himalayas

Never send money to companies. Jobs on Himalayas will never require payment from applicants.

  • 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.

About the job

Apply before

Posted on

Job type

Full Time

Experience level

Location requirements

Hiring timezones

India +/- 0 hours

About Assurant

Learn more about Assurant and their company culture.

View company profile

Assurant is a leading global provider of comprehensive risk management solutions for the auto, lifestyle, and housing protection sectors. We help people thrive in a connected world by supporting major consumer purchases that are integral to modern life, such as homes, vehicles, and electronics. Our significant historical roots go back to 1892 when we began as the LaCrosse Mutual Aid Association, evolving over the past 130 years into a Fortune 500 company that operates in 21 countries.

With more than 13,600 employees worldwide, Assurant focuses on providing innovative and thoughtful solutions that enhance the consumer experience. We partner with several global brands, ensuring consumer confidence by offering protection solutions, risk management products, and customer support services tailored to the unique requirements of our clients. Our strong commitment to digital transformation and sustainability not only meets today's market needs but also anticipates future challenges, helping to protect over 300 million consumers worldwide.

Claim this profileAssurant logoAS

Assurant

View company profile

Similar remote jobs

Here are other jobs you might want to apply for.

View all remote jobs

36 remote jobs at Assurant

Explore the variety of open remote roles at Assurant, offering flexible work options across multiple disciplines and skill levels.

View all jobs at Assurant

Remote companies like Assurant

Find your next opportunity by exploring profiles of companies that are similar to Assurant. Compare culture, benefits, and job openings on Himalayas.

View all companies

Find your dream job

Sign up now and join over 100,000 remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan