Position Details

Salary $120K – $125K USD / year

Type Full-Time

Experience senior

Exp. Years 15+ years (minimum 5+ years in Insurance Domain)

Education Not specified

Category Data & Analytics

About this role

Violet Ink is seeking a Data Architect to design and maintain the data infrastructure that enables storage, access, and analysis for insurance-related business and client needs. The role leads data architecture strategy, ETL pipeline architecture, and governance to ensure scalability, security, and performance.

Key Responsibilities

Define data architecture strategies, frameworks, and models
Design and optimize databases, warehouses, and data lakes
Ensure data structures meet business and compliance needs
Oversee metadata management, catalogues, and lineage tracking
Select storage and cloud platforms (e.g., Snowflake, AWS, Azure, BigQuery, Redshift)

Technical Overview

You will design data architectures and models, select technologies, and oversee implementation across data warehouses and data lakes. The technical focus includes ETL development using Databricks on Amazon Web Services (AWS), with hands-on Python, PySpark, and SQL, plus support for lineage tracking, metadata management, and governance.

Ideal Candidate

The ideal candidate is a senior data architect with 15+ years of data engineering/architecture experience and a minimum of 5+ years in the insurance domain. They have led end-to-end data architecture and ETL pipeline design using Python, PySpark, SQL, Databricks, and Amazon Web Services (AWS), with strong data governance, metadata, and lineage management skills.

Must-Have Skills

5+ years Insurance Domain15+ years experienceInsurance domainETLPythonPySparkAWS (Amazon Web Services)data architecturedata modelingDatabricksSQL

Nice-to-Have Skills

SnowflakeAzureBigQueryRedshiftdata lineage and metadata catalogues

Tools & Platforms

DatabricksAmazon Web Services (AWS)SnowflakeAzureBigQueryRedshift

Required Skills

Insurance DomainETLPythonPySparkAWS (Amazon Web Services)DatabricksSQLdata architecturedata modelingdata governancemetadata managementlineage tracking

Hard Skills

data architecture strategiesdata architecture frameworks and modelsdata modelingdatabase designdata warehouse designdata lake designdata governancedata access control policiesmetadata managementmetadata catalogueslineage trackingdata integrityscalabilityperformance optimizationETL pipelinesPythonPySparkSQLDatabricksAWS (Amazon Web Services)data analytics design and implementation using Databricksdeveloping and implementing ETL pipelines from various data sources using Databricks on cloud AWSmigrating or improving existing systemsdocumenting technical standards and architectural decisions

Soft Skills

collaborating with engineers (clients)collaborating with analystscollaborating with compliance teamsstakeholder communicationdocumentation and knowledge sharingstrategic thinkingrequirements understanding

Industry & Role

Industry Insurance

Job Function Lead data architecture and ETL pipeline design for insurance-domain data platforms on cloud

Role Subtype Cloud Architect

Tech Domains Amazon Web Services, Python, SQL / PostgreSQL, Data Integration, Azure, Snowflake, BigQuery, Databricks

Keywords for Your Resume

Data Architectdata architecturedata modelingdata governancedata access control policiesmetadata managementlineage trackingdata integrityETLPythonPySparkSQLDatabricksAmazon Web ServicesAWSdata warehousedata lakeSnowflakeAzureBigQueryRedshiftinsurance domainInsurance DomainAWS (Amazon Web Services)data lineage

Deal Breakers

Must have 5+ years Insurance Domain experience (minimum stated), Must have Python, PySpark, ETL, and AWS (Amazon Web Services) experience, Must have 15+ years experience (as stated)

Apply for this Position →

Get matched to jobs like this

Luna finds roles that fit your skills and career goals — no endless scrolling required.

Create a Free Profile