Snowflake Data Engineer (Remote)
About the Role:
We are seeking an experienced Data Management Specialist to design, develop, manage, and optimize enterprise data solutions using Snowflake. The role involves working across the software development lifecycle, including planning, requirements gathering, development, testing, and quality assurance, while collaborating closely with the engineering team to identify and implement effective technical solutions. The selected candidate will be responsible for developing Snowflake data warehouses, optimizing SQL queries, maintaining platform performance and scalability, and troubleshooting data-related issues. The ideal candidate will bring strong hands-on experience with Snowflake, SQL, Python, Azure Data Factory, and data orchestration tools, along with the ability to manage deliverables in a fast-paced environment.
Key Responsibilities:
Develop, oversee, organize, store, and analyze data and data systems.
Participate in all stages of the software development lifecycle for Snowflake solutions, including planning, requirements, development, testing, and quality assurance.
Collaborate with the engineering team to identify and implement optimal data solutions.
Design and develop enterprise data warehouses using Snowflake.
Maintain platform performance, uptime, and scalability while ensuring high standards of code quality and technical design.
Diagnose and optimize SQL queries to improve performance.
Troubleshoot incidents, identify root causes, resolve and document problems, and implement preventive measures.
Manage project deliverables effectively in a fast-paced environment.
Work with data metadata and lineage to support data management requirements.
Required Qualifications:
At least 8 years of experience designing and developing data solutions in enterprise environments.
At least 5 years of hands-on experience with the Snowflake platform.
Strong hands-on SQL and Python development skills.
Experience designing and developing data warehouses in Snowflake.
Ability to diagnose, troubleshoot, and tune SQL queries.
Knowledge of Azure Data Framework, including Azure Data Factory.
Hands-on experience with orchestration tools such as Airflow, Informatica, and Atomic.
Good understanding of metadata and data lineage.
Hands-on knowledge of SQL analytical functions.
Strong knowledge and practical experience with shell scripting and JavaScript.
Good understanding of and exposure to Git, Confluence, and Jira.
Strong problem-solving and troubleshooting skills.
Collaborative approach and ability to work effectively as part of a team.
Excellent communication skills.
Preferred Qualifications:
Experience in the pharmaceutical domain.
Experience working with omnichannel data.
Work Location and Arrangement
Work Arrangement:
Fully remote. Preferred Location: East Coast candidates, ideally those located near Parsippany, NJ.In-Person Team Meetings: The team meets at its Parsippany office once every 3–6 months.
Travel:
Candidates must be willing to travel to the Parsippany office for team meetings. Travel expenses are covered by the resource.
Interview Process:
Two rounds of interviews. The second interview round will take place in person at the Parsippany office.
Additional Candidate Requirement: Candidates must have an established LinkedIn profile dating back to before 2020.