описание
Join IDW and build the future of technology with us! We are a leading Portuguese company, recognized for the excellence of our services and, above all, the talent of our people. At IDW, we combine innovation, knowledge and passion to create business solutions that make a difference in large companies, both in Portugal and beyond its borders. We design and implement challenging projects, with real impact, and are looking for creative and motivated minds to grow with us.
задачи
- Design and execute the data migration strategy and ETL processes from SQL Server to Google Cloud Platform
- Create, maintain and orchestrate high-performance ETL/ELT pipelines using Cloud Composer
- Develop and optimize complex SQL queries and architect efficient data schemas in BigQuery
- Program Python scripts to automate data migration, transformation and integration tasks
- Ensure data quality and integrity, also ensuring monitoring, debugging and incident resolution
- Work together with technical teams and end users (business/analysts) to ensure a smooth transition aligned with their needs
- Keep up with GCP innovations and propose continuous improvements to optimize the platform
требования
- Proven experience of 6 to 9 years in data engineering and/or migration
- Advanced command of Google Cloud Platform, with a strong focus on BigQuery design, optimization and cost management
- Solid experience creating, scheduling and monitoring data flows (DAGs) with Cloud Composer
- Advanced level of SQL and Python for developing automation scripts, transforming data and interacting with GCP APIs
- Practical knowledge of the challenges and strategies involved in migrating databases from on-premise environments to the cloud
- Good level of English communication (minimum B2)
- Будет плюсом: We value knowledge of Data Warehousing (Data Vault modeling), use of Power BI and experience with version control (Git)
условия
- Salary in line with the market and the role
- Health insurance
- Meal allowance paid on a meal card
- Additional vacation days
- Continuous feedback, opportunities for growth and recognition for your work
- Exclusive benefits in health and wellness, education, dining, culture and leisure
- Talent referral program
