Associate Director - Systems Architecture - Data

Company:

Description:

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:

• Bachelor's degree in computer science, computer engineering, electrical engineering, systems analysis or a related field of study, or equivalent job experience.

• Significant experience in Data Architecture, with a deep understanding of data models, standards and tools used across architecture and engineering.

• At least 2 years’ experience designing and implementation Data Lakehouse architectures in Azure or AWS, hands-on experience with Databricks is desirable.

• Experience of transforming traditional Data Warehousing approaches to Big Data based approaches.

• Demonstrated experience using ETL tools such as IICS/ADF/AWS Glue and SSIS using traditionalapproaches, experience with more modern real time data pipeline solutions is desirable.

• Demonstrated effectiveness in executive presentation and escalation management.

• Demonstrated Data modelling and data mapping experience.

• Experience with Data virtualization & catalogue is a desirable

• Experienced with Agile methodologies.

Skills and Attributes:

• Language Fluency: Must possess 100% fluency in English.

• Robust Data Solutions: Ability to manage complex data requirements and develop robust code that ensures data availability, integrity, quality, and security.

• Holistic Technology Understanding: Strong grasp of enterprise web application development, services-oriented architecture, cloud-based models (SaaS, PaaS, IaaS), and supporting technologies.

• Interpersonal Excellence: Outstanding interpersonal skills, teamwork, and facilitation capabilities to effectively collaborate across diverse teams.

• Effective Communication: Proficient communicator, adept at conveying concepts and ideas, breaking through barriers, and engaging individuals under pressure.

• Stakeholder Management: Skillfully establish credibility with various technical stakeholders, from executives to engineering, operations, security, and quality assurance.

• Goal-Oriented Planning: Capable of aligning short-term and long-term goals, both independently and within the team, integrating strategic objectives seamlessly.

• Effective Leadership: Set clear goals, prioritize activities, manage risks, and consistently drive projects to completion.

• Technology Neutrality: Unbiased towards technology, vendor, or product preferences; prioritize results over personal choices.

• Resilience: Unwavering commitment to architectural ideals even in the face of opposition.

Why join our Team:

• We help you be your best through professional development opportunities, interesting work and supportive leaders.

• We foster a vibrant and inclusive culture where you can work with talented colleagues to create new solutions and have impact for colleagues, clients and communities.

• Our scale enables us to provide a range of career opportunities, as well as benefits and rewards to enhance your well-being.

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.