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

VklsUDI5NzltdWppSDVhR3o3V1JGQWlMamc9PQ==
  • 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

WinTrio LLC

Sr. ServiceNow Developer Job at WinTrio LLC

Location: Hybrid (Washington DC and Remote)US Citizenship is required for this role.We are seeking a highly skilled ServiceNow Developer with extensive experience in IT Service Management (ITSM) and the ServiceNow suite of products.Please see the job description below... 

Kane Transport

CDL-A Local Fuel & Ethanol Tanker Truck Driver - PM Shift Job at Kane Transport

*CDL-A Local PM Fuel & Ethanol Tanker Position*_Forest Lake, MN_*Rewarding Career Starts...  ...only) savings of $7,000 annually** Driver referral bonus *Details** Local runs...  ...* Paid time off * Vision insurance Trucking Driver Type: * Company driver... 

Creative Cove Inc.

Copywriter Job at Creative Cove Inc.

Job Description Our Boston based client is looking for a Copywriter with previous experience writing for high end real estate, luxury goods or fashion. You'll be working marketing collateral, B2B presenations and emails for a variety of high end locations for this client...

Supplemental Health Care

LPN / LVN - School Nurse - $48 per hour - Urgently Hiring Job at Supplemental Health Care

 ...it. Round the clock support. No matter where you are or what time it is, Supplemental Health Care is standing by. Our Share the...  ...SHC offers a 401k Retirement Savings Program to both full-time and part-time employees with a wide range of investment options. Discounted... 

Warner Bros. Discovery

CNN London News Internships (Sept 2025) Job at Warner Bros. Discovery

 ...benefits, and the tools to explore and grow into your best selves. Here you are supported, here you are celebrated, here you can thrive.**CNN Internship Programme...**As one of the world's news leaders we are interested in creative and energetic people with diverse...