162 applicants

Company

Marsh McLennan Agency · 6 hours ago

Senior Data Architect

Clayton, MO

Full-time

Remote

Senior Level, Lead/Staff

$105K/yr - $183K/yr

10+ years exp

Maximize your interview chances

Employee BenefitsHealth Care

Growth Opportunities

H1B Sponsor Likely

Insider Connection @Marsh McLennan Agency

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Establish consistent data standards, reference architectures, patterns, and practices across the organization for both OLTP and OLAP (Data warehouse, Data Lake house) MDM and AI/ML technologies.

Define reference data architecture and work with agile teams to ensure the documented best practices are used in data platform development.

Create strategies and design solutions for a wide variety of use cases like Data Migration (end-to-end ETL process), database optimization, and data architectural solutions for Analytics Data Projects.

Design, develop, and troubleshoot highly complex technical problems in OLAP/OLTP/DW, Analytics, and provide solutions for Enterprise-level Applications utilizing Azure Data Platform.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Enterprise data architectureCloud database technologiesData modelingData architectureAzure Data PlatformBatch data ingestionStreaming data ingestionData QualityData LineageData CatalogsPerformance challengesSOA data layerBusiness IntelligenceSDLC processesNoSQL databasesSQL databasesAzure Data FactoryPower BIData Lake technologiesData Warehouse technologiesAzureData governanceKubernetesInformaticaMongoDBPostgreSQLDatabricksData securityData resilienceData replication

Required

10+ or more years of experience in Information Technology.

5 to 10 years of experience in Enterprise data architecture, Data, Modelling, Data management and Data strategy

5 to 7 years of experience in Cloud database technologies.

7 to 10 years of experience as a data architect

Solid understanding of databases and the strengths and weaknesses of platforms and products, with the ability to provide a trusted voice at the decision-making table

Expertise in creating ER (Entity Relationship), Logical, Physical, and Conceptual data models for an enterprise

Experience in data modeling, streaming skills, and data architecture for operational and analytical datastores

Proficiency in the design of batch and streaming data ingestion

Knowledge in designing solutions with Data Quality, Data Lineage, and Data Catalogs

Experience with solving performance challenges for a variety of velocities, latencies, and volumes of data

Designing and maintaining the data models, including conceptual, logical, and physical data models

Experience with SOA data layer utilizing data access frameworks and exposing data via web services

Experience with Business Intelligence and data mart architecture

Experience creating a data architecture vision between lines of business and IT

Demonstrated competency in communicating the value of data architecture to stakeholders and senior management

Experience in SDLC processes, database patterns, and development frameworks

Strong interpersonal, verbal, and written communication skills, with the ability to develop and conduct executive-level presentations

Experience crafting solutions that leverage data in NoSQL and SQL datastores for high availability and disaster tolerance

Deep expertise in Data engineering capabilities involving architecture, modeling (physical and logical), data governance, storage, security, resilience, and replication

Knowledge of Informatica – IICS task flows development and maintenance

Experience with MongoDB or another NoSQL database, PostgreSQL, or any relational database

Experience with Azure, Data Lake, Databricks, SQL, ETL, and MDM

Experience with data integration services such as Azure Data Factory

Experience with business intelligence tools; Power BI or Qlik is preferred

Experience in designing and building large-scale, enterprise systems in a highly available, scalable, performant, and distributed environment

Preferred

Preferred experience with Kubernetes, Cloud Native ecosystem, and Data Lake/Data Warehouse technologies

Knowledge of Agency Management systems like Applied EPIC and Vertafore Sagitta, Benefit Point

Microsoft Azure Data Engineer or other cloud certifications

Data bricks experience and certification

Benefits

Generous time off, including personal and volunteering

Tuition reimbursement and professional development opportunities

Remote work

Charitable contribution match programs

Stock purchase opportunities

Health and welfare benefits

Tuition assistance

401K savings

Other wellbeing programs

Employee assistance programs

Company

Marsh McLennan Agency

Glassdoor

4.4

Marsh McLennan is an insurance company that provides business insurance, employee benefits, and private client insurance solutions. It is a sub-organization of Marsh & McLennan.

Founded in 2003

White Plains, New York, USA

5,001-10,000 employees

https://www.marshmma.com

H1B Sponsorship

Marsh McLennan Agency has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2023 (2)

2022 (2)

2021 (2)

2020 (1)