Google Cloud Platform - Data Engineer (all genders) 80-100%, Basel

Data Ingestion & Integration

• You develop robust ELT/ETL processes based on Python, Cloud Functions, Dataform and Adverity.

• You orchestrate data pipelines to connect and harmonise a wide variety of data sources - e.g. GA4, Adobe Analytics, Ads, Social, CRM, ERP or offline systems.

• You structure data flows so that they are reliable, scalable and maintainable in the long term.

Data transformation & modelling

• You model and manage data in Google BigQuery - scalable, high-performance and cost-optimised.
  
• You design, implement and validate data-based logics, KPIs and aggregations that precisely map operational and strategic business processes - e.g. sessions, funnels or attribution models.
  
• You think in terms of structures that grow with you - maintainable, efficient and practical. You don't just think technically, but always from a solution-orientated customer perspective.

Data Serving & Activation

• You provide data specifically for analysis, reporting or activation - e.g. via structured views, snapshot tables or exports to target systems.

• You work closely with analysts, BI developers and data scientists to make insights usable and activatable.

• Optional: You support the visualisation of insights in Tableau or Power BI - in a target group-oriented and actionable way.

• Optional: You support projects to activate marketing data, e.g. for retargeting, CRM personalisation or audiences in media platforms.

Consultancy & enablement

• You will work closely with customers and projectmanagers, analyse requirements and develop data-supported solutions based on them.

• You support analysts in the effective use of data, tools and technologies.

• You document your architecture, pipelines and KPIs clearly and maintainably.

Co-creation, project responsibility & community

• You take responsibility for (sub)projects and work closely with projectmanagers and other stakeholders, actively contributing to the progress and success of the project.

• You actively contribute your experience to the further development of our processes, tools and standards - professionally, methodically and culturally.

• You follow current developments in the areas of data architecture, modelling and activation and get involved in specialist communities - e.g. through meetups, conferences or internal knowledge formats.

Must-haves

• Sound knowledge of SQL, relational databases and modern cloud data warehouses (ideally with Google BigQuery)

• Very good knowledge of Python for ELT/ETL, data preparation and API connections

• Experience with Dataform, dbt or comparable tools for transformation

• Familiar with Git / Bitbucket and collaborative workflows

• Knowledge of GCP (including cloud functions, possibly cloud run, scheduler, IAM)

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

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

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

• Ability to present technical concepts in an understandable way for different target groups

• Analytical thinking, structured way of working and pragmatism in implementation
  Very good German and good English

Nice-to-haves

• Experience with Tableau, Power BI or Looker Studio (dashboard design and implementation)

• Experience with data science, advanced analytics, AI & machine learning - e.g. in scoring, attribution or forecasting

• Experience in setting up and operating cloud infrastructures on GCP - e.g. IAM, scheduler, monitoring or cost control

• Expertise in marketing & customer analytics - e.g. customer journeys, website/app usage, social media, advertising, CRM, newsletters

• Knowledge of digital analytics & tag management (e.g. GTM, Tealium, GA4)

• Experience with the activation of marketing data - e.g. through exports to CRM, CDP or media platforms

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