Bamboo Insurance · 8 hours ago
Data Quality Engineer
United States
Full-time
Remote
Mid Level
$100K/yr - $100K/yr
3+ years expBamboo Insurance is seeking a technically skilled Data Quality Engineer with strong expertise in Property & Casualty (P&C) Insurance data to ensure the accuracy, reliability, and consistency of their enterprise data platforms. This role focuses on data validation, reconciliation, and quality assurance while contributing to automation and continuous improvement.
Financial ServicesInsuranceProperty Management
Responsibilities
Define and maintain the overall data quality test strategy, including coverage for ingestion, transformation, reconciliation, and reporting layers
Design and execute data quality test cases for P&C insurance data including policies, coverages, deductibles, claims, billing, and transactions
Perform data reconciliation across Guidewire PolicyCenter, BillingCenter, Claims systems, data lakes, data warehouses, and reporting platforms
Conduct ETL/ELT testing including source-to-target validation, transformation checks, and schema verification
Implement data profiling and anomaly detection to identify and resolve data issues proactively
Collaborate with data engineers, analysts, and business stakeholders to capture testing requirements, validation rules, and align with test strategy
Create test documentation, defect reports, regression suites, and reusable templates to standardize QA practices
Leverage automation frameworks (e.g., Great Expectations, dbt tests, Soda Core) to augment manual testing, with a focus on reusability and scalability
Support performance and load testing to validate pipeline efficiency
Contribute to data governance initiatives, ensuring compliance with SOX, financial reporting, and insurance regulatory standards
Own the regression testing strategy to ensure continuity and accuracy across releases and platform changes
Qualification
Required
Strong understanding of P&C insurance data structures: policy lifecycle, coverages, claims, premiums, risk scoring
SQL (Advanced): Strong ability to write and optimize queries, joins, aggregations, window functions, and reconciliation scripts
ETL/ELT Testing: Hands-on experience validating mappings, transformations, CDC, and data lineage
Test Strategy & Standards: Experience designing testing approaches, prioritizing test coverage, and defining reusable QA processes
Automation: Familiarity with Python, PySpark, or Bash for scripting repeatable validation checks
Data Testing Frameworks: Exposure to tools like Great Expectations, dbt tests, Deequ, Soda Core, or equivalent
Familiarity with insurance systems (e.g., Guidewire, or legacy PAS) is a strong plus
Cloud & Data Platforms: Experience with Snowflake, AWS (S3, Glue, Lambda, RDS, Redshift), or similar platforms (Azure Synapse, GCP BigQuery)
Data File Formats: Understanding of JSON, Parquet, XML, and other structured/unstructured formats
Versioning & CI/CD: Basic experience with Git and CI/CD pipelines (Jenkins, GitHub Actions, GitLab CI)
Monitoring & Governance: Familiarity with data pipeline monitoring (CloudWatch, Datadog), data governance tools (Collibra, Alation) and compliance testing
Experience with BI/reporting tools like Power BI, Tableau, or Qlik
Bachelor's degree in Computer science, Information Systems, Data Engineering, or related field
2+ years of P&C Insurance Industry experience
3+ years of experience in data testing, quality assurance, or data validation roles
Preferred
Master's degree in Computer science, Information Systems, Data Engineering, or related field
3+ years of P&C Insurance Industry experience
4+ years of experience in data testing, quality assurance, or data validation roles
Company
Bamboo Insurance
We're a modern, customer-focused insurance provider dedicated to simplifying the insurance experience. NPN 18657046. CA License #0M31082.
201-500 employees
H1B Sponsorship
Bamboo Insurance has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2024 (3)
2023 (3)
2022 (2)
2021 (1)
Funding
Current Stage
Growth StageTotal Funding
$28.5MKey Investors
Eos Venture Partners
2025-10-03Acquired
2022-09-19Series A· $16M
2020-10-10Series Unknown· $4M
Leadership Team
J
John Chu
Founder and CEO
Recent News
Columbia West
2025-12-13
PR Newswire
2025-12-08
2025-11-07
Company data provided by crunchbase