Sr AWS Consultant

2 weeks ago

Montpelier, United States Novalink Solutions Full time
Job Description
The Vermont Department of Public Safety currently uses a Computer Aided Dispatch Records Management System (CAD RMS) system that is currently running in a MySQL instance that will be used in the first phase of the Data Lake build. The supplemental data ranges from SQL server instances and flat file sources that are currently housed internally either in SharePoint or internal file stores(12+ years)

REQUIREMENTS:
• Design and implement the Department of Public Safety Data Lake in the AWS Environment

  1. Store Data in AWS CJIS compliant environment.
  2. Implement and design the lake house technologies with the IT Tech Lead assigned to the project
  3. Design and implement using latest AWS Lake House standards.
  4. Data Security Layer
  1. Implement and design security Identity and Access Management roles and processes.
  2. Design and Create security IAM templates.
  • Data Ingestion Layer
  1. Ingestion Design for variety of sources
  2. Operational Database Sources
  • MySQL, SQL Server
  1. SaaS Applications
  2. File Shares (SharePoint and one drive)
  3. Stream Data Sources
  • System Templates of ingestion processes o Data Storage Layer
  • AWS S3 CJIS compliant S3 buckets
  • AWS Redshift Infrastructure
• Power BI Connector process o 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. o 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.

  1. Create Templates for expansion of the data lake for future agencies.
  2. Base data warehouse implemented environment for reporting/dashboard use.
  3. Template designs for future data Lakehouse implementations.
  4. Lake House design needs to be able to be used by Power BI
  5. Design each layer for scaling based on usage.
• PROFESSIONAL SERVICE REQUIREMENTS
  1. AWS Lakehouse Certification
  2. AWS Design and Implementation Lake House Technologies
  3. AWS IAM
  4. AWS Lakehouse Technology
  5. AWS Glue Knowledge
  • Data Catalog and Crawler
  1. AWS Redshift
  2. AWS Athena
  3. CJIS certified data storage
  • AWS CJIS Data location
  1. CJIS Security Background Check (See Additional Attachments / Assurances)

  • Sr. Microsoft Engineer

    1 month ago

    Montpelier, United States Xerox Full time

    Overview: Xerox Corporation is seeking a motivated Sr. Microsoft Engineer. As a Sr. Microsoft Engineer you will ensure successful outcomes for our clients located in the greater Burlington VT area by providing a world-class client experience. You'll work closely with our clients, sales team, and peers to design, implement, and support Microsoft based...

  • Data consultant

    2 weeks ago

    Montpelier, United States Tri-Force Consulting Services Full time

    Title : Amazon Web Services(AWS) 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...

  • Sr. Security Engineer

    3 weeks ago

    Montpelier, United States Marriott Full time

    Job Number 24077113 Job Category Information Technology Location Marriott International HQ, 7750 Wisconsin Avenue, Bethesda, Maryland, United States Schedule Full-Time Located Remotely? Y Relocation? N Position Type Management JOB SUMMARY This position will be part of the Cloud Security Engineering Team within the Global Information Security organization....

  • Sr. Salesforce Developer

    2 weeks ago

    Montpelier, United States Sunrun Full time

    Everything we do at Sunrun is driven by a determination to transform the way we power our lives. We know that starts at the individual employee level. We strive to foster an environment you can thrive in through our commitment to diversity, inclusion and belonging. Overview Sunrun is on a mission to make solar energy affordable for more people. We help...

  • Sr. Salesforce Developer

    5 days ago

    Montpelier, United States Sunrun Full time

    Everything we do at Sunrun is driven by a determination to transform the way we power our lives. We know that starts at the individual employee level. We strive to foster an environment you can thrive in through our commitment to diversity, inclusion and belonging. Overview Sunrun is on a mission to make solar energy affordable for more people. We help...

  • Senior Technical Account Manager

    5 days ago

    Montpelier, United States EDB Full time

    EDB Senior Technical Account Manager Montpelier , Vermont Apply Now Innovative, collaborative minds wanted. The world loves Postgres. We envision a world where organizations thrive by harnessing the full power of Postgres, the world’s fastest growing and most loved and used open source database. Our mission is to enable data teams everywhere to harness the...

  • Project Manager

    1 week ago

    Montpelier, United States Radiant Digital Full time

    **Position: Sr. Project Manager** **Location: Remote - Vermont** **Duration: 2 Years** **Background** **Education** - Bachelor's and/or master’s degree in computer science, **Requirements**: We are looking for a Senior Project Manager with a penchant for project management process and tools who can effectively and efficiently join a project...

  • PL Territory Sales Manager

    3 days ago

    Montpelier, United States The Hanover Insurance Group Full time

    For more than 170 years, The Hanover has been committed to delivering on our promises and being there when it matters the most. We live our values every day, demonstrating we CARE through our values, ESG initiatives and IDE journey. Our Personal Lines Sales team is seeking an experienced Territory Sales Manager to work in New Hampshire & Vermont. This is a...