Overview
Remote
$55
Contract - W2
Contract - 3m
Skills
SQL
Snowflake
Pharm
Job Details
Sr. Snowflake Engineer - SQL - REMOTE WORK - 66788
Pay Range - $50 - $55/hr
One of our clients is looking for a Sr. Snowflake Engineer - SQL to join their team remotely.
MUST HAVES:
1. SQL Server background (exposure to adv. coding environment) Transact-SQL (T-SQL)
2. Snowflake SQL exp.
3. Pharm background (drugs, insurance, how pharm business is conducted)
Description:
PROJECT DETAILS (Size, Scale, Scope):
- What is the scope of work that is being completed?
- Middle of migration from SQL Server to Snowflake. All the work expands the entire breadth of the business. More familiar with pharm business, the better.
- What part of the project is this resource supporting?
- Day to day responsibilities
- Focus on writing Snowflake queries inside of Snowflake (SnowSQL) and stored procedures. Fair bit of SP writing in MS SQL Server as well. Structure creation of flat tables, series of SPs, each structure migrated is the same mechanism, transform data, and then will use JavaScript wrapped to execute in SQL. Will help with process control (when and where). Will also create tables in SQL Server. Not a lot of complex joins, permissions in SQL Server.
- Really need to know their way around Snowflake as there will be a fair amount of troubleshooting.
- Given the tight turnaround, this resource will need to be comfortable hitting the ground running and stepping into a high pressure environment where demands to complete tasks will be high.
NICE TO HAVES (OR WHAT GETS THE WIN):
1. JavaScript
2. AWS (s3 buckets to store files-represents and functional capabilities), it's a share drive
For immediate consideration:
Vishal
PRIMUS Global Services
Direct
Desk: Ext. 423
Email:
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.