Associate Director

Company Oliver Wyman 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 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 traditional approaches 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 NYSE MMC is a global leader in risk strategy and people advising clients in 130 countries across four businesses and 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 or follow on and 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