Data Architect, BI Analytics Platform

Royper Royco LLC; United States; A distancia; USD 140.000 - 180.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Healthcare Plan: Platinum medical, etc

Free life insurance including long/短

Family Leave: Maternity & paternity

401(k) Contribution: Assured 3%

Lunch on us 2x/week

Health FSAs & HSAs

Team events & Offsites

Descripción de la vacante

Assured is modernizing claims analytics with a hands-on Data Architect who defines the standards, patterns, and platform to turn raw data into trusted analytics. You will design schemas, lineage, security, PII handling, and delivery SLAs, and enforce them through design reviews and automation.

The role partners with business and engineering to deliver durable data models and auditable metrics. You will mentor data engineers, drive governance, and ensure data freshness and reliability while

Formación

• 8+ years in data engineering, architecture, or warehousing with 3+ years as accountable architect.
• Deep SQL expertise and fluency in Python.
• Experience running Snowflake in production with RBAC, masking, and row-level security.

Responsabilidades

• Own the architecture across data platforms and set standards for schema design and change management.
• Define end-to-end data flows, lineage, and cataloging with governance.
• Ensure data quality contracts, SLAs/SLOs, and observability across data products.
• Lead design reviews, promote CI/CD, automated tests, and IaC for changes.
• Mentor data engineers and analytics engineers through guidance and collaboration.

Conocimientos

8+ years data engineering/architecture

SQL

Python

Snowflake

dbt

Terraform

Airflow/Dagster

Dimensional (Kimball) modeling

Data Vault modeling

PII handling & data governance

RBAC, data masking

Data lineage & observability

Git, CI/CD, IaC

Architecture review & design docs

Herramientas

Snowflake

dbt

Terraform

Airflow

Dagster

Atlan/Alation/Collibra/DataHub

Descripción del empleo

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

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

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
• Family Leave: Maternity & paternity
• 401(k) Contribution: Assured contributes 3% of your income, even if you don't contribute
• 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.

What the Assured application asks

From 6 application forms we checked.

• Contact details: 6 of 6 forms
• Resume or CV: 6 of 6 forms
• Cover letter: 6 of 6 forms

Application facts

Application form From 6 forms we checked, 6 ask for a cover letter. What it asks

Pay benchmark Data Architect postings that list pay show a $161K median (458 postings)

Pay benchmark Assured postings that list pay show a $177K median (52 postings)

Create an account and this job comes with it: first in line once your profile is set up and your plan has started, and its description waits in your Resume studio for you to tailor your résumé to it.

Uploading lets Applystead's AI read your documents to draft your profile. We don't keep the files. If you don't create an account, the draft is deleted after 7 days. Privacy

Weekly email for Assured jobs

We'll email you once a week with how many new Assured jobs are open. Choose a plan and Applystead applies for you.