Senior Data Engineer

Description

Company Description

SCA Pharmaceuticals is a dynamic rapidly growing company consisting of passionate individuals who believe in our mission of providing high quality medications that are critical in saving and sustaining human life. SCA Pharma is an FDA 503B outsourcing facility providing customized medications for hospitals and healthcare facilities across the United States. We do this through unyielding quality, safety and integrity, our commitment to accountability and ownership, teamwork and creating better solutions by simplifying the complex.

Summary:

The Sr Data Engineer is responsible for design, development and support of data warehousing and data management environment supporting various business units. Provides mentorship and support to other junior team members and contract data engineers. 

Essential Functions:

• 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.

Requirements

Required Qualifications & Experience:

• Proven 8+ years of experience in data warehousing / data lake design, development & support with last 3 years in Snowflake and Azure Data Factory
• Strong expertise in Strong SQL and SQL query optimization skills
• Strong knowledge of data warehousing concepts, medallion architecture and best practices.
• Familiarity with Snowflake's architecture, features, and best practices.
• Experience with data modeling, ETL development, and data integration techniques.
• Experience with Azure Data Factory (ADF), Data Bricks and other Azure services.
• Knowledge of life sciences industry requirements, regulatory requirements, and data security protocols.
• Proficiency in Python & Snowpark for data processing and automation.
• Experience working with confluence, JIRA & Github
• Desired Knowledge, Skills, and Abilities:
• Experience with Pharmaceutical, Lifesciences and / or Manufacturing Industries.
• Familiarity with other data integration tools and BI platforms.
• Knowledge and Working experience of AI/ML  
• Relevant certifications such as Snowflake Snowpro Core Certification
• Goal oriented, with excellent time management and organizational skills
• Excellent verbal & written communication skills

SCA Pharma is an equal opportunity employer (Minorities/Females/Disabled/Veterans). We recruit, employ, train, compensate, and promote without regard to race, religion, creed, color, national origin, age, gender, sexual orientation, marital status, disability, veteran status, or any other basis protected by applicable federal, state or local law.