Data Analyst

Overview

Our client Philip Morris is looking for a Data Analyst based in Neuchatel or Lausanne hybrid.

Role

Purpose:

Enable data informed decisions by transforming raw business data, in particular IP Law internal data & publicly available patent data, into trustworthy and actionable insights and intuitive analytics reports or dashboards. The role owns the end to end BI lifecycle from requirement collection and data acquisition to secure publishing using Power BI, Excel, and out-of-the-box reporting capability from operational tools.

• Requirement
  :
  Capture the needs via interview and translate the needs into a plan of action
• Data sourcing & integration
  :
  Understand the enterprise data sources landscape, contribute to the definition of the extract/refresh strategies if required, and build simple transformation scripts.
• Visualization & storytelling
  :
  Build accessible dashboards and reports using native operational reporting tools e.g. Salesforce reporting framework, or Power BI or advanced Excel where appropriate with a focus on business relevance; iterate based on stakeholder feedback.
• Stakeholder engagement
  :
  Partner with IP Law stakeholders to translate requirements into reports and/or dashboards

Know Do Teach :

• Must Have:
• Power BI design reusable, documented models for BI reporting and apply templates and best practices.
• Excel Advanced Power Pivot, complex formulas, pivot tables, and data modeling for analytical workbooks.
• At least 3-5 years of experience in a related field.

• Nice to have:
• Salesforce Reporting: build/maintain Salesforce reports and dashboards;
• Experience with ETL, RPA or programming language like Python is considered an additional asset for implementing automated data extraction and transformation procedures.

• Must have: Agile, listen, experiment, adapt, and learn from mistakes
• Nice to have: Embrace Challenge, take thoughtful risks to innovate and disrupt;
  Drive for Impact, act with energy to deliver outcomes despite adversity

We are looking forward your application