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

Strategic BI consulting & infrastructure

• You will assist with the specification of key figures, 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. by setting up, configuring and maintaining Tableau Server/Cloud or Power BI Service.

Modelling & Data Quality

• You will ensure that all visualisations are based on a consistent, traceable and maintainable database.
   
• You analyse requirements, existing business logic and available data structures in order to develop targeted data models for BI applications. You model and transform data directly in 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 will ensure that data models are logical, resilient and future-proof.

Data visualisation & insights

• You will design and develop dashboards – depending on the use case, target group 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 operational and strategic processes.

Training, Enablement & Data Culture

• You conduct on-the-job training and support analysts, power users and specialist departments in the efficient use of BI tools.

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

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

Co-creation, project responsibility & community

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

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

• You will 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.

Must-haves

• Experience in developing dashboards with 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 in working with data from digital marketing, CRM, ERP or offline systems

• Ability to communicate technical concepts in a clear and target group-oriented manner

• Analytical thinking, structured approach to work and pragmatism in implementation

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

• German (C1/C2) and English (at least 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 in cross-functional teams

• Hybrid working: You can flexibly combine working from home, the office and client sites as needed.

• Five weeks of holiday: Plus an annual working time model that gives you real freedom in terms of time.

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

• Varied projects: Collaboration with leading companies and diverse industries.

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

• Structured onboarding: You start with a systematic induction plan and rapid integration into the team.

• Regular development meetings: Personal assessment and individual development goals are part of our approach.

• Active participation: 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.