Data Engineer GCP
Designs and executes migration of data and ETL pipelines from SQL Server to Google Cloud Platform, building and optimizing BigQuery pipelines, schemas, and SQL queries, with Python automation and Airflow/Cloud Composer orchestration. Hybrid role (2 days/week in Lisbon office) at IT consultancy Decskill.
- Compensation
- Not disclosed
- Location
- Portugal
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- 6+ years
- Category
- Data engineering
- Posted
Skills
Must have
- 6–9 years of experience as a Data Engineer
- Strong professional experience with Google Cloud Platform (GCP)
- Significant experience with BigQuery: schema design, complex SQL, performance optimization, partitioning, clustering, cost management
- Experience with Cloud Composer and Apache Airflow for DAG orchestration, scheduling, monitoring, debugging
- Advanced knowledge of SQL
- Strong Python experience for automation, data transformation, migration scripts, GCP API integration
- Experience with data migration from on-premises environments to GCP, ideally SQL Server to BigQuery
- Experience designing and developing ETL/ELT data pipelines
- Strong analytical and problem-solving skills
- English B2 or higher
Full description
We are growing. And we are looking for talented people.
At Decskill, we believe that technological excellence is driven by human talent.
We are an IT consulting company with more than 10 years of consolidated experience in the market, focused on building long-term relationships with both our clients and our people. Today, we are a community of over 800 professionals, working from Lisbon, Porto, and Madrid, contributing to impactful technology initiatives.
As part of the Astek Group, we combine a strong local culture with a global presence, being active in around 23 countries across 4 continents. This allows us to offer an international context, diverse challenges, and long-term career opportunities, while staying close to our teams.
We would like to meet a Data Engineer (GCP) for a project with a hybrid working model in Lisbon, Portugal (2x/week at the office).
Responsibilities:
- Design and execute data and ETL migration strategies from SQL Server to GCP.
- Develop and optimize scripts and pipelines for data transfer and transformation into BigQuery.
- Design, develop, and maintain robust ETL/ELT pipelines on GCP.
- Develop and optimize complex BigQuery SQL queries.
- Design optimized data schemas adapted to cloud architectures.
- Use Python to automate migration, transformation, and integration tasks.
- Implement data quality and integrity processes during and after migration.
- Collaborate with SQL Server administrators, analysts, data scientists, and business users.
- Monitor, debug, and resolve incidents related to data pipelines.
- Participate in code reviews, testing strategies, and development best practices.
- Identify opportunities to improve and optimize the GCP data platform.
Requirements:
- 6–9 years of experience as a Data Engineer.
- Strong professional experience with Google Cloud Platform (GCP).
- Significant experience with BigQuery, including schema design, complex SQL queries, performance optimization, partitioning, clustering, and cost management.
- Solid experience with Cloud Composer and Apache Airflow for DAG orchestration, scheduling, monitoring, and debugging.
- Advanced knowledge of SQL.