Senior/Expert Data Modeller/Engineer

We are The Codest - International Tech Software Company with tech hubs in Poland delivering global IT solutions and projects. Our expertise centers on web development, cloud engineering, DevOps and quality. We have developed our own product, Yieldbird, honored as a laureate of the Top25 Deloitte awards. We help tech companies build impactful products and scale their IT teams by boosting IT delivery performance.

• Proven 3+ years hands-on experience in SQL querying and optimization in BigQuery focusing on cost, time-effective coding, concurrency, and data integrity.
• Proven 3+ years experience in SQL Data Transformation ELT/ETL pipeline development, testing, and implementation, ideally with GCP Datafusion or Apache Airflow.
• Proven experience in Data Modeling, with Data Vault modeling as a significant advantage.
• Experience with Data Architectures (Kimball, Inmon, Data Vault) and Schemas (Star, Snowflake, Medallion, Data Vault).
• Experience designing, testing, and implementing data ingestion pipelines on GCP Data Fusion, CDAP, or similar tools, including handling CSV, JSON, XML data from RESTful & SOAP APIs, SFTP servers.
• Proficiency with Continuous Integration (CI), Continuous Delivery (CD), and continuous testing tools for cloud-based data solutions.
• Proficiency in Git for version control and collaboration.
• Experience working in a DataOps model.
• Experience working in Agile environments with tools like JIRA and Confluence.
• Strong problem-solving and analytical skills.
• Enthusiastic willingness to learn and develop technical and soft skills rapidly and independently.
• Strong organizational and multi-tasking skills.
• Good team player embracing teamwork and mutual support.
• Proficient in English at full professional proficiency level.

• Design, develop, and optimize complex SQL queries in BigQuery focusing 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 emphasis on Data Vault and apply them in analytical solutions.
• Design and implement data architectures using Kimball, Inmon, and Data Vault methodologies and schemas such as Star, Snowflake, and Medallion.
• Design, implement, and maintain data ingestion pipelines from various sources using tools like GCP Data Fusion or CDAP.
• Ensure high data quality through testing, validation, and monitoring of data workflows.
• Implement and maintain CI/CD pipelines and automated testing for cloud-based data solutions.
• Manage source code and collaborate using version control systems (Git).
• Work within a DataOps framework focusing on automation, monitoring, and continuous improvement.
• Collaborate with cross-functional teams in Agile environment using JIRA and Confluence.
• Analyze technical issues and propose effective solutions in data processing and modeling.
• Support team development through knowledge sharing and best practices.
• Continuously develop technical and soft skills adapting to changing project and technology needs.

This is a hybrid position requiring presence in the Kraków office 8 days per month.