Senior/Expert Data Modeller/Engineer

Codest Ltd. Company No. 12590542, VAT number: GB363431020; Kraków; On-site; PLN 234,360 - 312,480; Full time

Benefits offered by this job

300 PLN benefits platform

IP Box support

Integration events and education opportunities

Job summary

Codest Ltd. is looking for an experienced Data Modeller/Engineer to join their team in a hybrid role based in Kraków. The successful candidate will design complex SQL queries, develop ETL pipelines, and maintain data models, primarily using BigQuery and GCP Data Fusion.

The role requires a strong background in data modeling, CI/CD processes, and agile methodologies, offering a salary range of 21-28k PLN on B2B. Join us to work in a collaborative environment while contributing to impactful IT solutions.

Qualifications

• 3+ years of experience in SQL querying and optimization.
• Hands-on experience in SQL Data Transformation ELT/ETL pipeline development.
• Experience with Data Vault modeling.

Responsibilities

• Design and optimize SQL queries in BigQuery.
• Build and enhance ELT/ETL pipelines.
• Develop and maintain data models emphasizing Data Vault.

Skills

SQL querying

Data Transformation ELT/ETL

Data Modeling

Data Architectures

CI/CD

Version control (Git)

DataOps

Agile methodologies

Analytical skills

English proficiency

Tools

GCP Data Fusion

Apache Airflow

JIRA

Confluence

Job description

Overview

The Codest is an international tech software company with hubs in Poland delivering global IT solutions and projects. Our core values are Customers and People First, prioritising the needs of our customers and a collaborative environment for our employees to deliver exceptional products and services. Our expertise centers on web development, cloud engineering, DevOps and quality. We have experience with Yieldbird and our mission is to help tech companies build impactful products and scale their IT teams through boosting IT delivery performance.

We offer a growth-oriented, collaborative environment that supports your development at every step. This is a hybrid role based in Kraków.

Project Description

We are looking for an experienced Data Modeller/Engineer. This is a hybrid position; you will be expected to come into the office 8 days per month in Kraków.

Your Responsibilities

• Design, develop, and optimize complex SQL queries in BigQuery with a focus on cost efficiency, performance, and data integrity.
• Build, maintain, and enhance ELT/ETL pipelines, including data transformation design, testing, and production deployment.
• Develop and maintain data models (with a strong emphasis on Data Vault) and apply them in analytical solutions.
• Design and implement data architectures using Kimball, Inmon, and Data Vault methodologies, as well as schemas such as Star, Snowflake, and Medallion.
• Design, implement, and maintain data ingestion pipelines from various sources (REST/SOAP APIs, SFTP, CSV/JSON/XML files) using tools such as GCP Data Fusion, CDAP, or similar.
• Ensure high data quality through testing, validation, and monitoring of data processing workflows.
• Implement and maintain CI/CD pipelines and automated testing for cloud-based data solutions.
• Manage source code and collaborate effectively using version control systems (Git).
• Work within a DataOps framework, focusing on automation, monitoring, and continuous improvement of data pipelines.
• Collaborate with cross-functional teams in an Agile environment (Scrum/Kanban) using tools such as JIRA and Confluence.
• Analyze technical issues and propose effective solutions in data processing and modeling.
• Support team development through knowledge sharing, best practices, and active participation in team growth.
• Continuously develop technical and soft skills, adapting quickly to changing project and technology needs.

Key Requirements

• Proven (3+ years) hands-on experience in SQL querying and optimization of complex queries/transformation in BigQuery, with focus on cost, time-effective SQL coding and concurrency/data integrity.
• Proven (3+ years) hands-on experience in SQL Data Transformation ELT/ETL pipelines development, testing and implementation (ideally in GCP Data Fusion; otherwise other popular products like Apache Airflow are essential).
• Proven experience in Data Modeling (Data Vault modelling is a big advantage) and usage.
• Experience with Data Architectures (Kimball / Inmon / Data Vault) and Schemas (Star, Snowflake, Medalion, Data Vault).
• Experience designing, testing, and implementing data ingestion pipelines on GCP Data Fusion, CDAP or similar tools, including ingestion and parsing of CSV, JSON, XML data from RESTful & SOAP APIs, SFTP servers, etc.
• Proficiency in working with Continuous Integration (CI), Continuous Delivery (CD) and continuous testing tools for cloud-based data solutions.
• Proficiency in Git usage for version control and collaboration.
• Experience in working in a DataOps model.
• Experience in working in an Agile environment and toolset (preferred JIRA/Confluence).
• Strong problem-solving and analytical skills.
• Willingness to learn and develop technical and soft skills rapidly and independently.
• Strong organizational and multi-tasking skills.
• Good team player who embraces teamwork and mutual support.
• Proficient in English (Full professional proficiency).

Our Promise

• 21-28k PLN on B2B
• Hybrid work (8x per month from the office in Kraków)
• 300 PLN to use on our benefits platform, Worksmile – gift cards, medical services, sports, etc.
• IP Box support provisions in our B2B contract
• Integration events, education opportunities and more
• Opportunity to create an impact and grow with the team

Recruitment Process

• 30 minute screening call online with our recruiter
• 1h technical interview
• 1h client interview
• Offer