Senior/Expert Data Modeller/Engineer
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