Snowflake AI Specialist Consultant

Job Summary
Will provide the opportunity to design, develop, test, deploy, and monitor standardized or ad hoc reports, dashboards, or data requests. Additionally, this role develops and maintains (Artificial Intelligence/Machine Learning- AI/ML) models and routines for end-user access for analytical purposes. The role involves working with our databases, data warehouses, queries, and scripts, and reporting information for end-users. Analysts also integrate data from multiple sources to produce requested or required data elements, metrics, Key Performance Indicators -KPIs, reports, or visualizations.
The Snowflake AI Specialist will own development standards and be responsible for the quality of all routines developed for the Datawarehouse. This role will also own data engineering operations, troubleshooting data-related issues using SQL and other Integration monitoring tools, and main data-related documentation. Additionally, this role will create requirements and specifications for AI used cases based on business request. This is an individual-contributor role with high visibility that will also require production support and maintenance.
Requirements

3-5 years of experience in data engineering with a significant focus on Snowflake
3-5 years of expertise with complex SQL
3-5 years of expertise in Stored procedures using Javascript or Python
Python preferred
3-5 years experience supporting AI initiatives in a data engineering or data scientist role
Proficiency in Pandas, Pyspark, Snowpark ML
Knowledge of Snowflake Cortex Large Language Model (LLM) functions and statistical modeling
Nvidia and any other AI experience like Microsoft, OpenAI and Alphabet AI
Proficient with configuration of REST/SOAP API’s and parsing of XML/JSON data
Strong ability to carry out assigned tasks independently with little supervision.
Extensive experience with data warehousing concepts, performance optimization
Extensive experience in Extract Transform and load ( ETL/ELT) tools ,IICS platform is a plus
Proactive with a Can-do attitude and willingness to learn new technologies

Responsibilities

Build and maintain data pipelines using Informatica Intelligent Cloud Services –( IICS )/Snowflake
Integrate various sources into Snowflake for model, validation and deployment
Support deployment and monitoring of AI/ML models in production
Implement best practices for utilization of cortex and other snowflake functions
Partner with Users and Analysts to complete functional specifications and translate the same to technical specifications for development work
Maintain documentation for all routines developed

Job Type: Contract
Pay: $50.00 - $60.00 per hour
Schedule:

Monday to Friday

Ability to Commute:

1 South Jersey Plaza ,Folsom, NJ 08037 (Required)

Ability to Relocate:

1 South Jersey Plaza ,Folsom, NJ 08037: Relocate before starting work (Required)

Work Location: Hybrid remote in 1 South Jersey Plaza ,Folsom, NJ 08037