Data Architect, BI Analytics Platform

Assured; United States; Remote; USD 210,000 - 270,000; Full time

Benefits offered by this job

Competitive salary

Healthcare Plan

Unlimited PTO

401(k) Contribution

Job summary

Assured is seeking a Data Architect to define standards, patterns, and a scalable BI analytics platform, turning raw data into trusted analytics across the business.

You will own schema design, lineage, security, PII handling, and deliverables, with design reviews, automation, and governance to keep reports accurate.

Ideal candidates have 8+ years in data engineering/architecture, Snowflake, dbt, and strong SQL/Python, plus a proven ability to mentor teams.

Qualifications

• 8+ years in data engineering, architecture, or warehousing.
• Experience designing scalable analytics platforms.
• Proven ability to implement data security controls (PII, RBAC).
• Strong SQL and Python capabilities; familiarity with modern data tooling.

Responsibilities

• Own the architecture across all data layers and handle schema design, lineage, and governance.
• Translate business reporting needs into durable data models and catalogs.
• Enforce data quality contracts and implement CI/CD for data products.

Skills

Data architecture

SQL

Python

Snowflake

dbt

Terraform

Airflow

Dagster

RBAC

PII handling

Tools

Snowflake

dbt

Terraform

Airflow

Dagster

Job 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

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.

Compensation Range: $210K - $270K