Senior Data Engineer

Job Description

Job Description

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 :

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.