Cloud Data Analyst: BigQuery Migration & Analytics

FORFIRM; Lugano; Vor Ort; CHF 90.000 - 120.000; Vollzeit

Zusammenfassung

FORFIRM is migrating its data infrastructure from an on-prem Oracle environment to Google Cloud Platform (GCP), including BigQuery, Cloud Storage, and Dataflow. The Data Analyst will drive as-is data analysis, post-migration validation, and support business teams adopting cloud analytics tools such as Looker and Looker Studio.

You will define data mappings, collaborate with data engineers on transformation rules, and design quality assurance tests across the migration lifecycle with strong data

Qualifikationen

• 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.
• Experience with data engineering, cloud computing or analytics is a plus.

Aufgaben

• Data Analysis & Mapping: inventory and document Oracle source data, perform profiling, define logical mappings from Oracle to BigQuery, collaborate on transformation rules.
• Validation & Quality Assurance: design data reconciliation tests, develop SQL/BigQuery queries, produce data quality reports, track data anomalies, model data (star/snowflake).
• Migration Support: participate in sprint planning, support migration of legacy reports to GCP-native tools (Looker, Looker Studio), contribute to data governance standards and documentation.

Kenntnisse

Analytical mindset

Attention to detail

Communication

Autonomy

Time management

Team player

Problem-solving

Ausbildung

Bachelor's in CS/Engineering/Math

Master's degree (plus)

Tools

BigQuery

SQL

Looker Studio

Looker

Jobbeschreibung

FORFIRM is migrating its data infrastructure from an on-prem Oracle environment to Google Cloud Platform (GCP), including BigQuery, Cloud Storage, and Dataflow. The Data Analyst will drive as-is data analysis, post-migration validation, and support business teams adopting cloud analytics tools such as Looker and Looker Studio.

You will define data mappings, collaborate with data engineers on transformation rules, and design quality assurance tests across the migration lifecycle with strong data