Lead Consultant | Analytics - Packages | Python - Big Data

IMCS Group Inc

🇺🇸 United States

On-site

Staff / Principal

1 week ago

Python
Cortex
AI
Snowflake
MCP
PySpark
Azure
ETL
SQL
CI/CD
RBAC

1 week ago

Auto apply with Likeremote

Not scoredNo CV on file. Upload one and this job gets a score out of 100.Upload CV

Company Description: IMCS Group is one of the fastest growing MWBE (Minority Woman Owned Enterprise) staffing firms in the U.S. We focus on bringing a Diversity Recruitment approach to Fortune 500 companies within North America and EMEA region contingent labor programs. IMCS Group excels in providing top talent in IT, Healthcare, Engineering, Finance, Light Industrial, Contact Center, and Clerical. We have offices in the US, Canada, Mexico, and India in which we can provide support to our clients.

Description: Job Title: Lead Consultant | Analytics - Packages | Python - Big Data
Work Location: New YorkNY10004(Prefer local candidate due to drop experience from past)
Vendor Rate: ***
Contract duration: 12
Target Start Date: 28 Sep 2026
Does this position require Visa independent candidates only? Yes
**Hybrid (3 days in a week from client office)**

Job Details:

Must Have Skills
Cortex AI, Agentic AI, Snowflake, Gen AI, MCP, PySpark

Nice to have skills:
Azure

Detailed Job Description
Design and build the Cortex Skills library, agent capabilities, skill packages, and reusable tools
Good hands-on experience working in Python, Spark ETL projects
Build the AI query engine on Cortex Analyst: map business questions to certified semantic views, generate governed SQL
Partner with the Semantic Modelling Lead so agents bind to certified semantic views rather than raw tables
Integrate AI agents with enterprise systems, APIs, databases, knowledge repositories, CI/CD pipelines, and event-driven architectures to create end-to-end intelligent automation frameworks.
Set engineering standards for the pod — prompt versioning, skill packaging, code review, CI/CD for AI assets
Present agent design and demos to client stakeholders at sprint reviews and milestone gates
Good to have: Financial services domain exposure, especially General Ledger, revenue reporting or spend analytics. Understanding of Knowledge graph, ontology concepts
Required Skill/Expertise

Snowflake and Cortex

Hands-on Snowflake Cortex: Cortex Analyst, Cortex Search, Cortex Agents, COCO, semantic views
Strong Python, SQL and Snowflake platform depth — dynamic tables, RBAC, masking policies, warehouse performance, and cost tuning
Understanding of how semantic layers constrain and ground LLM query generation

Minimum years of experience
>10 years

Certifications Needed :No

Top 3 responsibilities you would expect the Subcon to shoulder and execute
Coding
Testing
Deployment

Interview Process (Is face to face required?)
No

Any additional information you would like to share about the project specs/ nature of work

Custom Fields:
Name: Intake Call Completed
Value: false

Name: Intake Call Requested
Value: true

EEOC Disclaimer: IMCS Group is an equal opportunity employer and makes employment decisions without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, disability status, age, or any other status protected by law. IMCS Group is committed to maintaining an inclusive workforce, where employees are hired, retained, compensated, and promoted based on their contributions to our Company.

Lead Consultant | Analytics - Packages | Python - Big Data · IMCS Group Inc

Auto apply with Likeremote