Senior Data Architect

Company:

Description:

Our notsosecret sauce.

Awardwinning inclusive Top Workplace culture doesnt happen overnight. Its a result of hard work by extraordinary people. More than 11000 of the industrys brightest talent drive our efforts to deliver purposeful work and meaningful impact every day. Learn more about what makes us different and how you can thrive as a Senior Data Architect at Marsh McLennan Agency (MMA).

MMA provides business insurance employee health & benefits retirement and private client insurance solutions to organizations and individuals seeking limitless possibilities. With 200 offices across North America we combine the personalized service model of a local consultant with the global resources of the worlds leading professional services firm Marsh McLennan (NYSE: MMC).

A day in the life.

As a Senior Data Architect on the Data team youll 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. You will define reference data architecture and work with agile teams to ensure the documented best practices are used in data platform development. Additionally youll create strategies and design solutions for a wide variety of use cases like Data Migration (endtoend ETL process) database optimization and data architectural solutions for Analytics Data Projects. You will also design develop and troubleshoot highly complex technical problems in OLAP/OLTP/DW Analytics and provide solutions for Enterpriselevel Applications utilizing Azure Data Platform.

Our future colleague.

Wed love to meet you if your professional track record includes these skills:
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 decisionmaking 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 executivelevel presentations
Experience crafting solutions that leverage data in NoSQL and SQL datastores for high availability and disaster tolerance
Preferred experience with Kubernetes Cloud Native ecosystem and Data Lake/Data Warehouse technologies
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 largescale enterprise systems in a highly available scalable performant and distributed environment

These additional qualifications are a plus but not required to apply:
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

We know there are excellent candidates who might not check all of these boxes. Dont be shy. If youre close wed be very interested in meeting you.

Valuable benefits.

We value and respect the impact our colleagues make every day both inside and outside our organization. Weve built a culture that promotes colleague wellbeing through robust benefit programs and resources encourages professional and personal development and celebrates opportunities to pursue the projects and causes that give colleagues fulfillment outside of work.

Some benefits included in this role are:
Generous time off including personal and volunteering
Tuition reimbursement and professional development opportunities
Remote work
Charitable contribution match programs
Stock purchase opportunities

To learn more about a career at MMA check us out online: http://marshmma/careers or flip through our recruiting brochure: us on social media to meet our colleagues and see what makes us tick:

you are is who we are.

We embrace a culture that celebrates and promotes the many backgrounds heritages and perspectives of our colleagues and clients. We are always seeking those with ethics talent and ambition who are interested in joining our clientfocused teams.

Marsh McLennan and its affiliates are EOE Minority/Female/Disability/Vet/Sexual Orientation/Gender Identity employers.