Senior Data Solutions Architect

Marsh McLennan

Senior Data Solutions Architect translating business requirements into technical strategies within MMA's data platforms. Designing enterprise data architectures across cloud and hybrid data solutions.

Posted 7/14/2026full-timeRemote • Connecticut, New York, North Carolina, Ohio, Virginia • 🇺🇸 United StatesSenior💰 $115,800 - $202,700 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Expertise in designing and architecting enterprise data solutions across cloud and hybrid platforms, with a strong focus on Azure, Databricks, and modern data Lakehouse technologies. Proficient in developing ETL/ELT data solutions, data modeling, and ensuring compliance and security standards in data management.

Highest-signal resume keywords

Azure Cloud EnvironmentDatabricksETL/ELT Data SolutionsData ModelingData Lakehouse Technologies

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLData ArchitectureData IntegrationData GovernanceMetadata ManagementDelta LakeChange Data CaptureACID TransactionsData StructuresHigh-Performance Data Storage

Soft Skills

CollaborationAgile MethodologiesRequirements Gathering

Tools & Technologies

GCPAzure DatabricksWorkdayServiceNowMicrosoft FabricAzure SQL

Industry Keywords

Healthcare ComplianceInsurance ComplianceData QualityData Security

Tech Stack

Tools & technologies

AzureCloudETLGoogle Cloud PlatformServiceNowSQLUnity

About the role

Key responsibilities & impact

Translate business requirements into technical strategies
Architect solutions on to MMA data platforms
Design enterprise data architecture and solutions across MMA’s cloud and hybrid data platforms
Lead the Design and Architecture of enterprise solutions across MMA’s Agency management software, EHB and CRM domains
Develop and maintain solution blueprints for core platforms, including Agency management systems, GCP, Azure Databricks, Workday, ServiceNow, Microsoft Fabric and Azure SQL
Define and enforce standards for medallion architecture for MMA’s data Lakehouse
Establish secure and scalable integration patterns and data flows between AMS, HRIS, CRM, Azure Cloud, and development systems
Collaborate with the Data Governance Council to align solution architecture
Drive adoption of metadata management and data lineage practices within Databricks Unity Catalog

Requirements

What you’ll need

Minimum 12 years of experience designing end to end ETL/ELT data solutions
Minimum of 5 years preferably in Azure cloud environment and Databricks
Comfortable working in agile methodologies and large scale data migrations
Experience with proof of concept experiments and requirements gathering
Create conceptual, logical, and physical data models support engineering, analytics, and operational use cases
Advanced knowledge of SQL, data modeling, and modern data Lakehouse technologies
Hands-on experience with Delta Lake features such as Change data capture, ACID transactions, optimization, and schema drifting/evolution
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 on high-performance data storage in data lakes

Benefits

Comp & perks

Generous time off, including personal and volunteering
Tuition reimbursement and professional development opportunities
Remote work
Charitable contribution match programs
Stock purchase opportunities