Snowflake Consultant Job at GTN Technical Staffing, Tampa, FL

UmtHVEZZc1hheGdlU0p5VUpBMHBPMnJGZ2c9PQ==
  • GTN Technical Staffing
  • Tampa, FL

Job Description

Snowflake Consultant

Tampa, Florida

Contract to Hire

What we are looking for are technical experts that can validate/tweak our initial design decisions and then help us to initiate the implementations. Below are some key areas we are looking for assistance. While these are the specific items we are looking at right now, I can see additional items materializing but they will most likely be related.

 

Snowflake:

  • We are doing a medallion implementation to have an integrated and an analytic performant representation of the data. We want a Dev, Stage and Prod environment along with a bronze, silver, and gold in each environment.
  • In our POC we used SQL notebooks and stages to pull in and transform data from an ADLS2 storage account.
    • Full table pull and swapped transient tables.
    • We are considering snowpipe but are concerned about the full pull approach and CDC is not an option right now.
    • We would like to incorporate dbt in our pipelines
    • For reference Openflow is not available in the Gov Cloud today.
    • Developing templates for engineers to cut paste and minimize coding when creating new pipelines.
  • With respect to dbt:
    • Transformations
    • Code testing
    • Github integration and progression to production
  • We need assistance on setting up best approach to PII and Financial data i.e., segregate vs mask.
  • Roles and Grants, is our strategy sound in these areas. 

 

Power BI Premium

 

  • Complete setup and management of environment
  • Managing/segregating Dev, Stage, & Prod
  • Model management with respect to refresh
  • Privileges, Access and permissions
  • Any other things we should have in place before going live

Job Tags

Contract work,

Similar Jobs

Texas Health Resources

Interventional Radiology Technologist Job at Texas Health Resources

 ...Technologist - Interventional Radiology Bring your passion to Texas Health so we are Better + Together *** Sign-on Bonus (Eligible New...  ...care team members include a registered nurse, a scrub (Rad Tech or RN), physician assistant if needed, as well as the physicians... 

luckyscent

Graphic Designer Job at luckyscent

 ...re building a killer email campaign, the next youre slicing a video for TikTok, and by Friday youre laying out designs for print collateral...  ...that feels elevated, modern, and fun Video & Motion Edit fast, clean, brand-forward videos using CapCut, Premiere, or... 

Cummins Inc.

Human Resources Summer Internship Positions Job at Cummins Inc.

 ...resolution. Support deployment and effectiveness of a broad range of HR processes, programs and initiatives within designated geography...  ...s qualifications and experience, where appropriate. Internship program criteria: Must be a full-time enrolled student pursuing... 

Intercare Therapy

Behavior Technician Job at Intercare Therapy

 ...time and mileage reimbursement (Federal rate) Learn Applied Behavior Analysis (ABA) Work variable hours per week Part-time,...  ...Professionals, Behavioral and Social Sciences, Behavioral Health Technician, Babysitting, Mental Health Specialist, Camp Counselor, Coach,... 

Bethel University of Tennessee

Associate Creative Director of Renaissance Job at Bethel University of Tennessee

 ...Associate Creative Director of Renaissance Join to apply for the Associate Creative Director of Renaissance role at Bethel University of Tennessee Position Overview Reports to: Executive Director of Renaissance Purpose: Lead and develop students musically...