SCA Pharma
SCA is the most customer and patient centric service provider in the 503B industry.
Senior Data Engineer
Location
United States
Posted
153 days ago
Salary
Not specified
Bachelor Degree8 yrs expEnglishAzureETLPythonSQL
Job Description
• 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.
Job 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
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
Data Engineer153 days ago
Full TimeRemoteTeam 51-200Since 2019H1B Sponsor
Seeking a Data Engineer with FHIR expertise for healthcare AI assistant development
Cloud
United States
Data Engineer – HealthTech
AssistRxSpecialty therapy initiation and patient support company delivering informed access and improved outcomes.
Data Engineer154 days ago
Full TimeRemoteTeam 501-1,000Since 2011H1B Sponsor
Data Engineer building data pipelines for healthcare technology company
ApacheAzureBigQueryCloudCognosETLHadoopInformaticaJavaLinuxMapReducePythonSparkSQLTableau
United States
Data Engineer155 days ago
Full TimeRemoteTeam 10,001+Since 1888H1B Sponsor
Staff Data Engineer leading cloud-based big data engineering efforts at Abbott
Amazon RedshiftAWSCloudKafkaPySparkPythonSparkGo
Data Engineer156 days ago
Full TimeRemoteTeam 201-500Since 2001H1B No Sponsor
Senior Data Engineer optimizing data infrastructure for marketing technology.
AirflowAmazon RedshiftAWSAzureBigQueryCloudPythonSQL