SCA Pharma

Senior Data Engineer

SCA Pharma

full-time

Posted on:

Location Type: Remote

Location: Remote • 🇺🇸 United States

Visit company website
AI Apply
Apply

Job Level

Senior

Tech Stack

AzureETLPythonSQL

About the role

  • 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

  • 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
  • Relevant certifications such as Snowflake Snowpro Core Certification
  • Goal oriented, with excellent time management and organizational skills
  • Excellent verbal & written communication skills
Benefits
  • N/A 📊 Resume Score Upload your resume to see if it passes auto-rejection tools used by recruiters Check Resume Score

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
SQLSnowflakeAzure Data Factorydata warehousingdata lake designdata modelingETL developmentPythonSnowparkdata integration
Soft skills
goal orientedtime managementorganizational skillsverbal communicationwritten communication
Certifications
Snowflake Snowpro Core Certification
Serve Robotics

Senior Data Engineer, ML Infrastructure

Serve Robotics
Seniorfull-time$185k–$235k / year🇺🇸 United States
Posted: 1 hour agoSource: jobs.ashbyhq.com
CloudETLGoogle Cloud PlatformPythonSQL
DAS42

Data Engineer – Client-Facing

DAS42
Mid · Seniorfull-time$95k–$130k / year🇺🇸 United States
Posted: 3 hours agoSource: boards.greenhouse.io
Amazon RedshiftAWSBigQueryCloudETLPerlPythonSQLTableau
3Cloud

Senior Consultant – Data Engineering

3Cloud
Seniorfull-time$108k–$157k / year🇺🇸 United States
Posted: 3 hours agoSource: boards.greenhouse.io
AzureETLPythonSQLSSIS
CareSource

Data Engineer II

CareSource
Mid · Seniorfull-time$71k–$113k / year🇺🇸 United States
Posted: 5 hours agoSource: caresource.wd1.myworkdayjobs.com
AzureETLPySparkPythonSQL