GCP Data Engineer - Banking

Description

Job Summary: We are seeking a GCP Data Engineer for a banking client, focused on developing and maintaining data models, optimizing SQL queries, and collaborating on data ingestion and transformation solutions. Key Highlights: 1. Development and maintenance of data models in BigQuery. 2. Optimization of SQL queries for data extraction and transformation. 3. Collaboration on the implementation of ingestion and transformation solutions. - **Devoteam is a leading European consultancy focused on digital strategy, technology platforms, cybersecurity, and business transformation through technology.** Concentrated on six areas of specialization, we address our clients’ strategic challenges: Digital Business & Products, Data-driven Intelligence, Distributed Cloud, Business Automation, Cybersecurity, and Sustainability achieved through Digitalization. Technology is in our DNA, and we believe in it as a lever capable of driving change for improvement, while maintaining a balance that allows us to offer our clients top-tier technological tools—always with the proximity and professionalism of a team acting as a guide along the way. Our **30 years of experience** make us an innovative, established, and mature consultancy enabling the development of our **12,000 professionals**, continuously certifying our consultants in the latest technologies and counting on experts in: Cloud, BI, Data Analytics, Business Process Excellence, Customer Relationship Management, Cybersecurity, Digital Marketing, Machine Learning, and Software Engineering & Development. Devoteam has been awarded Partner of the Year 2021 by the five leading cloud providers: **AWS, Google Cloud, Microsoft, Salesforce, and ServiceNow.** Devoteam G Cloud is looking for a GCP Data Engineer for a major client in the banking sector. **Responsibilities**: * Assist in the **development and maintenance of simple data models** under supervision, primarily in **BigQuery**. * Write and optimize **SQL queries** for data extraction and transformation, focusing on efficiency and information quality. * Collaborate with the team to understand **data requirements** and help implement basic ingestion and transformation solutions. * Participate in the **initial design of fact tables** and analytical data structures, learning about business needs. Document data transformation processes and developed SQL queries. * **Requirements**: * Interest and/or initial experience (internships, personal projects, courses) in the field of data engineering. * **Intermediate/advanced proficiency in SQL**: Ability to write complex queries (JOINs, window functions, basic optimization). **Mandatory**. * **Preferred knowledge of BigQuery**, and familiarity with the Google Cloud Platform (GCP) environment. * Understanding of fundamental **data modeling concepts** (e.g., differences between fact and dimension tables). Proactivity, eagerness to learn quickly, and ability to work collaboratively, seeking help when needed. * **Desirable**: * Knowledge of or interest in data orchestration tools (Airflow, dbt) or automation scripts. * Basic communication skills with the technical team to report progress and issues. * Experience or familiarity with handling large volumes of data.