Data Analyst – Cloud Migration & BigQuery

None  •  IT & Software  •  Lugano, Switzerland

<div class="show-more-less-html__markup show-more-less-html__markup--clamp-after-5 relative overflow-hidden"> <strong>Descrizione Del Lavoro<br/><br/></strong>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.<br/><br/>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<br/><br/><strong>Key Responsibilities<br/><br/></strong><strong>Data Analysis &amp; Mapping<br/><br/></strong><ul><li>Inventory and document Oracle source data (schemas, tables, stored procedures, views)</li><li>Perform data profiling to identify anomalies, duplicates, and inconsistencies</li><li>Define logical data mappings from Oracle to BigQuery for each data domain</li><li>Collaborate with data engineers on the definition of transformation rules<br/><br/></li></ul><strong>Validation &amp; Quality Assurance<br/><br/></strong><ul><li>Design and implement data reconciliation tests for pre- and post-migration phases</li><li>Develop SQL / BigQuery SQL queries to compare source and target datasets</li><li>Produce data quality reports covering completeness, accuracy, and consistency metrics</li><li>Log and track data anomalies using issue-tracking tools</li><li>Strong data modeling skills, including conceptual, logical, and physical design, with hands-on experience in normalization and dimensional modeling (star/snowflake schema).<br/><br/></li></ul><strong>Migration Support <br/><br/></strong><ul><li>Actively participate in sprint planning and stand-ups with technical and business teams</li><li>Support the migration of legacy reports into GCP-native tools (Looker, Looker Studio)</li><li>Contribute to the definition of data governance standards and cloud best practices</li><li>Document data transformation processes for knowledge transfer purposes<br/><br/></li></ul><strong>Personal Profile &amp; Soft Skills</strong><br/><br/><ul><li>Strong analytical mindset and attention to detail</li><li>Ability to communicate complex data findings to non-technical stakeholders</li><li>Operational autonomy and a proactive approach to problem-solving</li><li>Good time management in multi-task and project-driven environments</li><li>Team player: comfortable working in cross-functional IT/Business teams</li><li>Flexibility and adaptability in contexts of technological change</li><li>Language: Italian Native or Bilingual</li><li>Language: English (written and spoken, minimum B2 level)<br/><br/></li></ul><strong>Education<br/><br/></strong><ul><li>Bachelor's or Master's degree in Computer Science, Engineering, Mathematics, or a related field</li><li>Specialization courses in data engineering, cloud computing, or analytics are a plus<br/><br/></li></ul> Candidati ora Conosci un talento? </div>

Job Overview
  • Datum der Veröffentlichung

    Jul 02, 2026

  • Kategorie

    IT & Software

  • Job Type

  • Standort

    Lugano, Switzerland

  • Arbeitgeber

    FORFIRM

  • Source

    LinkedIn