BI Developer & Consultant (all genders)
80–100%, Basel & remote

Strategic BI Consulting & Infrastructure

• You will assist with the specification of key performance indicators, authorisation and role concepts, and governance rules.

• You will be a consultant who advises on architectural decisions and the selection of suitable tools, data sources and interfaces.

• You will manage the BI infrastructure at the tool level – e.g. through the setup, configuration and maintenance of Tableau Server/Cloud or Power BI Service.

Modelling & Data Quality

• You will ensure that all visualisations are based on a consistent, traceable and maintainable data foundation.
   
• You analyse requirements, existing business logic and available data structures to develop targeted data models for BI applications. You model and transform data directly within the BI tool (e.g. DAX, LOD) or via SQL (e.g. views in BigQuery).
   
• You define and document KPIs, mappings and semantic structures.
   
• You ensure that data models are structured in a logical, robust and future-proof manner.

Data Visualisation & Insights

• You design and develop dashboards – depending on the use case, target audience and platform strategy.

• You design visualisations that convey complex relationships clearly and interactively.

• You use BI tools as a lever for control, transparency and optimisation in both operational and strategic processes.

Training, Enablement & Data Culture

• You will deliver on-the-job training and support analysts, power users and business units in the efficient use of BI tools.

• You share best practices for self-service, documentation and sustainable data maintenance.

• You will support the organisational integration of BI – for example, through defined roles, processes and responsibilities.

Co-creation, Project Responsibility & Community

• You will lead (sub-)projects independently and work closely with projectmanagers and stakeholders.

• You actively contribute your experience to the further development of our processes, tools and standards – technically, methodologically and culturally.

• You keep up to date with current trends and best practices in the field of BI & visualisation and actively participate in specialist communities, meetups or conferences.

Essential requirements

• Experience in developing dashboards using Power BI and/or Tableau

• Knowledge of BI infrastructure, setup and configuration (e.g. Tableau Server/Cloud, Power BI Service, workspace management)

• Good knowledge of data modelling, data cleansing and KPI logic

• Solid understanding of SQL and/or logical modelling within BI tools

• Experience working with data from digital marketing, CRM, ERP or offline systems

• Ability to communicate technical concepts clearly and in a manner appropriate to the target audience

• Analytical thinking, a structured approach to work and a pragmatic approach to implementation

• Basic experience in project management and task planning (e.g. in Jira)

• German (C1/C2) and English (min. B2/C1)

Nice-to-haves

• Experience with Looker Studio or other visualisation front-ends

• Knowledge of Tableau Prep, Power Query or comparable ETL/modelling tools

• Experience with Google BigQuery and modern cloud data warehouses

• Experience with SQL-based transformation tools such as Dataform or dbt

• Familiarity with Git, Bitbucket and collaborative workflows

• Knowledge of marketing and customer analytics – e.g. customer journeys, website/app usage, social media, CRM, newsletters

• Understanding of event- and session-based data structures (e.g. GA4, Adobe Analytics)

• Project experience in an agency environment or within cross-functional teams

• Hybrid working: You can flexibly combine working from home, working in the office and visiting clients as needed.

• Five weeks’ holiday: Plus an annual working time model that gives you real flexibility.

• Inspiring team: Interdisciplinary, open, friendly – with professional expertise, a sense of humour and plenty of team spirit.

• Diverse projects: Collaboration with leading companies across a wide range of industries.

• Targeted career development: With a clear competency model that offers you guidance and opportunities for growth.

• Structured onboarding: You’ll start with a systematic induction plan and be quickly integrated into the team.

• Regular development reviews: Personal progress reviews and individual development goals are part of the package here.

• Active involvement: You actively contribute your ideas to methods, tools and our corporate culture.

The roles, tasks and responsibilities at zweipunkt are varied. The demands on our employees' competences are correspondingly diverse. The framework for this is provided by our competency model, on which we base our role, task and job profiles as well as the assessment and planning of personal and professional development.

You should have the following for this role:

• You have demonstrable skills in digital analytics and already have experience and knowledge of the above fields of action, tools and technologies.

• You have a passion for working with data and love to advise and support clients on data-related topics.

• You have a basic understanding of digital marketing topics as well as the networked activities on various marketing channels (e.g. social media, SEA/advertising, e-mail, SEO) and their influence on the success of a company.

• You can think in a networked way, find solutions where others only see problems and keep a cool head even in turbulent situations.

• You have strong self-management, social, communication and organisational skills, an interest in entrepreneurial topics and are motivated to actively shape and drive your professional and personal development.

• You have a solid command of German (C1/C2) and English (at least B2/C1), both written and spoken.