Principal Data Architect

Archer; Boston (MA); On-site; USD 120,000 - 180,000; Full time

Job summary

Archer, in partnership with Verisk, seeks a Data Architect to define and execute an architecture that enables trusted data across AWS-based products. You will model, govern, and secure data, bridging engineering, analytics, security, and business teams to deliver durable data products.

You will shape data standards, catalogs, lineage, and privacy controls while guiding platform choices and technology evolution. This role is based in the Boston area with heavy collaboration across teams.

Qualifications

• Significant experience in data engineering, database architecture, analytics engineering, or software engineering with recent ownership of data architecture in AWS environments.
• Strong track record designing enterprise data platforms and data-intensive products for operational and analytical workloads.
• Deep expertise in data modeling (relational, dimensional, NoSQL, domain-driven).
• Strong SQL and database engineering knowledge across PostgreSQL, SQL Server, MySQL, Aurora, Redshift, DynamoDB.

Responsibilities

• Define target data architecture and phased roadmap for operational systems, data lakes, warehouses, and analytics platforms.
• Establish domain-oriented data models and product boundaries to clarify ownership and reduce duplication.
• Design logical/physical models, canonical schemas, event structures, data contracts, and master/reference data approaches.
• Set architecture standards for ingestion, transformation, storage, sharing, retention, and deletion across batch, streaming, API, and event-driven patterns.
• Architect AWS data solutions using services such as S3, Lake Formation, Glue, Redshift, Aurora, RDS, DynamoDB, Kinesis, Lambda, Step Functions, SQS, SNS, and API Gateway.
• Connect transactional apps with BI, analytics, ML, and external use cases without compromising operations.
• Define metadata, cataloging, lineage, quality, observability, semantics, and SLAs for trusted data.
• Embed privacy and security into data design, including IAM, encryption, masking, tokenization, tenant isolation, access controls, auditability, retention.
• Guide database/workload design across relational, NoSQL, warehouse, and object storage technologies.
• Collaborate with product/business teams to translate information needs into data capabilities with clear dependencies and trade-offs.
• Evaluate new AWS services and data patterns through proofs of concept and evidence-based recommendations.
• Provide architecture oversight from discovery to production and coach engineers in effective data design.

Skills

Data architecture

Data modeling

Communication

Leadership

Problem solving

Education

Bachelor's degree in CS/Math/Engineering

Tools

AWS

SQL

Glue

Redshift

S3

Lake Formation

Kinesis

Lambda

Step Functions

SQS/SNS

API Gateway

Aurora

DynamoDB

Job description

Archer is collaborating with Verisk to connect them with exceptional professionals for this role.

Description

We are looking for a Data Architect to establish the architecture, standards, and roadmap that enable trusted data to move effectively across our AWS-based products and platforms. You will connect operational, analytical, and external data needs, defining how data is modeled, integrated, governed, secured, and consumed. The role requires a practical architect who can work across software engineering, data engineering, analytics, product, security, and business teams to turn complex insurance data into durable, reusable data products.

Responsibilities

• Define the target data architecture and phased roadmap for operational systems, data lakes, warehouses, integration services, analytics platforms, and customer-facing data products.
• Establish domain-oriented data models and product boundaries that clarify ownership, reduce duplication, and support consistent use of core business data.
• Design logical and physical models, canonical schemas, event structures, data contracts, and master and reference data approaches across relational, dimensional, and NoSQL environments.
• Set architecture standards for data ingestion, transformation, storage, sharing, retention, archiving, and deletion across batch, streaming, API, and event-driven patterns.
• Architect AWS data solutions using appropriate services such as S3, Lake Formation, Glue, Redshift, Aurora, RDS, DynamoDB, Kinesis, Lambda, Step Functions, SQS, SNS, and API Gateway.
• Connect transactional applications with reporting, business intelligence, advanced analytics, machine learning, and external customer use cases without compromising operational integrity.
• Define expectations for metadata, cataloging, lineage, provenance, quality, observability, semantic consistency, and service levels so data can be understood and trusted.
• Embed privacy and security into data design, including IAM, encryption, masking, tokenization, tenant isolation, policy-based access, auditability, retention, and permitted-use controls.
• Guide database and workload design across relational, NoSQL, warehouse, and object storage technologies, including partitioning, indexing, query patterns, scalability, reliability, and cost.
• Partner with product and business teams to translate information needs into data capabilities, making dependencies, constraints, and trade-offs explicit.
• Evaluate new AWS services, data patterns, and platform capabilities through focused proofs of concept and evidence-based recommendations.
• Provide architecture oversight from discovery through production and coach data engineers, software engineers, analysts, and technical leads in effective data design

Qualifications

• Significant experience in data engineering, database architecture, analytics engineering, or software engineering, including recent ownership of data architecture in AWS environments.
• A strong record of designing enterprise data platforms and data-intensive products that serve both operational and analytical workloads.
• Deep expertise in data modeling, including relational, dimensional, domain-driven, event-based, document, key-value, and other NoSQL approaches.
• Strong SQL and database engineering knowledge across technologies such as PostgreSQL, SQL Server, MySQL, Aurora, Redshift, and DynamoDB.
• Practical understanding of data lake, lakehouse, warehouse, streaming, event-driven, and API-based architecture patterns on AWS.
• Experience designing data pipelines and integrations using services such as AWS Glue, Kinesis, Lambda, Step Functions, SQS, SNS, and APIs.
• Strong knowledge of data governance, metadata, lineage, quality, privacy, security, retention, access control, and the operational ownership of data products.
• Experience using infrastructure as code and CI/CD practices to make data platforms repeatable, controlled, testable, and supportable.
• Ability to communicate complex data concepts, architecture choices, dependencies, and risks to technical teams, product leaders, and business stakeholders.
• Bachelor’s degree in Computer Science, Data Engineering, Software Engineering, Mathematics, or a related discipline, or equivalent professional experience.