Tri Force Consulting Services is Hiring an AWS Data Lakehouse Consultant Near Waterbury, VT
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 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)
If you are: bright, motivated, skilled, a difference-maker, able to get things done, work with minimum direction, enthusiastic, a thinker, able to juggle and multi-task, communicate effectively, and lead, then we would like to hear from you. We need exceptionally capable people for this role for our client, so get back to us and tell us why you think you are a fit.
About Us:
Tri-Force is one of the fastest growing companies in the Philadelphia region by receiving the award 5 times and 3 times (Ranked #931 2021) on In c. 5000 fastest growing companies in the USA. Tri-Force Consulting Services, In c. is an established consulting services firm offering innovative solutions to Government and Commercial sectors.
We specialize in building customized software applications solutions such as knowledge management systems, business intelligence, data analysis, database support and maintenance, data warehouse implementation and support, systems architecture and systems integration for our clients. Our technical competencies are in Java,.NET, SharePoint, PHP, Business Intelligence (Cosign, Data Warehouse), mobile applications platforms (iPhone, iPad, Android, Blackberry), and various other technologies. We also specialize in providing resources to manage infrastructure projects.
Tri-Force is one of the fastest growing companies in the Philadelphia region by receiving the award 5 times and 2 times on In c. 5000 fastest growing companies in the USA.