Senior Data Architect, Team Innovation

American Global • New York, ON

1d • Remote

About The Position

We are seeking a Senior Data Architect to join our Team Innovation, reporting to our SVP Learning & Technology. The Senior Data Architect is responsible for designing, building, and maintaining scalable, secure, and reliable data infrastructure that powers American Global’s (AG) analytics, automation, and innovation initiatives. This role will lead the 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 AG’s primary technical counterpart, architecture reviewer, and knowledge transfer owner. The Senior Data Architect serves as the technical bridge between system data sources and AG’s data platforms. The position also mentors junior team members, drives best practices, and ensures alignment between technical implementation and business objectives. Ideal locations are near our Jericho, NY or Oakville, Canada offices. Position can be remote.

Requirements

• Fluency in insurance brokerage data environments
• Prior experience with Applied Epic or comparable insurance management and/or claims systems preferred
• Prior experience with construction industry data environments, project management systems, and/or risk and surety data preferred

Responsibilities

• Serve as AG's primary technical counterpart during vendor-led delivery engagements: review architecture decisions, validate implementation against AG requirements, and own knowledge transfer to ensure internal capability is built, not just delivered.
• Build and optimize cloud-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 AG's architecture evolves.
• Ensure system integrations are scalable, secure, and aligned with compliance standards.
• Partner with Team Innovation and functional department leaders to establish data 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 and maintain Power BI semantic models and dashboards for internal and external stakeholders, including Row-Level Security for client-scoped data.
• Partner with Data Engineer to 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 is accurate, labeled correctly, and accessible and connect operational system data into centralized data models.
• Troubleshoot and optimize performance across APIs, integrations, and data warehouse environments.

Benefits

• Comprehensive Benefits Package
• Collaborative and innovative environment
• Culture of continuous learning and professional development
• Competitive salary package
• 401k with above-average employer match of up to 5% of your salary
• Leadership training and support
• Work/Life Balance (Summer Fridays, flexible work arrangements and mental health services)
• Education and Student Loan Assistance

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed