BI Developer & Consultant (m/f/d) 80-100%, Basel & remote

Strategic BI consulting & infrastructure

• You support the specification of key figures, authorisation and role concepts and governance rules.

• You advise on architecture decisions and the selection of suitable tools, data sources and interfaces.

• You support the BI infrastructure at tool level - e.g. by setting up, configuring and maintaining Tableau Server/Cloud or Power BI Service.

Modelling & data quality

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

Data visualisation & insights

• You 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 teach 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-design, project responsibility & community

• You manage (sub)projects independently and work closely with project managers and stakeholders.

• You actively contribute your experience to the further development of our processes, tools and standards - professionally, methodically 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 and 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 logics

• 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 in an understandable and target group-orientated way

• Analytical thinking, structured way of working and pragmatism in implementation

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

• Very good German and good English

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

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

• Familiar with Git, Bitbucket and collaborative workflows

• Knowledge of marketing & 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 combine home office, office and customer assignments flexibly as required.

• Five weeks' holiday: Plus an annualised working time model that gives you real time freedom.

• Inspiring team: Interdisciplinary, open, friendly - with expertise, humour and plenty of team spirit.

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

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

• 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 programme.

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