Artificial Intelligence Specialist (AI Specialist)

Macpower Digital Assets Edge Private Limited

Folsom, NJ

JOB DETAILS
SALARY
$60–$65 Per Hour
SKILLS
Advertising Monitoring, Analysis Skills, Application Programming Interface (API), Artificial Intelligence (AI), Best Practices, Business Intelligence, Cloud Computing, Data Analysis, Data Management, Data Science, Data Warehousing, Database Extract Transform and Load (ETL), Documentation, Engineering Management, Financial Reporting, Functional Analysis, Identify Issues, Informatica, JSON, JavaScript, Machine Learning, Model Validation, Modeling Languages, Operations Management, Performance Metrics, Performance Tuning/Optimization, Python Programming/Scripting Language, REST (Representational State Transfer), Reporting Dashboards, Requirements Management, SOAP (Simple Object Access Protocol), SQL (Structured Query Language), Scripting (Scripting Languages), Snowflake Schema, Statistical Modeling, Stored Procedures, Test Plan/Schedule, XML (EXtensible Markup Language)
LOCATION
Folsom, NJ
POSTED
9 days ago
Job Summary:
  • A career in Data & Analytics will provide the opportunity to design, develop, test, deploy, and monitor standardized or ad hoc reports, dashboards, or data requests. Additionally, this role involves developing and maintaining Artificial Intelligence/Machine Learning (AI/ML) models and routines for end-user access for analytical purposes.
  • The role includes working with databases, data warehouses, queries, 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 Business Intelligence Analyst III will own development standards and be responsible for the quality of all routines developed for the data warehouse. This role will also manage data engineering operations, troubleshooting data-related issues using SQL and other integration tools.
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.
  • 3-5 years of 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 APIs and parsing of XML/JSON data.
  • Strong ability to carry out assigned tasks independently with little supervision.
  • Extensive experience with data warehousing concepts and 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) and 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 the utilization of Cortex and other Snowflake functions.
  • Partner with users and analysts to complete functional specifications and translate them into technical specifications for development work.
  • Maintain documentation for all routines developed.

About the Company

M

Macpower Digital Assets Edge Private Limited