Data Analyst / Cloud Migration - #44204
FORFIRM
Datum: vor 3 Wochen
Stadt: Lugano, TI
Vertragstyp: Ganztags
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
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
- 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
- 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
- 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
Wie bewerbe ich mich?
Um sich für diesen Job zu bewerben, müssen Sie auf unserer Website autorisieren. Wenn Sie noch kein Konto haben, registrieren Sie sich bitte.
Veröffentlichen Sie einen LebenslaufÄhnliche Jobs
Infermiere/a responsabile della Ricerca Infermieristica
Ente Ospedaliero Cantonale (EOC),
Lugano, TI
vor 2 Wochen
L’EOC l’ospedale multisito del Ticino è presente con i suoi istituti sull'intero territorio cantonale per un totale di 1’000 posti letto. L’organizzazione permette di combinare efficacemente approccio locale e visione d'insieme, garantendo alla popolazione un'offerta ospedaliera globale e di prossimità, indipendentemente dal luogo in cui sono richiesti i servizi. Grazie all’impegno e alla competenza degli oltre 6’500 collaboratori e alla...
Segretaria/o (f/m/d) 80-100%
ETAVIS,
Lugano, TI
vor 2 Wochen
Il tuo ruolo Entrerai a far parte di un gruppo amministrativo, svolgendo un ruolo operativo e di supporto essenziale per la buona organizzazione delle attività quotidiane. Cerchiamo una persona con esperienza professionale, capace di lavorare in modo autonomo, preciso e affidabile, e di contribuire alla continuità dell’area amministrativa nel medio termine. Le tue principali mansioni Gestione del centralino telefonico e...
Idraulico
Pemsa Svizzera,
Lugano, TI
vor 4 Wochen
Pemsa è leader svizzero nel settore del reclutamento specializzato nei campi della costruzione, del genio civile, dell’elettricità, della tecnica degli edifici e dell’industria. Grazie a una profonda conoscenza tecnica e a un’esperienza pluriennale nel mercato elvetico, offriamo soluzioni di placement altamente mirate e professionali. La nostra filosofia si basa sull’eccellenza del servizio, la qualità delle relazioni e la valorizzazione del...