BI Developer (Power BI / Tableau /Snowflake/ Spotfire) - January 2026
Remote, Remote
For one of our clients in the pharmaceutical industry, we are looking for a freelance BI Developer (Power BI / Tableau /Snowflake/ Spotfire)
1. Project Name Analytics Dashboard Development
2. Project description The service is requested as part of the project mentioned above. The purpose of the project is to implement different use case scenarios. Data from different sources such as MES and LIMS are ingested via data flows into a Landing Zone and further processed into final data marts, all based on the database technology Snowflake. Dashboard technologies to be used are PowerBI, Tableau, and Spotfire.
3. Detailed Task Description
The external contractor will receive from the client all required system access, templates, contact lists, requirements, documents, and any other required information to carry out the work.
The scope of services includes the following tasks, which are independently performed by the external contractor:
Definition of user requirements based on the evaluation of predefined functional specifications and existing data sets to create technical boundaries for the dashboard environment.
Technical analysis of legacy reports and the existing system environment.
Conception of technical solution designs and data marts to create the underlying data structure required for scalable and maintainable dashboard performance.
Development of dashboards using PowerBI, Tableau, or Spotfire, strictly following the previously established technical solution designs and the overarching system architecture.
Integration of data rules and access privileges, specifically the configuration of Row Level Security (RLS), to achieve technical governance standards.
Creation of report-specific filters and parameters to enable multi-dimensional data views within the visualization tools.
Implementation of drill-downs and aggregations to provide hierarchical data exploration within the user interface.
Adaptation of corporate layout requirements and existing technical templates to the dashboard interface to maintain visual consistency.
Integration of function and procedure calls from the Snowflake database to automate data retrieval and processing within the reports.
Execution of functional tests for all dashboards and reports to verify technical accuracy and data integrity prior to delivery.
Creation of technical documentation including data lineage maps, functional logic descriptions, and maintenance manuals.
Preparation of installation packages and technical deployment protocols for the Go-Live transition.
Creation of status reports and presentation materials documenting the technical progress and milestone achievements of the project.
Documentation of open technical topics and the independent tracking of resolutions based on project requirements.
Planning and moderation of technical status meetings to present service progress and align on the fulfillment of the task description.
The goal after completion of the service is the provision of fully functional, documented, and tested analytics dashboards that meet the specified technical requirements and architecture standards.
Required skills:
PowerBI, Tableau, and Spotfire is required to match various use case scenarios.
Advanced UI/UX Logic: Experience implementing complex drill-downs, hierarchical aggregations, and multi-dimensional filters and parameters to enable deep data exploration.
Corporate Design Integration: Proven ability to adapt corporate layout requirements and technical templates into the dashboard interface for visual consistency..
Snowflake Expertise: Technical experience with Snowflake database technology, specifically calling functions and procedures to automate data processing.
Data Mart Design: Ability to conceptualize and build data marts and underlying structures that ensure scalable and maintainable dashboard performance.
Source Integration: Understanding of data flows from MES and LIMS sources into a Landing Zone for further processing.
Start: 19.01.2026 Duration: until 31.12.2026 Capacity: 20 hours per week Location: 100% remote Languages: fluent German and English