Senior Data Engineer Job at SCA Pharmaceuticals, LLC, Little Rock, AR

dGFJUmVlR0gvUVE1UFhmblUyTmUvMEFmOXc9PQ==
  • SCA Pharmaceuticals, LLC
  • Little Rock, AR

Job Description

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:

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

Job Tags

Contract work, Work experience placement, Local area,

Similar Jobs

Domino's

Delivery Driver (04216) - $12.50/hr + Cash Tips Daily + Mileage - Evening & Closing Shift Job at Domino's

Job Description Job Description Qualifications Additional Information PandoLogic. Keywords: Pick Up and Delivery Driver, Location: Virginia Beach, VA - 23454

Willson International Limited

Post Entry Specialist Job at Willson International Limited

 ...Willson International is the place for you. Location: 4 Days fully remote, 1 day in NY office. Hours: Monday to Friday, 9am-5pm Description of Role: The Post Entry Specialist is a subject matter expert responsible for managing and resolving post-entry... 

PNC Financial Services Group

Senior Strategic Sourcing Specialist Job at PNC Financial Services Group

 ...contribute to the companys success. As a Senior Strategic Sourcing Specialist within PNC's Supply Chain Management organization, you will be...  ...opportunity to qualified persons regardless of race, color, sex, religion, national origin, age, sexual orientation, gender... 

VitalConnect

Salesforce Administrator Job at VitalConnect

Join to apply for the Salesforce Administrator role at VitalConnect .Get AI-powered advice on this job and more exclusive features.Purpose We are seeking an experienced Salesforce Administrator to manage and support our Salesforce environment. The ideal candidate will... 

Peregrine Senior Living

Housekeeper Job at Peregrine Senior Living

We are currently seeking an energetic and detail-oriented HousekeeperSchedule: Full Time (7:00am - 3:00pm) with alternating weekends...  ...in a similar environment such as a senior living community, nursing home or any healthcare field preferredAble to operate cleaning equipment...