Snowflake Data Engineer/Business Analyst_Independent Consultants only_W2

Job Description

Job Title: Snowflake Data Engineer/Business Analyst
Location: Niskayuna, NY – 5 days onsite
Type: Contract

Responsibilities:
•    Work with the business to understand functional requirements and transform into technical solutions within Snowflake
•    Lead Project for the Enterprise Reporting & Analytics team to build out reports for the business leveraging data from various sources
•    Work within a project management methodology
•    Must be comfortable talking and engaging with the business teams to understand their current as is and to be processes

Technical Requirements:
•    Candidates should have at least 8-10 years of experience in data engineering / data warehousing
•    Must be both strong in understanding business processes and able to work technically within Snowflake
•    Experience working with data within the manufacturing industry (Manufacturing, supply chain, finance, procurement, etc.)
•    SQL & SnowSQL: Expertise in writing, optimizing, and troubleshooting SQL queries in Snowflake.
•    Stored Procedures & UDFs: Experience in developing and maintaining stored procedures and user-defined functions (UDFs).
•    ELT Development: Ability to design and implement ELT pipelines using Tasks, Streams, Dynamic Tables, Views, and other table types in Snowflake or external tools.
•    Data Modeling: Proficiency in dimensional modeling (Star, Snowflake, etc.), SCD types, and Snowflake best practices.
•    Security & Access Control: Knowledge of Snowflake roles, privileges, and Role-Based Access Control (RBAC).
•    API & External Connectivity: Experience integrating Snowflake with various data sources and third-party tools.
•    Scripting & Automation: Proficiency in Python, Java, or JavaScript for automation and orchestration.
•    Integration & Orchestration: Experience with tools such as Alteryx, DBT, Airflow, Kafka, Talend, or Informatica.

Extra (Not required, but nice to have)
•    Knowledge with building reports from SAP Data
•    Tableau Development

Additional Information

 All your information will be kept confidential according to EEO guidelines.