Senior Data Solutions Architect at Marsh Mc. Lennan Agency

Marsh Mc. Lennan Agency (MMA) is an award-winning, inclusive Top Workplace with a culture built by extraordinary people. We combine the personalized service of a local consultant with the global resources of Marsh (NYSE: MRSH), offering business insurance, employee health & benefits, retirement, and private client insurance solutions across North America.

The Role

We are looking for a Senior Data Solutions Architect with at least 12 years of experience to translate business requirements into technical strategies and architect solutions onto our data platforms. This role blends Data and Cloud architecture, where you will design enterprise data architecture and solutions across MMA’s cloud and hybrid data platforms.

You will lead the design and architecture of enterprise solutions across our Agency management software, EHB, and CRM domains. Responsibilities include developing and maintaining solution blueprints for core platforms like Agency management systems, GCP, Azure Databricks, Workday, Service.

Now, Microsoft Fabric, and Azure SQL. You will define and enforce standards for medallion architecture (bronze, silver, gold layers) for our data Lakehouse, ensuring proper ingestion, transformation, and consumption.

Establishing secure and scalable integration patterns between AMS, HRIS, CRM, Azure Cloud, and development systems is key, as is ensuring compliance with GDPR, HIPAA, and other regulatory frameworks for healthcare and insurance data.

You'll collaborate with the Data Governance Council to align solution architecture with role-based access controls (RBAC) and row-level security (RLS) in Unity Catalog and Power BI, and drive adoption of metadata management and data lineage practices within Databricks Unity Catalog.

Partnering with enterprise architecture, Data Analytics, and Data Engineering teams, you'll align on shared infrastructure and data strategies.

You will evaluate and recommend emerging technologies in AI/ML, Databricks, and analytics to support MMA’s long-term data strategy, and support our data modernization and transformation initiatives by developing frameworks for AI-ready data platforms that enable responsible adoption of predictive analytics and LLM-based solutions.

What We’re Looking For

Minimum 12 years of experience designing end-to-end ETL/ELT data solutions, with at least 5 years preferably in Azure cloud and Databricks.
Comfortable working in agile methodologies, large-scale data migrations, data modernization, proof of concept experiments, and requirements gathering.
Ability to create conceptual, logical, and physical data models supporting engineering, analytics, and operational use cases, and creating entity relationships.
Advanced knowledge of SQL, data modeling, and modern data Lakehouse technologies.
Hands-on experience with Delta Lake features like Change Data Capture, ACID transactions, optimization, and schema drifting/evolution for batch and real-time processing.
Understanding of compliance, quality, and security frameworks for healthcare and insurance.
In-depth understanding of data structures (structured and unstructured), data types and formats, and command of high-performance data storage in data lakes.

Certifications in TOGAF, Enterprise Architecture, or Azure are a big plus but not required.

Benefits and Perks

We value our colleagues’ impact and offer a competitive total rewards package including a base salary range of $115,800 to $202,700 (determined by experience, skills, location, etc.) plus eligibility for performance-based incentives.

Benefits include generous time off (personal and volunteering), tuition reimbursement, professional development, remote work, charitable contribution match programs, stock purchase opportunities, health and welfare benefits, 401K savings, and employee assistance programs.

Marsh Mc. Lennan and its affiliates are EOE Minority/Female/Disability/Vet/Sexual Orientation/Gender Identity employers. Applications accepted until September 8, 2026. #LI

REMOTE