\n","datePosted":"2023-11-02T11:09:37.500Z","employmentType":[],"hiringOrganization":{"@type":"Organization","name":"McKinsey & Company","sameAs":"https://mckinsey.com","logo":"https://cdn.filestackcontent.com/output=f:webp,t:true,q:80,c:true/cache=expiry:max/resize=w:340/P77DPRtGTye15MmkcIyC"},"jobLocation":[{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Lisbon, Portugal"}},{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Madrid, Spain"}}]}

Client Activation Data Analyst

McKinsey & Company

IT, Data Science

Lisbon, Portugal · Madrid, Spain

Posted on Thursday, November 2, 2023

Apply

Technology & Digital

Client Activation Data Analyst

Lisbon
Madrid
Poznan
San Jose

Apply Now

Who You'll Work With

You’ll be part of our McKinsey’s Client Activation Analytics Team in one of our multiple locations which uses innovative analytics solutions to generate insights from various data sources and to improve decision making. We enable the firm’s efforts to build a growth strategy, identifying opportunities, optimizing coverage and tracking the firm’s performance. We deliver these insights to firm leadership, Cell Managing Partners and Client Service Team Leaders through a mix exploratory ad-hoc analysis and a set of scalable self-serve products. You will be collaborating closely colleagues in the broader Client Activation space like Competitive Intelligence, Client Feedback, Market insights and a data stewardship team. You will also learn about People analytics and Finance data.

In this role you will join forces with a team of data engineers and data scientists under the direct supervision of a dedicated manager who will guide and support you in your daily work and in your development.

What You'll Do

You will be creating metrics, generating reports and providing insights to different parts of the business. Your role will be to lead the development of analytical processes aiming to address complex business questions. You will need to scope and define the analysis and requirements in the context of the question at hand and the firm’s data and build the analytical process in a structured and reusable way (e.g., automated workflows using the latest firm-provided tools).

You will work to find new ways of interpreting the data and develop appropriate visualizations to communicate findings to leadership. This includes the use of traditional Power Point reporting as well as building dashboards through Tableau, PowerBI or similar solutions to synthesize results into digestible insights.

You will be influencing how the portfolio of analytics solutions will look like and proactively suggest analysis to be turned into self-serve products. You will play an important role in the development of new dashboards as well as the enhancement of existing products that support firm/cell leadership, CSTs and Client Activation teams.

You will be catering to a variety of ad-hoc requests that involve data pulls and modeling. You will do explorative data analysis, summarize data, establish comparisons, do internal benchmarking, and newly develop metrics for regular reporting.

You will have the ownership of one or more self-serve products. You will become the first alert, managing end-users, custom requests, and enhancement initiatives for key products in the Client Activation Analytics space. In this role you will interact frequently with leaders in Client Activation across the firm.

You will contribute to the migration of previously build data flows in Alteryx to the new firm-approved tools (e.g., Knime, AWS Glue, Snowflake).

You will be periodically reviewing and improving data quality. You will identify weaknesses or discrepancies in the team’s data sources and provide suggestions for improvement.

You will be interfacing with the Data Engineering team in Client Activation Analytics. You will play an important role in the development of our data structure providing input into the data transformation and staging process, covering data from multiple functions in the firm (e.g. Client data, Finance data, People data).

Over time you will take on increased responsibility to communicate directly with senior leaders of the firm to explain existing tools, specific findings and to provide ad-hoc support.

Qualifications

1+ years of relevant professional Data and Analytics experience
A degree in Industrial Engineering, Analytics, Finance, Economics or related field that combines knowledge about business processes with analytical skills
Experience with Tableau, PowerBI or similar tools is required
The candidate must have SQL knowledge to query data including joining multiple data tables, summarizing data and calculating new fields; basic knowledge in other languages is a plus
Experience visualizing data in different formats (dashboards, ppts, etc) and support data-driven story-telling
Ability to syndicate findings, explain analysis and underlying data in a structured, clear manner to both, audiences with knowledge of the data sources as well as those unfamiliar with them
Some experience with statistical and forecasting methods (e.g., multivariate regression) is a plus
High personal integrity, discretion and confidentiality given the nature of the insights handled
Entrepreneurial mindset and comfortable to test new ideas or build things from scratch

Apply Now

FOR U.S. APPLICANTS: McKinsey & Company is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by applicable law.

FOR NON-U.S. APPLICANTS: McKinsey & Company is an Equal Opportunity employer. For additional details regarding our global EEO policy and diversity initiatives, please visit our McKinsey Careers and Diversity & Inclusion sites.

Job Skill Group - CSSA
Job Skill Code - PLA - Data Analyst
Function - Firm Administration;Operations;Technology
Industry - High Tech
Post to LinkedIn - Yes
Posted to LinkedIn Date - Wed Aug 30 00:00:00 GMT 2023
LinkedIn Posting City - Poznan
LinkedIn Posting State/Province -
LinkedIn Posting Country - Poland
LinkedIn Job Title - Client Activation Data Analyst
LinkedIn Function - Analyst;Consulting;Information Technology
LinkedIn Industry - Computer Software;Information Technology and Services
LinkedIn Seniority Level - Associate

Apply now

See more open positions at McKinsey & Company

Talent page