Senior Snowflake Data Warehouse Architect

Employvision Inc.; Parsippany-Troy Hills (NJ); On-site; USD 150,000 - 190,000; Full time

Job summary

Employvision Inc. in New Jersey is seeking an experienced data solutions architect/engineer to design and implement enterprise-scale data platforms, with Snowflake expertise.

You will optimize SQL performance, build data warehouses, and collaborate across teams using Airflow, Git, Jira, and Confluence. This role requires strong communication, problem solving, and a collaborative mindset, with in-person interviews in NJ.

Qualifications

• At least 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 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

Skills

SQL

Python

Snowflake

Data warehousing

Metadata & data lineage

Shell scripting

Java scripting

Git

Confluence

Jira

Communication skills

Team player

Problem solving

Tools

Airflow

Informatica

Automic

Azure Data Factory

Git

Confluence

Jira

Job description

Employvision Inc. in New Jersey is seeking an experienced data solutions architect/engineer to design and implement enterprise-scale data platforms, with Snowflake expertise.

You will optimize SQL performance, build data warehouses, and collaborate across teams using Airflow, Git, Jira, and Confluence. This role requires strong communication, problem solving, and a collaborative mindset, with in-person interviews in NJ.