Associate Director - Systems Architecture - Data

This job is with Marsh McLennan, an inclusive employer and a member of myGwork – the largest global platform for the LGBTQ+ business community. Please do not contact the recruiter directly.

About Oliver Wyman

Oliver Wyman is a global leader in management consulting. With offices in 60 cities across 29 countries, Oliver Wyman combines deep industry knowledge with specialized expertise in strategy, operations, risk management, and organization transformation. Our 5000 professionals help clients optimize their business, improve their operations and risk profile, and accelerate their organizational performance to seize the most attractive opportunities. Oliver Wyman's thought leadership is evident in our agenda-setting books, white papers, research reports, and articles in the business press. Our clients are the CEOs and executive teams of the top Global 1000 companies.

Visit our website for more details about Oliver Wyman : www.oliverwyman.com

Job specification

Job Title

Sr Data Architect

Department

OWG Tech

Office / region

Gurugram, India

Reports To

ITS Database Architecture Manager

Job Overview

The OWG Tech department is looking to hire a Senior Data Architect with hands-on expertise in Data Lakehouse Architectures. The successful candidate will spearhead the delivery of top-tier solutions while influencing pivotal design choices across the data architecture spectrum. From ingestion and storage to virtualization, data models, performance, and security, your expertise will be instrumental in aligning solutions with Enterprise Architecture principles. Collaboration with cross-functional teams within MMC will be paramount, and your commitment to integrity, ethics, and service excellence will set the standard.

Key Responsibilities

• Design and implement Data Lakehouse architectures that meet business requirements and are scalable, reliable, and secure.
• Gather and document Master Data Management (MDM) requirements, liaising with various business stakeholders to develop MDM strategy & architecture patterns.
• Analyzing the business requirements, design and develop highly efficient highly scalable Data Ingestion processes.
• Design and build modern data pipelines including ETL mappings, being well versed in writing complex SQL queries.
• Develop and maintain data models, data dictionaries, and data flow diagrams.
• Hands-on working with virtualization, performance tuning, optimization, and scaling solutions from a storage / processing perspective.
• Maintain batch processing jobs and respond to critical production issues communicate well with stakeholders on their proposal recommendations.
• Conduct research focused on identifying emerging technology solutions that reduce costs, increase efficiencies, provide more value, provide more capabilities, reduce risks, and increase security.
• Implement and maintain data security and access controls.
• Support the Lead Data Architect by contributing improvements to the Data Architecture strategy, evolving best-practices, templates and processes.
• Work collaboratively with Solution Architects, Developers, Testers and other Data Analytics team members to understand constraints and opportunities that may shape and influence Data Architecture deliverables.

Experience

Skills And Attributes

Why Join Our Team

Marsh McLennan (NYSE : MMC) is a global leader in risk, strategy and people, advising clients in 130 countries across four businesses : Marsh, Guy Carpenter, Mercer and Oliver Wyman. With annual revenue of $23 billion and more than 85,000 colleagues, Marsh McLennan helps build the confidence to thrive through the power of perspective. For more information, visit marshmclennan.com, or follow on LinkedIn and X.

Marsh McLennan is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age, background, caste, disability, ethnic origin, family duties, gender orientation or expression, gender reassignment, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex / gender, sexual orientation or expression, skin color, or any other characteristic protected by applicable law.

Marsh McLennan is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh McLennan colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams will identify at least one 'anchor day' per week on which their full team will be together in person.

Marsh McLennan (NYSE : MMC) is a global leader in risk, strategy and people, advising clients in 130 countries across four businesses : Marsh, Guy Carpenter, Mercer and Oliver Wyman. With annual revenue of $24 billion and more than 90,000 colleagues, Marsh McLennan helps build the confidence to thrive through the power of perspective. For more information, visit marshmclennan.com, or follow on LinkedIn and X.

Marsh McLennan is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age, background, caste, disability, ethnic origin, family duties, gender orientation or expression, gender reassignment, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex / gender, sexual orientation or expression, skin color, or any other characteristic protected by applicable law.

Marsh McLennan is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh McLennan colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams will identify at least one 'anchor day' per week on which their full team will be together in person.

Skills Required

Data Flow Diagrams, Performance Tuning, Data Security, Agile Methodologies, data models, Virtualization, Sql