Informacje o stanowisku
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 our Data & Analytics Competency Center!
Your Role
- Develop and implement scalable, high-performance data architectures
- Design data models, schema and structures that support business needs
- Ensure solutions are designed for optimal performance, scalability, and reliability
- Write, debug, and optimize complex SQL queries and stored procedures
- Develop ETL (Extract, Transform, Load) processes using tools and technologies compatible with Snowflake
- Implement and manage data integration solutions
- Analyze performance issues and implement solutions to enhance data processing efficiency
- Participate in code reviews and ensure adherence to development standards and best practices
Your Skills
- At least 4 years of working with programming languages focused on data pipelines (Python or R)
- Experience with data modeling, data warehousing, and ETL processes
- Proficiency in SQL and experience in the Snowflake cloud environment
- Previous 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 Dataflow
- Experience 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 systems
- Very good knowledge of relational databases and data serialization languages such as JSON, XML, YAML
- Excellent knowledge of Git, Gitflow, and DevOps tools, e.g. Docker, Bamboo, Jenkins, Terraform
- Capability to conduct performance analysis, troubleshooting, and remediation
- Knowledge of Pharma data formats is a big plus
Job no.240702-JNCIR
#J-18808-Ljbffr
Praca ToruńToruń - Oferty pracy w okolicznych lokalizacjach