AWS Data Lakehouse Consultant

Dice
Dice Salary
Waterbury, VT Full Time
POSTED ON 5/19/2024
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Tri-Force Consulting Services Inc, is seeking the following. Apply via Dice today!

Title: AWS Data Lake Architect

Location: Waterbury Village Historic District, VT 05676

Client: The Vermont Department of Public Safety

Note: This is an onsite position day 1 onsite

Job Description :

  • The Vermont Department of Public Safety (DPS) is seeking to improve statewide law enforcement data access.
  • The purpose is to design and implement a state-controlled system to access de-identified, aggregated law enforcement and related data currently housed in a record management system.
  • DPS, in collaboration with the Vermont Agency of Digital (ADS) Services, is seeking to procure Amazon Web Service (AWS) professional services to work with the ADS Technical Lead to build out the Public Services Lake house environment.

Design and implement the Department of Public Safety Data Lake in the AWS

Environment

  • Store Data in AWS CJIS compliant environment.
  • Implement and design the lake house technologies with the IT Tech Lead assigned to the project.
  • Design and implement using latest AWS Lake House standards.
  • Data Security Layer
  • Implement and design security Identity and Access Management roles and processes.
  • Design and Create security IAM templates.
  • Data Ingestion Layer
  • Ingestion Design for variety of sources
  • Operational Database Sources
  • MySQL, SQL Server
  • SaaS Applications
  • File Shares (SharePoint and one drive)
  • Stream Data Sources
  • System Templates of ingestion processes Data Storage Layer
  • AWS S3 CJIS compliant S3 buckets
  • AWS Redshift Infrastructure
  • Power BI Connector process Data Processing Layer
  • Data Extract, Load and Transform (ELT) process for loading from source to S3 and Transforming data from S3 to Redshift for reporting and analytics.
  • Templates for creating ELT processes for future processes.

Data Catalog Layer

  • Design and implement solution to solve data schema drift in AWS Glue for use with reporting and analytical needs.
  • Design and build crawlers for schema and build catalog that stores schema information.
  • Meta data store in catalog for consumption in data warehouse
  • Create Catalog crawler templates for data sources

Professional Service Requirements

  • AWS Lake house Certification
  • AWS Design and Implementation Lake House Technologies
  • AWS IAM
  • AWS Lake house Technology
  • AWS Glue Knowledge
  • Data Catalog and Crawler
  • AWS Redshift
  • AWS Athena
  • CJIS certified data storage
  • AWS CJIS Data location
  • CJIS Security Background Check (See Additional Attachments / Assurances)

AWS Data Lakehouse Consultant

If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

Sign up to receive alerts about other jobs that are on the AWS Data Lakehouse Consultant career path.

Click the checkbox next to the jobs that you are interested in.

Income Estimation: 
$112,814 - $146,675
Income Estimation: 
$131,576 - $171,768
Income Estimation: 
$108,092 - $132,622
Income Estimation: 
$134,794 - $162,471
Income Estimation: 
$135,815 - $177,831
Income Estimation: 
$121,765 - $157,405
Income Estimation: 
$144,216 - $182,114

Sign up to receive alerts about other jobs with skills like those required for the AWS Data Lakehouse Consultant.

Click the checkbox next to the jobs that you are interested in.

  • Brand Management Skill

    • Income Estimation: $59,288 - $79,191
    • Income Estimation: $64,867 - $82,481
  • Branding Skill

    • Income Estimation: $58,192 - $76,453
    • Income Estimation: $62,649 - $86,924
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at Dice

Dice
Hired Organization Address Pierre, SD Full Time
Dice is the leading career destination for tech experts at every stage of their careers. Our client, TEKsystems c/o Alle...
Dice
Hired Organization Address Washington, DE Full Time
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Wizcom Corporation,...
Dice
Hired Organization Address Meridian, ID Full Time
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Object Technology S...
Dice
Hired Organization Address Meridian, ID Contractor
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Critical River, Inc...

Not the job you're looking for? Here are some other AWS Data Lakehouse Consultant jobs in the Waterbury, VT area that may be a better fit.

AWS Data Architect

Zortech Solutions, Montpelier, VT

AWS Data Lake Technical Lead

MY3TECH INC, Waterbury, VT