HubMub
-
FORFIRM

Data Analyst – Cloud Migration & BigQuery

FORFIRM
Switzerland · Full-time · Not Applicable
Descrizione Del Lavoro

Our organization is launching a strategic initiative to migrate its data infrastructure from an on-premise Oracle Database environment to Google Cloud Platform (GCP). The project involves consolidating legacy data warehouses, re-architecting ETL/ELT pipelines, and adopting cloud-native services such as BigQuery, Cloud Storage, and Dataflow.

The selected Data Analyst will be a key contributor across every phase of the migration lifecycle: from as-is data analysis of source systems, through post-migration validation, to supporting business teams in their transition to new cloud-based analytics tools

Key Responsibilities

Data Analysis & Mapping

  • Inventory and document Oracle source data (schemas, tables, stored procedures, views)
  • Perform data profiling to identify anomalies, duplicates, and inconsistencies
  • Define logical data mappings from Oracle to BigQuery for each data domain
  • Collaborate with data engineers on the definition of transformation rules

Validation & Quality Assurance

  • Design and implement data reconciliation tests for pre- and post-migration phases
  • Develop SQL / BigQuery SQL queries to compare source and target datasets
  • Produce data quality reports covering completeness, accuracy, and consistency metrics
  • Log and track data anomalies using issue-tracking tools
  • Strong data modeling skills, including conceptual, logical, and physical design, with hands-on experience in normalization and dimensional modeling (star/snowflake schema).

Migration Support 

  • Actively participate in sprint planning and stand-ups with technical and business teams
  • Support the migration of legacy reports into GCP-native tools (Looker, Looker Studio)
  • Contribute to the definition of data governance standards and cloud best practices
  • Document data transformation processes for knowledge transfer purposes

Personal Profile & Soft Skills

  • Strong analytical mindset and attention to detail
  • Ability to communicate complex data findings to non-technical stakeholders
  • Operational autonomy and a proactive approach to problem-solving
  • Good time management in multi-task and project-driven environments
  • Team player: comfortable working in cross-functional IT/Business teams
  • Flexibility and adaptability in contexts of technological change
  • Language: Italian Native or Bilingual
  • Language: English (written and spoken, minimum B2 level)

Education

  • Bachelor's or Master's degree in Computer Science, Engineering, Mathematics, or a related field
  • Specialization courses in data engineering, cloud computing, or analytics are a plus

Candidati ora Conosci un talento?

Key Skills

Ranked by relevance

cloud oracle looker sql gcp google cloud platform data analysis storage
Login to Apply
🇨🇭

Country Guide

Switzerland

Very high salaries and premium quality of life

Posted
Jul 03, 2026
Type
Full-time
Level
Not Applicable
Location
Lugano
Company
FORFIRM

Industries

Business Consulting Services

Categories

Information Technology

Related Jobs

3 roles aligned with this opportunity

View all jobs
View Job Details
Publicis Sapient
Related

Data Analyst- Senior Associate

2026-07-03

Full-time
Not Applicable
Romania
Business Consulting
Information Technology
View Job Details
Publicis Sapient
Related

Data Analyst- Senior Associate

2026-07-03

Full-time
Not Applicable
Romania
Business Consulting
Information Technology
View Job Details
Marsh
Related

Software engineer @MarshTech

2026-07-01

Full-time
Not Applicable
Romania
Insurance
Engineering