Snowflake Consultant Job at GTN Technical Staffing, Tampa, FL

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

RHP Properties

New Home Project Manager Job at RHP Properties

 ...private owner and operator of manufactured home communities. With over 370 communities...  ...preferred; HS Diploma or GED required. Working knowledge of physical facilities, including...  ...include medical, dental and vision insurance; short-term and long-term disability; life... 

Asbury Communities, Inc.

Social Worker Job at Asbury Communities, Inc.

 ...professional relationships with staff, physicians, residents, families, community resources, and third-party payers. Completes Admission forms/assessments and documentation as outlined in the Social Service Admission Process. Completes a plan of care for each resident... 

Sika

Human Resources Manager Job at Sika

With more than 100 years of experience, Sika is a worldwide innovation and sustainability leader in the development and production of systems and products for commercial and residential construction, as well as the transportation, marine, automotive, and renewable ...

The Lane Construction Corporation

Information Technology Security Manager Job at The Lane Construction Corporation

 ...adaptation challenges. Responsibilities Develops and enforces security policies, procedures, and protocols to safeguard digital...  ...s Degree Employment Conditions: ~5 years of experience in IT security ~ Professional certification such as CISSP, CISM... 

The Planet Group

Senior Project Controls Specialist Job at The Planet Group

 ...Excellent interpersonal skills Proficient with Microsoft Office OSHA 10-hour safety certification - ability to obtain Senior...  ...implement, and maintain effective scheduling reports, cost reports, cash flows and forecasts for multiple projects Follow project...