Oliver Wyman - Data Engineer - Mexico City
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 Wymans 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: (link removed)
Job Overview:
The OWG Tech department is looking to hire a highly motivated Data Engineer who would describeDatabricks
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.
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 4+ 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 English
Strong 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: (link removed). 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: (link removed)/diversity.
Oliver Wyman is an equal opportunity employer.