Oliver Wyman – Data Engineer – Mexico City

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 7,000 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 Overview:

The OWG Tech department is looking to hire a highly motivated Data Engineer who would describe Databricks as their main skillset. You will play a crucial role in our data transformation program that will see data sources and analytical data processing shift from on-prem sources to a centralized Databricks platform in AWS. As a Data Engineer, you will be responsible for designing, developing, and maintaining our data infrastructure and pipelines, with a specific emphasis on leveraging Databricks technologies. You will work closely with our data scientists, analysts, and other stakeholders to ensure the availability, reliability, and scalability of our data systems.

Key Responsibilities:

• Designing, developing, and managing modern data platforms leveraging Databricks, Informatica IICS and related technologies.

• Develop, maintain and optimise data models and ETL pipelines for data processing efficiency.

• Design and implement processes to ingest data from various sources into Databricks in alignment with Architectural standards.

• Use Databricks to integrate, consolidate, and cleanse data to ensure it is accurate and ready for analysis.

• Optimise data storage in Databricks for efficient querying and analysis, leveraging Delta Lake versioned data management.

• Collaborate with business analysts, data scientists, and other business stakeholders to understand their data requirements and deliver solutions that meet their needs.

• Promote the available data and analytics capabilities to business stakeholders and educate them in leveraging these capabilities.

• Manage data access and security within Databricks, aligning with organizational policies and compliance requirements.

• Engage with clients to support architectural designs and solve technical queries swiftly and effectively.

• Stay updated with industry trends and emerging technologies in data engineering, continuously improving skills and knowledge.

Experience:

• Bachelor’s or Master’s degree in Computer Science, Data Science, or a related field.

• Minimum 5+ years experience in data engineering or equivalent data role

• Minimum 2-3 projects delivered with hands-on experience in Databrick ecosystem

• Expertise in data modelling, ETL development, and data warehousing

• Familiarity with Databricks medallion architecture

• Experience working with Delta Live Tables

• Familiarity with Unity Catalog

• Experience working with ETL/ELT tools such as Informatica IICS and SSIS

• Strong proficiency in programming languages such as Python, Scala and SQL for data manipulation and scripting

• Experience handling different data types (JSON, XML, Parquet, unstructured) for both batch and streaming ingestion

• Experience with streaming Data in Kakfa/Event Hubs/Stream Analytics etc

• Agile delivery experience using methodologies like Scrum or SAFe, and tools like Jira and Azure DevOps.

• Experience migrating data and associated pipelines from on-prem sources to cloud

• Databricks Data Engineering Professional certification is highly desirable

Skills and Attributes:

• Candidates must possess full professional proficiency in both written and spoken EnglishStrong problem-solving and troubleshooting skills.

• Strong communicator, in both verbal and written form, able to articulate concepts and ideas, break through barriers, engage people, and work effectively with others under pressure.

• Neutral toward technology, vendor, and product choices more interested in results than in personal preferences.

• Unflappable in the face of opposition to ideas

Marsh & McLennan Companies is a global professional services firm providing advice and solutions in the areas of risk, strategy, and human capital. It is the parent company of a number of the world’s leading risk experts and specialty consultants, including Marsh, the insurance broker and risk advisor; Guy Carpenter, the risk and reinsurance specialist; Mercer, the provider of HR and related financial advice and services; and Oliver Wyman, the management consultancy. With over 60,000 employees worldwide and annual revenue of approximately $13 billion, Marsh & McLennan Companies provides analysis, advice, and transactional capabilities to clients in more than 100 countries. Its stock (ticker symbol: MMC) is listed on the New York, Chicago and London stock exchanges.

Marsh & McLennan Companies offers competitive salaries and comprehensive benefits and programs including health and welfare, tuition assistance, 401K, employee assistance program, domestic partnership benefits, career mobility, employee network groups, volunteer opportunities, and other programs. For more information about our company, please visit us at: www.mmc.com. We embrace a culture that celebrates and promotes the many backgrounds, heritages and perspectives of our colleagues and clients. For more information, please visit us at: www.mmc.com/diversity. Oliver Wyman is an equal opportunity employer.