SCA Pharma

Data Engineer

• Develop automated data pipelines and data stores in Snowflake: including designing, implementing, testing, debugging, and deploying
• Build metadata driven solutions that are reusable and highly configurable
• Develop complex SQL queries, stored procedures, and scripts for data manipulation and retrieval.
• Optimize Snowflake performance through effective data modeling, partitioning, and indexing strategies.
• Collaborate with data analysts, PowerBI Report Developers and business stakeholders to understand data requirements and deliver precise reporting and analytical solutions.
• Ensure data integrity and security within the Snowflake environment, complying with industry regulations and standards.
• Work on an agile team to quickly iterate and release solutions.
• Provide technical expertise and support for Snowflake to internal teams, including troubleshooting and resolving issues.
• Stay up to date with Snowflake features and updates, continuously improving and expanding our data warehouse capabilities.
• Develop and maintain documentation for Snowflake processes, systems, and procedures.

Senior Data Engineer