Snowflake Consultant Job at GTN Technical Staffing, Tampa, FL

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

Two95 International Inc.

DataStage Developer Job at Two95 International Inc.

 ...ESSENTIALS: 1.Possess a broad range of knowledge in support of multiple custom built applications with strong background in IBM Infosphere DataStage, SQL, SQL Performance Tuning 2.Technical Skills including the following: -Experience in upgrading from Datastage... 

Brightstar Lottery

Data & Insights Intern Job at Brightstar Lottery

 ...Brightstar is an innovative, forward-thinking global leader in lottery that builds on our renowned expertise in delivering secure technology and producing reliable, comprehensive solutions for our customers. As a premier pure play global lottery company, our best-in-class... 

Cabela's

Archery Tech - Full Time Job at Cabela's

 ...world class customer service and ensures a pleasant and productive shopping experience for all customers. Troubleshoots, diagnoses, and...  ...Savings Paid holidays Paid vacation Paid sick time Bass Pro Cares Fund And more! Bass Pro Shops is an equal... 

Cencora

Business Coach Job at Cencora

 ...business strategies. Offer specialized consultation to other business coaching team members and their clients as needed, including ad hoc...  ...processes to drive profitability. Client Interaction: Execute complex processes and engage in client-facing situations by identifying... 

Sterling Physician Recruiters

Pulmonary / Critical Care Physician Job at Sterling Physician Recruiters

 ...Pulmonary/Critical Care Physician Non-profit regional health system with multiple hospitals and more than 1200 providers. 775 bed critical access facility with a Level 11 Trauma.10 bed critical care unit (soon expanding). Safe neighborhoods, lower cost of living,...