Oliver Wyman - Data & Analytics Analyst - Mexico City

Oliver Wyman; Mexico; Hybrid; PHP 5,478,000 - 7,912,000; Full time

Job summary

Oliver Wyman is seeking an Associate Data and Analytics Analyst to create and maintain reporting artifacts (dashboards and reports) tied to the firm's operations. The role blends analytics acumen with practical business insight.

You will partner with stakeholders, develop data sets, leverage Tableau, SQL, and BI tools, and help scale the analytics community across the organization. This position supports hybrid work in our global team and offers opportunities to influence decision-making with

Qualifications

• Bachelor's or MS in a quantitative field.
• 3+ years in business analytics.
• Experience with Tableau dashboards.
• SQL/PLSQL development experience.
• Experience with data warehouses and ETL.
• Knowledge of BI tools (Oracle, OBIEE, BO).
• Experience with Python or R.

Responsibilities

• Partner with stakeholders to define reporting needs and deliver solutions.
• Develop new data sets, metrics and analytics content.
• Identify efficiencies and enhancements in reporting.
• Train and support the analytics community on tools and data models.
• Support data sourcing, preparation and visualization for BI.
• Define data requirements with data architects for BI dashboards.
• Contribute to BI and data warehousing initiatives.

Skills

Tableau

SQL/PLSQL

Data Analytics

Excel

PowerPoint

ETL

Data Warehousing

Agile

English fluency

Python

R

Education

Bachelor's or MS in quantitative field

Tools

Tableau

SQL Server

Oracle

Python

R

OBIEE

Job description

About Oliver Wyman

Oliver Wyman, a Marsh (NYSE: MRSH) business, is a management consulting firm driven by deep industry insight, bold innovation, and a collaborative approach that cuts through complexity to help organizations navigate their most defining transformative moments.

For more information, visitoliverwyman.com, or follow us onLinkedInandX.

Job Overview

The Associate Data and Analytics Analyst, OW will be responsible for creating and maintaining reporting artifacts (dashboards and reports) connected to the operations of Oliver Wyman. Our ideal candidate not only understands the technical sides of reporting but is passionate about the field of analytics where they can use their problem-solving skills and creativity to uncover the “Why” for the analysis.

Key Responsibilities

• Partner with business stakeholders to define their reporting and analytics needs and develop solutions for delivering against them
• Assist in development and delivery of new data sets, metrics and analytics content to support business strategic decisions.
• Assist with the identification and deployment of efficiencies and enhancements in reporting and analytics
• Assist with the development, training and support of the “analytics community” to ensure awareness and proficiency on tools and available data models
• Provide support and expertise in data and analytics (data sourcing, data preparation and data visualization) to the various analytics teams in their efforts to convert their offline reporting models to the technologies available as part of the data and analytics initiative.
• Partner with technology groups (data architects) to define data requirements for business intelligence visualizations and tools
• Participate in the on-going development of the business intelligence and data warehousing functions within the wider organization

Experience Required

• Bachelors / MS in a quantitative discipline e.g., applied mathematics, statistics, computer science, information systems, econometrics, or related field
• 3+ years of experience in business analytics and business support functions
• 3+ years of experience working with Tableau software to design, develop, and deploy business dashboards (Tableau Desktop, Tableau Server and Tableau Data Prep.)
• 3+ years of SQL/PLSQL development experience
• Experience in managing/maintaining Tableau sites and projects ensuring a consistent design, deployment, and maintenance process is followed.
• Experience in Agile delivery methodology in a data and analytics context
• Deep understanding of data warehouse processes, dimensional modeling and ETL/Integration
• Knowledge of industry standard Business Intelligence (BI) tools, such as: Oracle (OBIEE), Business Objects, etc.
• Experience with statistical programming (R, SAS, and/or Python), a plus
• Experience with multiple RMDB’s such as SQL Server, Oracle
• Strong Excel, PowerPoint skills
• English fluency (written and spoken) required

Skills and Attributes

• Excellent problem-solving and critical thinking skills required
• Ability to drive exploration and draw conclusions from multiple data sets
• Strong spirit of innovation, self-starter, independent, and with ability to come up with solutions to meet business problems
• Self-directed who can interpret data to understand trends and derive meaningful business insights for senior executives with little oversight
• Self-motivated with ability to work independently while also enjoying collaboration with cross-functional teams and other analysts
• Strong desire to learn new skills and pass knowledge acquired onto others
• Keen attention to detail with deep quantitative and analytical skills and demonstrated capacity to solve problems and enhance reporting
• Strong relationship building skills and ability to build alignment among customers and key stakeholders with demonstrated experience influencing without authority
• Ability to work effectively in a fast paced, deadline driven, highly dynamic atmosphere and react quickly to changes and shifting priorities.
• Effective communication skills and ability to translate numbers into a story
• You need to be curious by nature, understand how data is produced in our various underlying systems and how reporting and analytics content is compiled so that data can be turned into actionable business insights to support the firm’s strategy

Oliver Wyman is a business of Marsh (NYSE: MRSH), a global leader in risk, reinsurance and capital, people and investments, and management consulting, advising clients in 130 countries. With annual revenue of over $27 billion and more than 95,000 colleagues, Marsh helps build the confidence to thrive through the power of perspective.

Marsh is committed to creating a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age, background, disability, ethnic origin, family duties, gender orientation or expression, 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 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 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.

R_352786