Data Analyst / Cloud Migration

Forfirm
Lugano, Switzerland
16 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Compensation
CHF 208K

Job location

Lugano, Switzerland

Tech stack

Data analysis
Google BigQuery
Cloud Computing
Cloud Storage
Information Engineering
Data Governance
Data Infrastructure
ETL
Data Profiling
Data Warehousing
Document-Oriented Databases
Data Flow Control
Oracle
Oracle Applications
Scrum
SQL Stored Procedures
SQL Databases
Google Cloud Platform
Google Data Studio
Information Technology
Cloud Migration
Looker Analytics
Data Pipelines
Serverless Computing

Job description

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., 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

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

Requirements

Do you have experience in SQL?, Do you have a Master's degree?, * 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
  • Proficient English (written and spoken, minimum B2 level), * 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

Apply for this position