×
Johan Pettersson

Johan Pettersson

Big Data Specialist

Sundbyberg, Stockholm, SE
+46-768-907790
Swedish, English

Background


About

About

Senior Systems Architect and Data Engineer with a proven track record of implementing Analytical Solutions on cloud and on-premise infrastructures. A quick learner and a troubleshooter at heart with a genuine interest in technology. Manages the full life cycle from idea to deployment and helps solving practical issues related to operating large-scale systems in production.

Work Experience

Work Experience

  • Founder and ConsultantBig Data AB

    Dec, 2011 - Present

    Yada

    • Stuff

  • Lead Data Engineer, ICA Sverige AB

    Apr, 2022 - Dec, 20242 years 8 months

    Actively participated in architecting and developing central parts of ICAs cloud based data warehouse.

    • Design and implementation of a "Batch Framework" built on dbt to support ICAs layered data warehouse. Data-transformation managed by dbt and scheduling with Cloud Workflows and Cloud Build. Focus on developer experience and CICD-processes.

    • Design and implementation of a "Sales-API" with near realtime store-KPIs for end-user applications. Data provided from BigQuery through a GraphQL-API hosted on Cloud Run. Focus on performance and scalability.

    • Design and implementation of a "Semantic Layer" on Looker Core and BigQuery for reporting of point-of-sales data. Focus on re-use, performance and cost-efficiency.

    • GraphQL, Python, Terraform, Google Cloud Platform, Looker, Dbt, BigQuery, Google Looker

  • Senior Data Engineer, Storytel AB

    Jul, 2021 - Mar, 20231 year 8 months

    Implementation of analytical data-models (in dbt and BigQuery) with end-user analytical functionality in Looker for international book-publishing and streaming.

    • Custom Data Studio (now Looker Studio) plugin for integration with Looker for external publishers

    • Ingestion mechanism from event-streams from PubSub to BigQuery

    • Flexible BigQuery batch-export in Python

    • Python, Terraform, Google Cloud Platform, Apache Airflow, Looker, Dbt, BigQuery

  • Senior Data Engineer, ICA Sverige AB

    Mar, 2021 - Jun, 20213 months

    Senior Data Engineer in two parallel initiatives at ICA, both with a clear focus on transitioning from on-premise solutions to Google Cloud Platform.
    One project at ICA Group level, with a focus on establishing an architecture and design-patterns for a common Data Lake and Machine Learning platform. The platform should support all companies within the group with a strong focus on reusability and isolation between different tenants. Initial use-case was focused on transitioning a legacy solution for ICA Fastigheter onto GCP.
    The other project, at ICA Sverige, aimed to establish a new Cloud Data Warehouse platform with several delivery teams working in parallel to onboard data sources.
    Both projects with a strong focus on leveraging managed products within GCP, security and efficient use of infrastructure as code.

    • Terraform, Google Cloud Platform, Dataflow, BigQuery

  • Senior Data Engineer, Embark Studios

    Jun, 2020 - Dec, 20206 months

    Implementing telemetry solution for an upcoming multi-player video-game.
    Solution spans from game-client and backend through backendservices to a GCP-hosted analytical platform.
    High degree of complexity due to different technologies, protocols and languages used in the underlying frameworks and platforms.

    • Java, Golang, Protocol Buffers, Unreal game engine, Angelscript, Terraform, C++, BigQuery

  • Big Data Architect, Kivra AB

    Jun, 2019 - Dec, 20201 year 6 months

    Initially in an advisory role as Big Data specialist with focus on hybrid architectures, event-sourcing and analytical platforms.
    From January 2020 as architect and senior Data Engineer designing and implementing Google Cloud Platform-based analytical solution coupled with an on-premise Kafka event-integration platform.

    • Kafka, Google Cloud Platform, Dataflow, BigQuery

  • Solution Architect, Tele2 AB

    Jan, 2016 - Feb, 20204 years 1 month

    Solution Architect of a multi-tenant data lake supporting the Tele2 group as a shared service. Focus on building a common foundation with a high degree of security and information integrity to meet existing and upcoming regulations on storage and processing of sensitive personal information.

  • Big Data Expert, Swedish Armed Forces

    Apr, 2018 - Dec, 20191 year 8 months

    Architecture and implementation.

  • Big Data Specialist / Product Owner, Kambi Sweden AB

    May, 2017 - Dec, 20177 months

    Advisory role as Big Data Specialist starting up "Data Pipeline & Data Store"- team. Focus on knowledge transfer in the areas of architecture and analytics.

  • Big Data Specialist, AB Svenska Spel

    Mar, 2013 - Sep, 20163 years 6 months

    Big Data Architect designing and implementing a Data Warehouse and Analytics infrastructure based on Hadoop technology. The project had a strong emphasis on knowledge transfer and helping to form the organization for development and operations as well as showcasing analytics capabilities.

  • Big Data Expert, Telia Company AB

    Aug, 2015 - Jan, 20165 months

    Advisory role as Big Data Expert in a program to establish a multi-tenant data lake supporting multiple TeliaSonera markets and organizations.

  • Big Data Architect, Klarna AB

    Sep, 2013 - Apr, 20147 months

    Supporting Klarna's Data Vault-team as Big Data Architect with hands-on tutoring on implementing Hive, Oozie and general MapReduce knowledge.

  • Data Architect, King.com / Midasplayer AB

    Aug, 2011 - Mar, 20131 year 7 months

Skills

Skills

  • Data Engineering

    BigQuery

    Looker

    SQL

    dbt

  • Systems Development

    Java

    Python

    Golang

    GraphQL

  • Integration & Infrastructure

    Google Cloud Platform

    Terraform

    Kafka

  • Industries

    Retail

    Telecom

    Online Gaming

    Recruitment

Certificates

Certificates