Data and Analytics Architect

ABOUT THE ROLE:

We believe analytics isn't a back-office function. It's not a reporting layer bolted onto the business after the real decisions get made. It's the foundation that tells you where risk actually lives, where growth is hiding, and where you're missing opportunities before it's too late to do anything about it. 

That belief is driving real investment in our people, platforms, and in how deeply analytics is woven into the way we operate. From underwriting to distribution to customer experience, we're building a data culture where insight drives action.  

It also means evolving how we think about the role of aDataand Analytics Architect. 

The expectation isn’t just technical execution. It’s curiosity. Ownership. The ability to step into ambiguity, frame the problem, and help guide the business toward better decisions. 

WHAT YOU’LL DO:

In thisroleyou willbedesigningandgoverningscalable data platforms on the Microsoft cloud. Key responsibilities includebridging the gap between complex core insurance systems (Policy Admin, Claims, Billing) and our analytical consumers, implementing datalakehousearchitectures, ensuring data governance, and leading cloud migrationsandplatform integrations. Ideal candidatesrequireexpert-levelproficiencyinAzure data services and data modeling. You will collaborate with data scientists, analysts, and business leaders to turn raw data into scalable, production-ready assetsforreal-time analytics engines, portfolio risk platforms, and client-facing digital products.

Data Architecture & Modeling

• Design secure, scalable, and resilient data architectures using the medallion (Bronze/Silver/Gold) pattern andDelta Lakepattern in close partnership withthe Enterprise Innovation& Technology(I & T)organization.

• Lead physical and logical data modeling efforts across relational, dimensional (Kimball / Star Schema), and Data Vault methodologies.

• Develop high-performance data processing logic usingPySpark, Spark SQL, and Python onAzure Databricksand Synapse Analytics.

• Define data abstraction layers ensuring third-party SaaS and legacy databases map cleanly to machine-readable schemas forefficient and measurableconsumption.

• Architect secure, scalable Model Context Protocol (MCP) servers and gateways to connect LLMs and AI agents to internalanalyticaldata repositories.

Platform & Engineering Standards

• Establish architectural patterns and best practices for data ingestion, transformation, and pipeline orchestration.

• Evaluate, benchmark, and recommend components of our modern data stackin alignment withI & T’s strategyandbe an active participant/contributor to the Architecture Review Board.

• Work closely with Data Engineers to conduct architecture reviews and mentor engineers on scalability and pipeline efficiency.

• Architect semantic layer solutions and data product structures to power self-servicePowerBIimplementations.

• Architect high-throughput batch and streaming pipelines to ingest structuredtransactionalpolicy/claims data as well as unstructured data (e.g., adjuster loss notes, FNOL images, aerial and satellite imagery surveys).

• Collaborate with Data Science and Machine Learning teams to ensure clean, structured feature stores and data pipelines forfutureML models and applications.

Governance, Quality & Security

• Implement automated data quality monitoring, data lineage tracking, and metadata management frameworksacross the data lifecycle.

• Partner withthe Enterprise Technology andSecurityand Compliance teams to enforce role-based access control (RBAC), data masking, and compliance standards (SOC 2, GDPR, CCPA).

Architectural Leadership

• Partner with theI & Tarchitecture team tobuild andoptimizecomplex ETL/ELT workflowsutilizingAzure Data FactoryandMicrosoft Fabric Data Pipelines.

• Work closelywith Data Engineers, Data Scientists, and business stakeholders to deploy AI/ML models and Business Intelligence solutions (e.g., Power BI).

WHAT WE’RE LOOKING FOR:

• Education:
• Bachelor’s orMaster’s degree in Computer Science, Engineering, Mathematics, or a related quantitative field.

• United States Citizen or Green Card holderrequired.

Experience:

• 7+ years in enterprise data architecture withdemonstratedexpertisein leading data platform initiatives and modernizing data estates.

• Expert inAzure Data Lake Storage Gen2,Azure Synapse Analytics,Azure Databricks,Azure Data Factory, andMicrosoft Fabric.

• Strong knowledge of relational and NoSQL systems likeAzure SQL DatabaseandAzure Cosmos DB.

• Experience designing real-timearchitectureusing