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

GeoTec, Inc.

Assembler Job at GeoTec, Inc.

 ...The Company: GeoTec, Inc. has been a player in the medical device industry for 42 years, specializing in the assembly of surgical instruments. We bring both experience, ingenuity, and the utmost quality, Geotec has maintained a high level of success and growth for... 

Independence Pet Holdings

FT Customer Service Representative - Work From Home Job at Independence Pet Holdings

 ...positive customer experience; Follow company policies and procedures to maintain high standards of service; Provide product knowledge and make recommendations to customers; Maintain a positive and professional attitude towards customers and colleagues...Hiring Immediately... 

Shore Outpatient Surgicenter (10906)

Sterile Processing Tech Job at Shore Outpatient Surgicenter (10906)

 ...Shore Outpatient Surgicenter is hiring a Sterile Processing Tech Welcome to Shore Outpatient Surgicenter At Shore Outpatient...  ...Equivalent Minimum of 1-2 years of Sterile Processing experience Completion of a Sterile Process Certification program is... 

Tristar Health

Careers with HCA Job at Tristar Health

 ...Are you a dedicated Imaging or Nursing student at Casa Loma College ready to launch your career with a leading healthcare provider? HCA Healthcare's TriStar Health system is looking for talented individuals like you to join our team across our nine Middle Tennessee... 

Senior Helpers

Live in Caregiver Job at Senior Helpers

 ...LIVE-IN CAREGIVER Caregiver will have private bedroom Senior Helpers is proud to be the first and only national in-home care provider to receive certification as a Great Place to Work. Our caregivers and staff are treated with respect in an inclusive environment...