ETL Developer

  • Kraków
  • Groupe Sii
We are looking for an ETL Developer/Data Engineer to work on various data products dedicated to the pharmaceutical industry. The solutions you will be developing enable services and applications to provide insight for commercial customer service relevant data as well as proactive maintenance and repair to the client.Apply to Sii and join ourData & Analytics Competency Center!Your roleDevelop and implement scalable, high-performance data architecturesDesign data models, schema and structures that support business needsEnsure solutions are designed for optimal performance, scalability, and reliabilityWrite, debug, and optimize complex SQL queries and stored proceduresDevelop ETL (Extract, Transform, Load) processes using tools and technologies compatible with SnowflakeImplement and manage data integration solutionsAnalyze performance issues and implement solutions to enhance data processing efficiencyParticipate in code reviews and ensure adherence to development standards and best practicesYour skillsAt least 4 years of working with programming languages focused on data pipelines (Python or R)Experience with data modeling, data warehousing, and ETL processesProficiency in SQL and experience in the Snowflake cloud environmentPrevious work with different types of storage (filesystem, relations, MPP, NoSQL) and various kinds of data (structured, unstructured, metrics, logs, etc.)Familiarity with data integration tools (e.g. Talend, Informatica) and cloud platforms (preferably AWS)Exposure to open-source and proprietary cloud data pipeline tools such as Airflow, Glue, DBT, and DataflowExperience in working in data architecture concepts in any of the following areas: data modeling, metadata, workflow management, ETL/ELT, real-time streaming, data quality, distributed systemsVery good knowledge of relational databases and data serialization languages such as JSON, XML, YAMLExcellent knowledge of Git, Gitflow, and DevOps tools, e.g. Docker, Bamboo, Jenkins, TerraformCapability to conduct performance analysis, troubleshooting, and remediationKnowledge of Pharma data formats is a big plusJob no.240702-JNCIR