This job has closed.

KPG99 INC · 3 days ago

Lead Datawarehouse Engineer (Snowflake / AI Agent)

Orlando, FL

Contract

Hybrid

Lead/Staff

KPG99 INC is seeking a Lead Datawarehouse Engineer specializing in Snowflake and AI Agent development. The role involves building and scaling AI agents on Snowflake's platform, leveraging a common data model for research and enhancing data warehousing capabilities.

ConsultingSalesStaffing Agency

H1B Sponsor Likely

Hiring Manager

Ankit Chauhan

Responsibilities

The AI agent is built on Snowflake Cortex/Intelligence and leverages ChatGPT

It’s built on top of a common data model for research, and the work involves expanding and scaling that foundation

Candidates with any prior AI agent–build experience will be able to scale up quickly to Snowflake’s environment

Working knowledge of ETL, ELT and other query tools and methodologies including but not limited to tools like Informatica, Toad, SSIS, Azure Data Factory, Impala and D-Beaver

Knowledge of and experience with cloud computing options and implementations including but not limited to Microsoft Azure and Snowflake environments

Intermediate database development knowledge including performance tuning in Oracle, Big Data, SQL Server, and Cloud (Azure & Snowflake) environments

Experience using databases in a business environment with large-scale, complex datasets

Understanding of database design concepts and techniques for OLAP versus OLTP

Knowledge of and experience with data, data flows, data warehousing, data curation and data governance concepts, techniques, and best practices

Understanding of entity relationship diagrams and resulting physical database objects

Strong analytical and problem-solving skills with ability to clearly articulate solution alternatives

Ability to work on multiple projects and tasks

Experience following the systems development life cycle (SDLC)

Knowledge of relational data structures, theories, principles, and practices

Desire and aptitude to learn new tools

Familiarity with EMR data models

Exceptional interpersonal skills and a team player

Excellent written and verbal communication skills

Ability provide guidance to peers

Qualification

SnowflakeAzure Data FactoryPythonSQLAI/Agent Build ExperienceETL/ELT methodologiesCloud computingDatabase developmentData warehousingAnalytical skillsProblem-solving skillsInterpersonal skillsCommunication skillsTeam player

Required

Azure Data Factory

Snowflake

Python

SQL

AI/Agent Build Experience