Data Architect, BI Analytics Platform

The role

You will design and build a BI analytics platform by defining standards, patterns, and architecture. You will oversee schema design, data lineage, security, and delivery SLAs to ensure data reliability.

What you will do

• Design the architecture and set modeling standards, naming conventions, and patterns.
• Establish end-to-end, column-level lineage from source system to dashboard.
• Classify sensitive data and build controls like tagging, masking, and RBAC.
• Define SLAs, SLOs, and freshness targets for every data product.
• Architect ingestion, transformation, and orchestration patterns.
• Own schema design review, versioning, and change management.
• Translate reporting needs from analysts and business leaders into durable data models.
• Work with Security, Legal, and Compliance on audits and access reviews.
• Enforce version control, code review, CI/CD, automated tests, and infrastructure as code.
• Mentor data engineers and analytics engineers through design review and collaboration.

Required qualifications

• 8+ years in data engineering, architecture, or warehousing
• 3+ years as the accountable architect
• Expert SQL
• Working fluency in Python
• Experience running Snowflake (or equivalent) in production at scale
• Experience with RBAC, masking and row access policies, object tagging, resource monitors, and cost management
• Expert in dimensional (Kimball) and normalized modeling
• Track record with PII and regulated data (CCPA, GDPR, or SOC 2)
• Experience defining and meeting data SLAs with monitoring and alerting
• Proficiency in Git workflows, code review, CI/CD, automated testing, and environment promotion

Nice to have

• Experience with dbt, Terraform, and an orchestrator like Airflow or Dagster
• Data Vault modeling
• Experience with catalog tools such as Atlan, Alation, Collibra, or DataHub

Benefits

• Competitive salary and equity packages
• Platinum medical, dental, and vision
• Free life insurance including long-term disability and short-term disability
• Unlimited PTO including uncapped vacation days and paid holidays
• Maternity and paternity leave
• 401(k) contribution of 3% of income
• Lunch 2x/week
• Monthly phone stipend
• Home office perks
• Health FSAs and HSAs

Before you apply

• Assured only contacts candidates from official @assured.claims email addresses
• All interviews are conducted through verified company channels

About the company

Assured provides large insurers with software solutions to modernize insurance and claims processing. They act as the engine that powers claims processing for some of the largest insurers in the world.