Data Engineer

Apexon; Parsippany-Troy Hills (NJ); On-site; USD 120,000 - 180,000; Full time

Job summary

Apexon in Parsippany-Troy Hills, NJ seeks an Experienced Data Management Specialist to design, develop, and govern enterprise data solutions using Snowflake. You will partner with engineering teams to plan requirements, implement robust data pipelines, and ensure performance and scalability.

Responsibilities include troubleshooting, documenting root causes, and ensuring data quality. Strong SQL/Python skills and expertise in data warehouses and metadata lineage are required.

Qualifications

• At least 8 years of experience designing and development of data solutions in enterprise environments.
• At least 5+ years of 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.
• Knowledge of metadata and data lineage.
• Hands-on knowledge of SQL analytical functions.
• Strong knowledge of shell scripting and Java scripting.
• Proficient with Git, Confluence and Jira.
• Strong problem solving and communication skills.

Responsibilities

• Design and develop Snowflake data warehouses and data models.
• Build and maintain robust data pipelines using Snowflake and Azure Data Factory.
• Tune and optimize SQL queries for performance and scalability.
• Collaborate with engineering teams to deliver reliable data solutions.

Skills

SQL

Python

Snowflake

Data warehousing

ETL orchestration

Metadata & lineage

Data analysis

Shell scripting

Git

Confluence

Jira

Tools

Airflow

Informatica

Automic

Azure Data Factory

Git

Confluence

Jira

Shell scripting

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