Data Analyst: GCP & BigQuery Analytics

GeorgiaTEK Systems Inc.; México; On-site; MXN 260,000 - 420,000; Full time

Job summary

GeorgiaTEK Systems Inc. is seeking a Data Analyst to validate and reconcile enterprise datasets, enhance SQL queries in Google BigQuery, and derive data-driven insights for business teams.

The role involves analyzing large-scale datasets, ensuring data quality, and collaborating with Data Engineering on ingestion, transformation, and reporting needs within a Google Cloud Platform environment.

Qualifications

• Strong expertise in SQL and query optimization.
• Hands-on experience with Google BigQuery.
• Experience with Python for data analysis and automation.
• Knowledge of data warehousing, ETL/ELT concepts and analytics platforms.

Responsibilities

• Perform data analysis validation and reconciliation across enterprise datasets.
• Develop and optimize SQL queries using BigQuery.
• Analyse large-scale structured and semi-structured datasets to identify trends, patterns, and business opportunities.
• Support business teams with ad-hoc analysis and data-driven recommendations.
• Monitor data quality, investigate anomalies and perform root cause analysis.
• Collaborate with Data Engineering teams on data ingestion, transformation and reporting requirements.
• Work with GCP services to support analytics and reporting solutions.
• Define KPIs, metrics, data validation rules and business reporting requirements.
• Document data flows, business rules and analytical findings.

Skills

SQL

Google BigQuery

Python

Data warehousing/ETL

Job description

GeorgiaTEK Systems Inc. is seeking a Data Analyst to validate and reconcile enterprise datasets, enhance SQL queries in Google BigQuery, and derive data-driven insights for business teams.

The role involves analyzing large-scale datasets, ensuring data quality, and collaborating with Data Engineering on ingestion, transformation, and reporting needs within a Google Cloud Platform environment.