Snowflake Consultant Job at GTN Technical Staffing, Tampa, FL

RnBkanBWY2lYMjNaSlVuUFo4RFdCR1J0Znc9PQ==
  • 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

Wellbox

Virtual Medical Assistant Job at Wellbox

 ...preventative care solutions. Our mission is to improve population health outcomes one patient at a time. We seek a tech-savvy Medical Assistant to join our dynamic team and contribute to our patient care excellence. Position Summary : As a Medical Assistant, you'... 

JPMorgan Chase & Co.

Investment Banking - Leveraged Finance - Associate Job at JPMorgan Chase & Co.

 ...client. As an Associate in Leveraged Finance, you will work with experienced professionals at one of the world's leading global investment banks. You will focus on analyzing and identifying optimal and marketable capital structure solutions for the client. You will be... 

NS IT Solutions

Scrum Master Job at NS IT Solutions

 ...Job Title: Scrum Master Location: Boston, MA Work Type: Onsite Duration: 06 Months of Contract LinkedIn Profile: Required for Submission NOTE: NO H1B // Local Candidates with DL Primary Skills: Scrum Master; Agile Methodologies; Scrum; Kanban; Agile... 

Gpac

Intermodal Drayage and Rail Sales Job at Gpac

 ...If you're ready to take your freight sales career to the next level, we'd love to talk. Send your resume confidentially to: Katrina Cox All qualified applicants will receive consideration without regard to race, age, color, sex (including pregnancy), religion,... 

Datwyler

3rd Shift - Production Operator Job at Datwyler

 ...Conduct.#Regular attendance and punctuality required in order to meet production needs of customers. Willingness to work in shifts (late or early hours, weekends, and overtime if necessary#Demonstrates a strong commitment to quality. Works conscientiously...