Data Analyst - Cloud Migration & BigQuery | FORFIRM

FORFIRM CONSULTING SAGL; Lugano; Vor Ort; CHF 80.000 - 100.000; Vollzeit

Zusammenfassung

FORFIRM CONSULTING SAGL in Lugano, Switzerland is seeking a Data Analyst to assist in migrating data infrastructure to Google Cloud Platform (GCP). You will be involved in every phase, from data analysis to validation.

The ideal candidate possesses a strong analytical mindset, is fluent in Italian and English, and has experience with data modeling and cloud tools. A Bachelor's or Master's degree in a related field is essential for this position.

Qualifikationen

• Bachelor's or Master's degree in a related field is required.
• Strong data analysis and mapping skills are necessary.
• Experience with SQL for data validation is essential.

Aufgaben

• Conduct data analysis and document source data.
• Develop SQL queries for data reconciliation.
• Support migration of legacy reports and data governance.

Kenntnisse

Data analysis

Data mapping

SQL / BigQuery SQL

Data quality assurance

Data modeling

Communication

Problem-solving

Team collaboration

Ausbildung

Bachelor's or Master's degree in Computer Science, Engineering, Mathematics, or related field

Tools

Google Cloud Platform

Looker

ETL/ELT tools

Jobbeschreibung

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