SeniorExpert Data ModellerEngineer

Hello World!

We are The Codest - International Tech Software Company with tech hubs in Poland delivering global IT solutions and projects. Our core values lie in Customers and People First approach that prioritises the needs of our customers and a collaborative environment for our employees enabling us to deliver exceptional products and services.

Our expertise centers on web development cloud engineering DevOps and quality. After many years of developing our own product - Yieldbird which was honored as a laureate of the prestigious Top25 Deloitte awards we arrived at our mission: to help tech companies build impactful product and scale their IT teams through boosting IT delivery performance. Through our extensive experience with product development challenges we have become experts in building digital products and scaling IT teams.

But our journey does not end here - we want to continue our growth. If youre goal-driven and looking for new opportunities join our team! What awaits you is an enriching and collaborative environment that fosters your growth at every step.

Project Description:

We are looking for an experienced Data Modeller/Engineer.

Please note: this is a hybrid position you will be expected to come into the office 4-6 days per month overall (the office is located in Kraków).

Your Responsibilities:

• Design develop and optimize complex SQL queries in BigQuery with a strong 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 the area of 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 (must have) with a 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 Datafusion otherwise other popular product like Apache Airflow is essential)

• Proven Experience in Data Modeling (Data Vault modelling is a big advantage here) and usage.

• Experience with Data Architectures (Kimbal / 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 and wrangling of CSV JSON XML etc formatted data from RESTful & SOAP APIs SFTP servers etc.

• Proficiency in working with Continuous Integration (CI) Continuous Delivery (CD) and continuous testing tools ideally for Cloud based Data solutions

• Proficiency in Git usage for version control and collaboration.

• Experience in working in DataOps model

• Experience in working in Agile environment and toolset - preferred JIRA/Confluence.

• Strong problem-solving and analytical skills

• Enthusiastic willingness to learn and develop technical and soft skills as needs require 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 (what you can expect from us):

• 22-30k PLN on B2B

• Hybrid work (4-6x per month from the office in Kraków)

• A unique opportunity to take your career to the next level - were looking for people who want to create an impact. You have ideas we want to hear them!

Recruitment process:

• 30 minute screening call online with our recruiter Justyna

• 1h technical interview

• 1h client interview

• Offer

Questions insights Feel free to reach out to our recruiting team:

In the meantime feel free to visit our website where you can find key facts about us.