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:* RequirementCapture the needs via interview and translate the needs into a plan of action* Data sourcing & integrationUnderstand the enterprise data sources landscape, contribute to the definition of the extract/refresh strategies (if required), and build simple transformations scripts.* Visualization & storytellingBuild 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 engagementPartner with IP Law stakeholders to translate requirement into reports and/or dashboardCore 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 leastyears of experience in a related fieldNice 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 SkillsMust have:* Agile - listen, experiment, adapt, and learn from mistakesNice 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 ! jid88cf7b9a jit0105a jiy26a