AWS Data Lakehouse C....
AWS Data Lakehouse Consultant
Posted on :
08-05-2024
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Req ID : 2817675
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 statecontrolled system to access deidentified 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 differencemaker able to get things done work with minimum direction enthusiastic a thinker able to juggle and multitask 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:
TriForce is one of the fastest growing companies in the Philadelphia region by receiving the award 5 times and 3 times (Ranked #) on In c. 5000 fastest growing companies in the USA. TriForce 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.
TriForce 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.
AWS Lakehouse Certification AWS Design and Implementation Lake House Technologies AWS IAM AWS Lakehouse Technology AWS Glue Knowledge Data Catalog and Crawler AWS Redshift AWS Athena CJIS certified data storage
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
