# Data Architect, BI Analytics Platform
**Company:** [Assured](https://scaleengineer.com/companies/assured)
Data Architect, BI Analytics Platform is a hands-on senior architecture role at Assured, a fintech-focused insurtech company modernizing claims processing. You will design and own the enterprise BI analytics platform architecture, defining schema standards, data governance, lineage tracking, and security patterns while mentoring data engineering teams. This position requires 8+ years of data engineering/architecture experience with deep expertise in Snowflake, dimensional modeling, PII compliance (GDPR/CCPA), and data observability within a regulated insurance environment.
**Role:** Data Architect
**Seniority:** Senior
**Locations:** Remote
**Remote:** yes
**Salary:** 210000–270000 USD
[Apply](https://jobs.ashbyhq.com/assured/45a3f855-c42e-4cf5-b464-b67b2da9cb91)
Canonical: https://scaleengineer.com/jobs/assured/data-architect-bi-analytics-platform
---
## Responsibilities

- Architecture Design & Standardization: Design and implement the complete BI analytics platform architecture using the Medallion pattern (Bronze, Silver, Gold layers), establishing schema design standards, naming conventions, data modeling patterns, and ensuring consistency across all data pipelines. Own schema design reviews and oversee all architectural changes to maintain platform coherence as it scales across the organization.
- Data Lineage & Governance Implementation: Establish end-to-end, column-level lineage tracking from source systems through transformation layers to downstream dashboards and reports. Maintain a comprehensive data catalog and business glossary that enables analysts and stakeholders to understand data provenance, understand metrics, and conduct complete audits of analytical datasets.
- PII & Security Controls: Design and enforce data security controls for handling personally identifiable information and regulated data in compliance with GDPR, CCPA, SOC 2, and insurance industry regulations. Implement data classification schemes, masking policies, row-level access controls (RBAC), object tagging strategies, retention policies, and deletion workflows that protect sensitive data without impeding analytics workflows.
- Data Reliability & SLA Management: Define Service Level Agreements (SLAs), Service Level Objectives (SLOs), and freshness targets for all data products. Design and implement comprehensive monitoring, alerting, and incident response systems that proactively identify data quality breaches, failed transformations, and pipeline failures before they impact downstream consumers and business stakeholders.
- Data Pipeline Architecture & Orchestration: Architect idempotent, recoverable, and cost-aware data ingestion, transformation, and orchestration patterns using tools like Airflow or Dagster. Design solutions for handling backfills, late-arriving data, failure scenarios, and cost optimization while maintaining data integrity and consistency across all pipeline stages.
- Schema Evolution & Change Management: Establish schema versioning strategies and change management processes that enable platform evolution while maintaining backward compatibility with downstream reports and dashboards. Implement controls that prevent breaking changes and enable seamless data model updates across Bronze, Silver, and Gold layers.
- Engineering Excellence & Code Review: Enforce software engineering best practices across the data platform including Git-based version control, mandatory code reviews, CI/CD pipelines, automated testing frameworks, and infrastructure-as-code principles. Implement data quality contracts at each layer boundary and establish metrics for pipeline reliability and performance.
- Team Leadership & Mentorship: Lead influence-based architectural decisions, mentor data engineers and analytics engineers through design reviews and hands-on collaboration, and raise the technical bar across the data organization. Write clear architecture decision records and design documents that transparently communicate trade-offs and technical rationale.
- Cross-functional Stakeholder Engagement: Partner with business analysts, BI developers, data scientists, and business leaders to translate reporting requirements into scalable, maintainable data models. Collaborate with Security, Legal, and Compliance teams on audits, access reviews, and regulatory requirements specific to the insurance industry.

## Requirements

### education

- {"name":"Bachelor's Degree in Computer Science, Engineering, or Related Field","description":"Preferred educational foundation in computer science, software engineering, mathematics, or related quantitative discipline providing strong fundamentals in systems design and data structures."}

### technical

- {"name":"Expert SQL Skills","description":"Advanced proficiency in SQL for complex query design, optimization, and performance tuning. Demonstrated expertise in window functions, recursive queries, query plan analysis, and working with large-scale analytical datasets in production environments."}
- {"name":"Python Programming","description":"Working fluency in Python for data engineering tasks, scripting, pipeline development, and tooling. Ability to write production-grade Python code following best practices and software engineering disciplines."}
- {"name":"Snowflake Data Warehouse","description":"Deep production experience with Snowflake including advanced features such as Role-Based Access Control (RBAC), dynamic data masking, row-level access policies, object tagging, resource monitors, and cost optimization. Understanding of Snowflake architecture, virtual warehouses, and query optimization."}
- {"name":"Data Modeling Expertise","description":"Expert knowledge of dimensional (Kimball) and normalized (3NF) modeling approaches with ability to select appropriate modeling strategy for specific use cases. Ideally includes experience with Data Vault 2.0 methodology for enterprise data warehouses."}
- {"name":"Data Lineage & Catalog Tools","description":"Experience defining and implementing data lineage solutions with familiarity with enterprise catalog tools such as Atlan, Alation, Collibra, DataHub, or equivalent platforms that track data provenance and enable impact analysis."}
- {"name":"Data Orchestration Platforms","description":"Production experience with workflow orchestration tools like Apache Airflow, Dagster, dbt, or equivalent platforms for managing complex data transformation pipelines at scale including error handling and monitoring."}
- {"name":"Infrastructure as Code & DevOps","description":"Proficiency with infrastructure-as-code tools such as Terraform for managing cloud data infrastructure, familiarity with Git workflows, CI/CD pipeline design, and deployment automation in modern data environments."}
- {"name":"Data Security & Compliance","description":"Practical experience implementing data governance frameworks, PII handling, data classification schemes, masking and tokenization techniques, and compliance with regulatory frameworks including GDPR, CCPA, SOC 2, and HIPAA."}
- {"name":"Data Quality & Observability","description":"Experience defining and enforcing data quality metrics, implementing SLAs and SLOs, designing monitoring and alerting solutions, and establishing incident response processes for data reliability."}

### experience

- {"name":"8+ Years Data Engineering & Architecture","description":"Minimum 8 years of professional experience in data engineering, data warehouse design, or data architecture roles working with enterprise-scale analytics platforms and large-scale data processing."}
- {"name":"3+ Years in Architect Accountability Role","description":"Minimum 3 years in a role with architectural accountability for data platform design, schema oversight, standards definition, and decision-making authority on platform direction and technical strategy."}
- {"name":"Production Data Warehouse Experience","description":"Demonstrated experience running and maintaining production data warehouses at scale, including query optimization, cost management, capacity planning, and performance tuning in high-concurrency environments."}
- {"name":"Regulated Industry Experience","description":"Experience working in regulated industries or with regulated data, understanding compliance requirements, audit processes, data residency constraints, and security protocols relevant to financial services or insurance sectors."}

## Skills

### required

- {"name":"Snowflake","description":"Expert-level proficiency with Snowflake data warehouse including RBAC, masking, row access policies, object tagging, resource monitoring, and cost optimization in production at scale"}
- {"name":"SQL","description":"Advanced SQL skills for complex analytical queries, optimization, and performance tuning on large-scale datasets"}
- {"name":"Python","description":"Working proficiency in Python for data engineering, scripting, and pipeline development"}
- {"name":"Dimensional Data Modeling","description":"Expert knowledge of Kimball dimensional modeling and normalized modeling approaches for analytics"}
- {"name":"Data Architecture","description":"Deep expertise in designing enterprise data architectures, schema standardization, and platform patterns"}
- {"name":"Git & Version Control","description":"Proficiency with Git workflows, code review processes, and version control discipline for data infrastructure"}
- {"name":"Data Governance & Lineage","description":"Experience establishing data governance frameworks, lineage tracking, and metadata management"}
- {"name":"PII & Data Security","description":"Track record handling classified and sensitive data with expertise in masking, tokenization, and compliance (GDPR, CCPA, SOC 2)"}

### preferred

- {"name":"dbt (Data Build Tool)","description":"Experience with dbt for data transformation orchestration and workflow automation in Snowflake environments"}
- {"name":"Apache Airflow","description":"Production experience with Apache Airflow for complex data pipeline orchestration and scheduling"}
- {"name":"Dagster","description":"Familiarity with Dagster or similar modern orchestration platforms for data-aware workflow management"}
- {"name":"Terraform","description":"Experience with Terraform for infrastructure-as-code management of cloud data platforms"}
- {"name":"Enterprise Data Catalogs","description":"Experience with tools like Atlan, Alation, Collibra, or DataHub for metadata management and lineage"}
- {"name":"Data Vault 2.0","description":"Expertise in Data Vault 2.0 methodology for enterprise data warehouse design and scalable data architecture"}
- {"name":"Insurance or FinTech Domain","description":"Experience in insurance technology, financial services, or other regulated industries with understanding of domain-specific compliance and operational requirements"}
- {"name":"Machine Learning Pipeline Integration","description":"Experience integrating ML pipelines with data platforms and understanding of feature engineering and model serving infrastructure"}

## Tech stack

### tools

- {"name":"Apache Airflow","description":"Workflow orchestration platform for scheduling, monitoring, and managing complex data transformation pipelines"}
- {"name":"Dagster","description":"Data orchestration framework providing asset-centric pipeline management and observability"}
- {"name":"Terraform","description":"Infrastructure-as-code tool for provisioning and managing cloud data platform resources"}
- {"name":"Git","description":"Version control system for managing data platform code, schemas, and documentation"}
- {"name":"Data Catalogs (Atlan, Alation, Collibra, DataHub)","description":"Metadata management and lineage tools for tracking data provenance and maintaining business glossary"}

### others

- {"name":"CI/CD Pipelines","description":"Continuous integration and deployment automation for data platform changes and infrastructure updates"}
- {"name":"Data Quality Monitoring","description":"Observability and alerting systems for tracking SLAs, SLOs, and data freshness across pipeline layers"}
- {"name":"RBAC & Row-Level Security","description":"Access control and data masking implementations for PII protection and compliance with regulated data handling"}
- {"name":"Schema Versioning & Change Management","description":"Processes and tools for managing backward-compatible schema evolution and minimizing downstream impact"}

### databases

- {"name":"Snowflake","description":"Primary cloud data warehouse platform supporting RBAC, dynamic masking, row-level security, and multi-tenant analytics at scale"}

### languages

- {"name":"SQL","description":"Primary language for data modeling, transformation, and analytics query design across Snowflake platform"}
- {"name":"Python","description":"Used for data engineering scripts, pipeline orchestration, and tooling development"}

### frameworks

- {"name":"Medallion Architecture","description":"Three-layer data warehouse pattern (Bronze raw, Silver conformed, Gold business-ready) forming the foundation of the BI analytics platform design"}
- {"name":"dbt","description":"Data transformation framework for building analytics-ready data models with version control and testing capabilities"}
- {"name":"Kimball Dimensional Modeling","description":"Data modeling methodology for designing facts, dimensions, and slowly changing dimensions in analytics platforms"}
- {"name":"Data Vault 2.0","description":"Enterprise data warehouse methodology for building scalable, auditable, and flexible data architectures"}

## Benefits

### benefits

- {"name":"Competitive Compensation Package","description":"Competitive salary and equity packages aligned with market rates for senior data architecture roles in the insurtech sector"}
- {"name":"Platinum Healthcare Coverage","description":"Comprehensive medical, dental, and vision insurance plans providing platinum-level benefits and coverage"}
- {"name":"Life Insurance & Disability","description":"Complimentary life insurance including long-term disability and short-term disability coverage"}
- {"name":"Unlimited Paid Time Off","description":"Uncapped vacation policy with generous paid holidays allowing flexibility for work-life balance"}
- {"name":"Parental Leave","description":"Comprehensive maternity and paternity leave policies supporting family building and care"}
- {"name":"401(k) Retirement Plan","description":"Company-matched 401(k) contribution of 3% of income provided regardless of personal contribution"}
- {"name":"Remote Work Benefits","description":"Lunch provided twice weekly, monthly phone stipend, home office equipment budget, and other work-from-home perks supporting distributed team productivity"}
- {"name":"Health Savings Accounts","description":"Pre-tax Health Savings Accounts (HSAs) and Flexible Spending Accounts (FSAs) for managing out-of-pocket medical expenses tax-efficiently"}
- {"name":"Team Events & Offsites","description":"Regular company events and offsites despite fully remote work environment, fostering team connection and collaboration"}

## Compensation

- **max:** 260000
- **min:** 180000
- **currency:** USD
- **stockOptions:** true

## Interview process

### steps

## Full description
Assured is on a mission to modernize insurance. Claims processing (i.e. should we pay this claim?), while often overlooked, is the foundation of the entire industry. It’s currently highly manual, involving phone calls, faxes, and gut instinct, costing tens of billions of dollars a year. We can do better.

At Assured, we provide large insurers with the software solutions they need to win in a modern, technology-driven world. From self-service claim-filing software to backend fraud detection, we’re the engine that powers claims processing for some of the largest insurers in the world.

The challenges we face are deep and diverse, from creating digital experiences that provide comfort and clarity to claimants at their most stressed and vulnerable to orchestrating large-scale ML-driven decision-making on billions of dollars of claims payments, life at Assured is dynamic, collaborative, and rewarding.

As a **Data Architect**, you'll define the standards, patterns, and platform that turn raw data into analytics the whole business can trust, designing and building our BI analytics platform.

This is a hands-on architecture role for someone with exceptional engineering discipline. You will set the standards for schema design, lineage, security, PII handling, and delivery SLAs, then hold the platform to them through design review, automation, and oversight. Analysts and business leaders should be able to rely on the numbers without asking where they came from.

## **Some of the Problems You'll Solve:**

🏛️ **Define what a trustworthy analytics platform looks like.**

Design the architecture (ex: Medallion - raw Bronze, conformed Silver, business-ready Gold) and set the modeling standards, naming conventions, and patterns every team follows.

🧬 **Make every number traceable.**

Establish end-to-end, column-level lineage from source system to dashboard, backed by a maintained catalog and business glossary, so any metric can be explained and audited.

🔒 **Handle PII by design.**

Classify sensitive data and build the controls that protect it without slowing analysts down: tagging, masking, row access policies, least-privilege RBAC, and clear retention and deletion rules.

⏱️ **Turn data reliability into commitments.**

Define SLAs, SLOs, and freshness targets for every data product, and design the monitoring and alerting that catch a breach before consumers do.

🔀 **Design how data flows.**

Architect ingestion, transformation, and orchestration patterns that are idempotent, recoverable, and cost-aware, including backfills, late-arriving data, and failure handling.

🧱 **Evolve schemas without breaking people.**

Own schema design review, versioning, and change management so the platform can grow while downstream reports keep working.

## **How You'll Make an Impact:**

🧭 **Own the architecture.**

Be accountable for schema design and oversight across every layer, approving changes through design review and keeping the platform coherent as it grows.

🤝 **Partner with the business and with engineers.**

Translate reporting needs from analysts, BI developers, and business leaders into durable data models, and work with Security, Legal, and Compliance on audits and access reviews.

🧪 **Hold the platform to a high bar.**

Require version control, code review, CI/CD, automated tests, and infrastructure as code for every change, and enforce data quality contracts at each layer boundary.

📝 **Make decisions visible.**

Write architecture decision records and design docs that state the trade-offs plainly and invite challenge.

🧑‍🏫 **Raise the technical bar around you.**

Mentor data engineers and analytics engineers through design review, written guidance, and hands-on collaboration on the problems they own.

## **You'll Probably Thrive Here If You:**

📐 **Have deep data architecture expertise.**

You bring 8+ years in data engineering, architecture, or warehousing, including 3+ years as the accountable architect, with expert SQL and working fluency in Python.

❄️ **Know Snowflake and the Medallion pattern inside out.**

You've run Snowflake (or equivalent) in production at scale, including RBAC, masking and row access policies, object tagging, resource monitors, and cost management. Experience with dbt, Terraform, and an orchestrator like Airflow or Dagster is a plus.

🗂️ **Model data with intent.**

You're expert in dimensional (Kimball) and normalized modeling, ideally Data Vault too, and know when each one fits.

🛡️ **Have a track record with PII and regulated data.**

You've handled classification, minimization, masking or tokenization, retention, and deletion in line with regulations such as CCPA, GDPR, or SOC 2.

🔎 **Believe in lineage and observability.**

You've defined and met data SLAs, with the monitoring, alerting, and incident response to back them. Experience with catalog tools such as Atlan, Alation, Collibra, or DataHub is a plus.

🛠️ **Engineer with discipline.**

Git workflows, code review, CI/CD, automated testing, and environment promotion are second nature. You favor automation over manual process and written decisions over tribal knowledge.

💬 **Lead through influence.**

You can say no to a risky shortcut, explain why, and offer a workable alternative, and you earn trust from engineers and business stakeholders alike.

🔄 **Adapt quickly to new tools and technologies.**

Your judgment and fundamentals matter more than experience with any one tool. Great engineers learn new technologies. Great systems thinking is harder to teach.

**Benefits:**

🤑 Competitive Compensation: Competitive salary and equity packages for all employees

🏥 Healthcare Plan: Platinum medical, dental, and vision

🛡️ Free life insurance: Including long-term disability & short-term disability

🏄 Unlimited PTO: Uncapped vacation days & paid holidays

👶 Family Leave: Maternity & paternity

📈 401(k) Contribution: Assured contributes 3% of your income, even if you don't contribute

🏠 WFH Benefits: Lunch on us 2x/week, monthly phone stipend & other home office perks

👪 Health FSAs & HSAs: Pre-tax accounts for out-of-pocket medical expenses

🤝 Team events & Offsites: We're remote, but we regularly get together 

**\*\*We have been made aware of individuals falsely posing as recruiters from Assured Insurance Technologies Inc. Please note that we only contact candidates from official @**[**assured.claims**](http://assured.claims) **email addresses and all interviews are conducted through verified company channels. If you are unsure whether a message is legitimate, please contact us directly at recruiting-ops@assured.claims before sharing any personal information**\*\*

**Our Commitment:**  
_We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, perform essential job functions, and receive other benefits and privileges of employment. Please contact us to request accommodation._