Senior Data Solutions Architect

Job not on LinkedIn

🔥 0 minutes ago

🦌 Connecticut, New York, +3 more states – Remote

🦌 Connecticut – Remote 🗽 New York – Remote 🌲 North Carolina – Remote 🏈 Ohio – Remote ⚔️ Virginia – Remote

💵 $115.8k - $202.7k / year

⏰ Full Time

🟠 Senior

💻 Solutions Engineer

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Marsh McLennan

WebsiteLinkedInAll Job Openings

10,000+ employees

Founded 1871

💸 Finance

Finance • Consulting • Insurance

Marsh McLennan is a leading professional services firm that operates in the areas of risk, strategy, and people. With over 85,000 employees worldwide, the company encompasses four main businesses: Marsh, offering insurance broking and risk management; Guy Carpenter, providing reinsurance and capital strategies; Mercer, specializing in health, wealth, and career consulting; and Oliver Wyman, focusing on strategy, economic, and brand consulting. Marsh McLennan is committed to fostering an inclusive culture, empowering its employees, and delivering innovative solutions to clients globally.

📋 Description

• 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

• 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

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