Principal Data Architect

Job-:
Information Technology

Location:

Boston, MA, United States Workplace:
Hybrid

Schedule:

Full time Posted:
Short Term Incentive:
Yes Long Term Incentive:
No

Commission:
No

Work Arrangement:
Hybrid Budgeted Salary Currency: USDMinimum Salary: 165,000

Maximum Salary: 185,000

Division:
Catastrophe and Risk Solutions Legal

Employer:

AIR Worldwide Corporation

Disclaimer: Annualized base pay may vary depending on geographic location, job-related knowledge, skills, and experience

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.

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 No

SQL 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.#LI-MB1#LI-Hybrid 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 No

SQL 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…