F
Data Analyst / Cloud Migration
FORFIRM
Lugano · On-site Today
About the role
About
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
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
- Proficient 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
Skills
BigQueryCloud StorageDataflowGCPGoogle Cloud PlatformLookerLooker StudioOracleSQL
Don't send a generic resume
Paste this job description into Mimi and get a resume tailored to exactly what the hiring team is looking for.
Get started free