Data Analyst - Cloud Migration & BigQuery | FORFIRM

#### Data Analyst - Cloud Migration & BigQuery ####

* Lugano, Switzerland

* Tempo pieno

* In sede

* 70,000-80,000 CHF / Anno

Candidati ora Conosci un talento?

Condividi

--------------------

1.

2. Posizioni aperte

3. Data Analyst - Cloud Migration & BigQuery

1.

2. Data Analyst - Cloud Migration & BigQuery

##### 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?

Condividi

--------------------

1.

2. Posizioni aperte

3. Data Analyst - Cloud Migration & BigQuery

1.

2. Data Analyst - Cloud Migration & BigQuery