Senior Data Architect, Team Innovation

About the Role

We areseekinga Senior Data Architect to join our TeamInnovationreporting to our SVP Learning & Technology.The Senior Data Architectis responsible fordesigning building andmaintainingscalable secure and reliable data infrastructure that powers AmericanGlobals(AG) analytics automation and innovation initiatives.

This role willleadthe development of cloud-based data pipelines system integrations and data models that support both internal operations and external client-facing analytics and portals. The role works in close partnership with external delivery vendors during active platform build phases serving as AGs primary technical counterpart architecture reviewer and knowledge transfer owner.

The Senior Data Architect serves as the technical bridge between system data sources and AGs data platforms. The position also mentors junior team members drives best practices and ensures alignment between technical implementation and businessobjectives.

Ideal locations are near our Jericho NY or Oakville Canada offices. Position can be remote.

Works closely with:VP Innovation & Insights VP Data Analytics and Automation Data Engineer Project Manager Technology & Innovation Business Systems Analyst

KeyResponsibilitiesInclude

Fundamentals

• Serve as AGs primary technical counterpart during vendor-led delivery engagements: review architecture decisionsvalidateimplementation against AG requirements and own knowledge transfer to ensure internal capability is built not just delivered.

• Build andoptimizecloud-based data pipelines data lakes data warehouses and ETL frameworks using cloud-native tooling across major platforms (Azure AWS or equivalent); ability to evaluate recommend and work within the chosen platform as AGs architecture evolves.

• Ensure system integrations are scalable secure and aligned with compliance standards.

• Partner with Team Innovation and functional department leaders toestablishdata standards governance and documentation.

• Implement version control CI/CD and data workflow automation practices.

Data

• Design build and automate data models ingestion pipelines and transformation workflows across source systems and Medallion layers; own platform stability and schema evolution post-vendor engagement.

• Implement monitoring processes for data quality validation and integrity across all platforms.

• Design and build external client portal data layer: implement Row-Level Security (RLS) in Power BI manage client-scoped semantic models and support embedded analytics delivery to external stakeholders.

• Design and enforce RBAC data classification and access control policies across all data layers using Azure Purview and Microsoft Entra ID; build andmaintainPower BI semantic models and dashboards for internal and external stakeholders including Row-Level Security for client-scoped data.

Operations

• Partner with DataEngineerto guide day-to-day technical execution and ensure adherence to architecture principles.

• Monitor and manage Azure cloud resource costs: right-size compute clusters implement resource tagging configure budget alerts and report on consumption trends.

• Collaborate with Business Systems Analyst to ensure operational data isaccurate labeled correctly and accessible and connect operational system data into centralized data models.

• Troubleshoot andoptimizeperformance across APIs integrations and data warehouse environments.

• Additionalresponsibilities as

Skills & ExperienceThatLeadto Success:

• Fluency in insurance brokerage data environments

• Prior experience with Applied Epic or comparable insurance managementand/or claimssystemspreferred

• Prior experience with construction industry data environments project managementsystemsand/orrisk and surety datapreferred

What You Can ExpectFromUs:

• Comprehensive Benefits Package

• Collaborativeand innovativeenvironment

• Culture of continuous learning and professional development

• Competitive salary package

• 401k withabove-averageemployer matchofup to 5% of your salary

• Leadership training and support

• Work/Life Balance (Summer Fridays flexible workarrangementsand mental health services)

• Education and Student Loan Assistance