What are the responsibilities and job description for the Snowflake AI Specialist Consultant position at Econosoft?
Job Details
Title: Snowflake AI Specialist Consultant
Contract Details:
Location: Folsom, NJ
Hybrid - 3 days onsite
NOTE: The Snowflake / AI Specialist role is technical and coding-focused, involving AI/ML model development, managing large datasets, and integrating data for insights. Expertise in Snowflake, AI Cortex, advanced SQL, and AI technologies is required
"The candidate must be able to demonstrate the practical skills needed to independently to solve real-world
AI problems"
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
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
