data engineer in pharmaceutical data infrastructure

The project supports initiatives in AWS, AI, and data engineering for a major science and technology company in the pharmaceutical industry. It is modernizing data infrastructure by transitioning to Snowflake to enable advanced AI solutions and future innovation.

• Design and work with Snowflake databases, schemas, views, and RAW, STG, and MART data layers
• Manage access using RBAC, role hierarchies, row-level security, and column-level access policies
• Work with dynamic tables, external stages, Snowpipe, and batch data loading
• Build and support reliable, production-grade Snowflake data pipelines
• Write optimized SQL queries for data extraction, transformation, and loading
• Use Python for advanced data processing, automation, and system integration
• Advise on Snowflake architecture, features, and best practices
• Develop and maintain complex data pipelines and ETL processes in Snowflake
• Collaborate with data architects, analysts, and stakeholders to design scalable data solutions
• Automate DBT jobs and build CI/CD pipelines using Azure DevOps
• Ensure data quality, integrity, and compliance throughout the data lifecycle
• Troubleshoot, optimize, and enhance data processes and queries
• Document data models, processes, and workflows
• Build data tests, unit tests, and mock data frameworks

• Master’s degree in computer science, information technology, or a related field
• 5+ Years of data engineering experience, including hands-on expertise in Snowflake and DBT
• Extensive hands-on experience writing complex SQL queries and working with large data volumes
• Strong understanding of data warehousing and data modeling techniques, including OLTP, OLAP, and Data Vault 2.0
• Experience building data transformation pipelines using DBT
• Familiarity with Snowflake performance tuning and query optimization
• Strong knowledge of CI/CD pipelines, preferably in Azure DevOps
• Excellent problem-solving, analytical, and critical thinking skills
• Strong communication, collaboration, and interpersonal skills
• Будет плюсом: AWS, Streamlit, additional data technologies such as AWS, Azure, or GCP, Infrastructure as Code tools such as Terraform or CloudFormation, experience leading projects or mentoring junior developers

• Условий в вакансии нет