Senior Snowflake Data Engineer

The project is for one of the world's famous science and technology companies in pharmaceutical industry, supporting initiatives in AWS, AI and data engineering, with plans to launch over 20 additional initiatives in the future. Modernizing the data infrastructure through the transition to Snowflake as a priority, as it will enhance capabilities for implementing advanced AI solutions and unlock numerous opportunities for innovation and growth.

We are seeking a highly skilled Snowflake Data Engineer to design, build, and optimize scalable data pipelines and cloud-based solutions across AWS, Azure, and GCP. The ideal candidate will have strong expertise in Snowflake, ETL Tools like DBT, Python, visualization tools like Tableau and modern CI/CD practices, with a deep understanding of data governance, security, and role-based access control (RBAC). Knowledge of data modeling methodologies (OLTP, OLAP, Data Vault 2.0), data quality frameworks, Stream lit application development and SAP integration and infrastructure-as-code with Terraform is essential. Experience working with different file formats such as JSON, Parquet, CSV, and XML is highly valued.

• In-depth knowledge of Snowflake's data warehousing capabilities.
• Understanding of Snowflake's virtual warehouse architecture and how to optimize performance and cost.
• Proficiency in using Snowflake's data sharing and integration features for seamless collaboration.
• Develop and optimize complex SQL scripts, stored procedures, and data transformations.
• Work closely with data analysts, architects, and business teams to understand requirements and deliver reliable data solutions.
• Implement and maintain data models, dimensional modeling for data warehousing, data marts, and star/snowflake schemas to support reporting and analytics.
• Integrate data from various sources including APIs, flat files, relational databases, and cloud services.
• Ensure data quality, data governance, and compliance standards are met.
• Monitor and troubleshoot performance issues, errors, and pipeline failures in Snowflake and associated tools.
• Participate in code reviews, testing, and deployment of data solutions in development and production environments.