Senior Data Modeller / Engineer

About Company: Aperture Cloud is Poland’s leading nearshore and offshore IT provider. Since 2008 we successfully create and develop software for our clients. We specialize in Agile and DevOps-based software development. From the analysis stage through implementation. We develop backend, frontend, and mobile applications. For one of our clients, we are looking for a Senior / Expert Data Modeller / Engineer The role is hybrid and the client requires visits in the Cracow office 8 days per month (it can be 8 days in a row). 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. Benefits: Long-term cooperation Multisport, private healthcare, life insurance Training budget English lessons Support from a dedicated partnership consultant