A Tenth Revolution Group Company

Ref: 28112023.1

BI Analytics & Data Warehouse

Switzerland, Basel-Country

Job description

BI Analytics & Data Warehouse


Job Responsibilities:
  • Establish a data platform for analyzing commercial, sales, and market research data
  • Define and implement commercial KPIs, creating an advanced analytics and self-BI platform for informed business decisions

Overview of Responsibilities and Business Impact:
  • Build and maintain relationships with clients, vendors, and internal teams
  • Support local and global teams in identifying commercial portfolio opportunities
  • Manage the data strategy for the commercial data warehouse and analytics platform
  • Ensure efficient handling of a company-wide data warehouse for better management decisions

Main Tasks:
  • Perform data sourcing, load, and analysis on external data
  • Identify and propose solutions for system/process issues
  • Manipulate and transform data to optimize analyses
  • Complete ad-hoc deliverables for clients
  • Communicate system-related problems with IT teams and software vendors
  • Troubleshoot, support users, and maintain systems for customer satisfaction
  • Guarantee compliance with CSV requirements, IT Policies, and Standards

Technical Skills:
  • Proficient in analytical tools, Microsoft Power BI, and other tools (Qlik, Tableau)
  • Experience in Data Warehouse management, ETL, Data Modeling, SQL, query building
  • Familiarity with relational databases like Amazon Redshift, Oracle, or SQL Server
  • Experience in managing SaaS
  • Strong analytical skills and ability to transform business requirements into IT solutions
  • Familiarity with Veeva/IQVIA commercial data portfolio and other external pharmaceutical data providers is an asset