Description

**​**
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 report or dashboard. 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 tool.

**Key Accountabilities:**
**• 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 transformations scripts.
**• Visualization & storytelling**
Build accessible dashboards and reports using native operational reporting tool (e.g. Salesforce reporting framework), or Power BI or advanced Excel where appropriate with focus on business relevance; iterate based on stakeholder feedback.
**• Stakeholder engagement**
Partner with IP Law stakeholders to translate requirement into reports and/or dashboard

**Core Technical Competencies** (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 programing language like python is considered an additional asset for implementing automated data extraction and transformation procedures.

**Soft Skills**
**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 !