Data Engineer

Planet Pharma; Pennsylvania; Hybrid; USD 90,000 - 116,000; Full time

Job summary

Planet Pharma seeks an experienced Data Engineer to design, build, and optimize data solutions and pipelines across Snowflake platforms. You will collaborate with engineering to ensure performance, scale, and high-quality code.

The role requires strong SQL and Python, expertise in data warehouses, and hands-on orchestration with Airflow, Informatica, or Automic. Excellent problem solving and communication skills are essential.

Qualifications

• 8+ years of experience designing and developing data solutions in an enterprise environment.
• 5+ years’ experience working on Snowflake Platform.
• Strong hands-on SQL and Python development.
• Experience with designing and development data warehouses in Snowflake.
• Ability to diagnose and tune SQL queries - Azure Data Factory knowledge is needed.
• Hands on experience with Orchestration Tools e.g. Airflow, Informatica, Automic.
• Good understanding on Metadata and data lineage.
• Hands on knowledge on SQL Analytical functions.
• Strong knowledge and hands on experience in Shell scripting, Java Scripting.
• Good understanding and exposure to Git, Confluence and Jira.
• Good problem solving and troubleshooting skills.
• Team player, collaborative approach and excellent communication skills.

Responsibilities

• Experienced Data management specialist responsible for developing, overseeing, organizing, storing, and analyzing data and data systems.
• Participate in all aspects of the software development lifecycle for Snowflake solutions, including planning, requirements, development, testing, and quality assurance.
• Work in tandem with our engineering team to identify and implement the most optimal solutions.
• Ensure platform performance, uptime, and scale, maintaining high standards for code quality and thoughtful design.
• Troubleshoot incidents, identify root causes, fix and document problems, and implement preventive measures.
• Able to manage deliverables in fast paced environments.
• Experience with Pharma domain and Omni-channel data is a plus.

Skills

SQL

Python

Shell scripting

JavaScript

SQL analytical functions

Problem solving

Communication

Team player

Tools

Snowflake

Azure Data Factory

Airflow

Informatica

Automic

Git

Confluence

Jira

Job description

Data Engineer

Job Description

• Experienced Data management specialist responsible for developing, overseeing, organizing, storing, and analyzing data and data systems
• Participate in all aspects of the software development lifecycle for Snowflake solutions, including planning, requirements, development, testing, and quality assurance
• Work in tandem with our engineering team to identify and implement the most optimal solutions
• Ensure platform performance, uptime, and scale, maintaining high standards for code quality and thoughtful design
• Troubleshoot incidents, identify root causes, fix and document problems, and implement preventive measures
• Able to manage deliverables in fast paced environments
• Experience with Pharma domain and Omni-channel data is a plus.

Required Skills and Experience

• At least 8 years of experience designing and development of data solutions in enterprise environment
• At least 5+ years’ experience working on Snowflake Platform
• Strong hands on SQL and Python development
• Experience with designing and development data warehouses in Snowflake
• Ability to diagnose and tune SQL queries - Azure Data Framework (azure data factory, etc.) knowledge is needed
• Strong hands on experience with Orchestration Tools e.g. Airflow, Informatica, Automic
• Good understanding on Metadata and data lineage
• Hands on knowledge on SQL Analytical functions
• Strong knowledge and hands on experience in Shell scripting, Java Scripting
• Good understanding and exposure to Git, Confluence and Jira
• Good problem solving and troubleshooting skills.
• Team player, collaborative approach and excellent communication skills

Pay Rate Range: $65-84/hr depending on experience