Data Engineer (GCP)
Description
Hexa Consulting is looking for a Data Engineer (GCP) to join our Client's team in a hybrid work model from Lisbon or Porto.
Lisbon or Porto, Portugal | Hybrid | Banking Sector
Join a cloud data engineering initiative focused on modernizing enterprise data infrastructure and migrating existing data solutions to Google Cloud Platform (GCP).
You will contribute to the design of scalable data architectures, the development of reliable data pipelines and the transition from traditional database environments to cloud-native solutions.
Mandatory Requirements
- 6 to 9 years of professional experience in Data Engineering, Data Integration or Cloud Data Platform Development.
- Strong hands-on experience with Google Cloud Platform (GCP), particularly BigQuery and Cloud Composer.
- Proven experience designing, developing and optimizing ETL/ELT pipelines in complex data environments.
- Experience with database migration strategies, including on-premises to cloud migrations.
- Advanced SQL skills, including complex queries, performance optimization and data modeling.
- Strong Python development skills for automation, data transformation and integration with cloud services.
- Experience with BigQuery schema design, partitioning, clustering and query cost optimization.
- Knowledge of data warehousing, data quality validation and integrity controls.
- Ability to analyze existing database structures, identify dependencies and design effective migration solutions.
- Professional working proficiency in English (minimum B2).
- Strong analytical, troubleshooting and problem-solving skills.
- Autonomy, effective communication and the ability to collaborate with multidisciplinary teams.
Nice to Have
- Experience with Microsoft SQL Server, including T-SQL, database architecture and basic administration.
- Knowledge of additional GCP services, particularly Cloud Storage and Dataflow.
- Familiarity with Google Cloud Database Migration Service.
- Experience with Power BI.
- Understanding of Data Vault modeling.
- Experience with version control systems and collaborative code management.
- Data Processing & Warehousing: BigQuery, Advanced SQL, ETL/ELT, Data Warehousing.
- Programming: Python, SQL.
- Data Migration: On-premises to Cloud Migration, Database Migration Strategies.
- Data Architecture: Data Modeling, Schema Design, Partitioning, Clustering.
- Data Quality & Optimization: Data Validation, Pipeline Monitoring, Performance and Cost Optimization.
Key Responsibilities
- Design and implement data migration solutions from SQL Server environments to GCP.
- Develop, maintain and optimize ETL/ELT pipelines for reliable data integration and transformation.
- Build scalable cloud data processing solutions using BigQuery and Cloud Composer.
- Develop complex SQL queries and optimize BigQuery performance through efficient data modeling, partitioning and clustering.
- Create Python scripts to automate migration activities, data processing and integration with GCP services.
- Implement data validation and integrity controls throughout migration processes.
- Analyze existing database structures and contribute to optimized cloud data architectures.
- Collaborate with database specialists, data analysts and business stakeholders to define technical requirements.
- Monitor data pipelines, troubleshoot technical issues and resolve incidents during migration and production operations.
- Participate in code reviews, testing and continuous improvement initiatives.
- Identify opportunities to improve performance, reliability and cloud cost efficiency.
What We Offer
- Work Model: Hybrid.
- A culture where each person is encouraged to act as a Builder, contributing with ownership, responsibility and impact.
- A collaborative environment built on Honesty, Mutual Support and Agility.
- Continuous learning and certification support throughout your journey.
- Private health insurance from day one, with optional family extension.
- Confidential mental health support through TEAM 24, including psychological support, content and live sessions.
- Childcare vouchers and practical family support measures.
- Opportunities to grow through exposure to quality management, information security, AI governance and cybersecurity best practices.
Hexa is committed to equal opportunity, inclusion and fair access to professional growth. We value diverse backgrounds, perspectives and experiences, and we support the principles of the Portuguese Diversity Charter in the way we build teams and opportunities.
Life at Hexa means being part of a community of Builders. We work with transparency, support each other across projects and geographies, and stay focused on learning, adapting and delivering work that creates real impact.
Skills
Sign in to read and join the discussion.