Aws Data Lake Technical Lead

3 weeks ago

Waterbury, United States MY3TECH INC Full time

Hi,

Hope you are doing well.

This is **Ravali** from **My3 Tech.**

**Title : AWS Data Lake Technical Lead**

**Client: State of VT/Department of Public Safety (DPS)**

**Location : Waterbury, VT (Onsite)**

**Duration : Long-term Contract**

**Background**:
Client 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.

Client in collaboration with the 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 Lakehouse environment.

**Existing Technology Environment**

Client 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.

**Requirements**:
Design and implement the Clients’ 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.
- Create Templates for expansion of the data lake for future agencies.
- Base data warehouse implemented environment for reporting/dashboard use.
- Template designs for future data Lakehouse implementations.
- Lake House design needs to be able to be used by Power BI
- Design each layer for scaling based on usage.

**Professional Service Requirements**:

- 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
- AWS CJIS Data location
- CJIS Security Background Check (See Additional Attachments / Assurances)

**Ravali**

Technical Recruiter

Pay: $100.00 - $115.00 per hour

**Benefits**:

- 401(k)
- Dental insurance
- Health insurance

Experience level:

- 11+ years

Schedule:

- 8 hour shift

**Experience**:

- Informatica: 1 year (required)
- SQL: 1 year (required)
- Data warehouse: 1 year (required)

Ability to Relocate:

- Waterbury, VT: Relocate before starting work (required)

Work Location: On the road

  • AWS Data Lake Technical Lead

    2 weeks ago

    Waterbury, United States My3Tech Inc Full time

    Hello,I hope you are having a great day!Please go through below position and let me know your interest.AWS Data Lake Technical LeadWaterbury, VT - Remote with Occasional Onsite (travel Expenses will be reimbursed) Long-term ContractBackground:Client is seeking to improve statewide law enforcement data access. The purpose is to design and implement a...

  • AWS Data Architect

    4 days ago

    Waterbury, United States Juno Search Partners Full time

    Job Description Job Description We are 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. Responsibilities: Design and implement the Department of Public Safety Data Lake in the AWS Environment Store Data in AWS CJIS compliant environment. Implement...

  • AWS Data Architect

    5 days ago

    Waterbury, United States Juno Search Partners - Open Positions Full time

    Job DescriptionJob DescriptionWe are 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.Responsibilities:Design and implement the Department of Public Safety Data Lake in the AWS EnvironmentStore Data in AWS CJIS compliant environment.Implement and...

  • AWS Data Lakehouse Consultant

    2 weeks ago

    Waterbury, United States Tri-Force Consulting Services Inc Full time

    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...

  • AWS Data Lakehouse Consultant

    2 weeks ago

    Waterbury, United States Tri-Force Consulting Services, Inc. Full time

    Job DescriptionJob DescriptionTitle: AWS Data Lake house Consultant (Architect) Location: Waterbury Village Historic District, VT 05676Client: The Vermont Department of Public SafetyNote: This is a hybrid position.Job Description:The Vermont Department of Public Safety (DPS) is seeking to improve statewide law enforcement data access. The purpose is to...

  • Cloud Engineer

    2 weeks ago

    Waterbury, United States Tech Army, LLC Full time

    NOTE:Professional Service RequirementsAWS Lakehouse CertificationAWS Design and Implementation Lake House TechnologiesAWS IAM o AWS Lakehouse TechnologyAWS Glue KnowledgeData Catalog and CrawlerAWS RedshiftAWS AthenaCJIS certified data storageAWS CJIS Data locationCJIS Security Background Check (See Additional Attachments / Assurances)JOB ENTAILS:Design and...

  • Cloud Engineer

    2 weeks ago

    Waterbury, United States Tech Army, LLC Full time

    NOTE:Professional Service RequirementsAWS Lakehouse CertificationAWS Design and Implementation Lake House TechnologiesAWS IAM o AWS Lakehouse TechnologyAWS Glue KnowledgeData Catalog and CrawlerAWS RedshiftAWS AthenaCJIS certified data storageAWS CJIS Data locationCJIS Security Background Check (See Additional Attachments / Assurances)JOB ENTAILS:Design and...

  • Inside Technical Sales/Customer Service

    2 weeks ago

    Waterbury, United States T. Sendzimir, Inc. Full time

    Position Title: Inside Technical Sales and Customer ServiceDepartment: Sales DepartmentReporting to: Tad Sendzimir – President & CEOLocation: Waterbury, CTT. Sendzimir, Inc. is a 65 year old Engineering Firm located in Waterbury, Connecticut and is involved in the design and development of heavy machinery to roll sheet strip steel - especially stainless...

  • Inside Technical Sales/Customer Service

    2 weeks ago

    Waterbury, United States T. Sendzimir, Inc. Full time

    Position Title: Inside Technical Sales and Customer ServiceDepartment: Sales DepartmentReporting to: Tad Sendzimir – President & CEOLocation: Waterbury, CTT. Sendzimir, Inc. is a 65 year old Engineering Firm located in Waterbury, Connecticut and is involved in the design and development of heavy machinery to roll sheet strip steel - especially stainless...

  • Inside Technical Sales/Customer Service

    2 weeks ago

    Waterbury, United States T. Sendzimir, Inc. Full time

    Position Title: Inside Technical Sales and Customer ServiceDepartment: Sales DepartmentReporting to: Tad Sendzimir – President & CEOLocation: Waterbury, CTT. Sendzimir, Inc. is a 65 year old Engineering Firm located in Waterbury, Connecticut and is involved in the design and development of heavy machinery to roll sheet strip steel - especially stainless...

  • Senior Network Engineer

    1 week ago

    Waterbury, United States 1571 Global Outsourcing Svcs Full time

    Job Description: DXC Technology (NYSE: DXC) helps global companies run their mission critical systems and operations while modernizing IT, optimizing data architectures, and ensuring security and scalability across public, private and hybrid clouds. The world’s largest companies and public sector organizations trust DXC to deploy services across the...

  • Lead Interventional Radiology Tech

    4 days ago

    Waterbury, United States Trinity Health Full time

    **Employment Type:** Full time **Shift:** Rotating Shift **Description:** **Position Purpose** Contribute to efficient operations of the SMH Imaging Services Department, ensuring the quality and continuity of patient care. **What you will do** + Organize and coordinate all daily activities and workflow of the Interventional Radiology Department - ...

  • Research Manager

    4 days ago

    Waterbury, United States MacDermid Alpha Electronic Solutions Full time

    **Business Overview**: **MACDERMID ALPHA ELECTRONIC SOLUTIONS** Through the innovation of specialty chemicals and materials under our Alpha, Compugraphics, Electrolube, Kester, and MacDermid Enthone brands, MacDermid Alpha Electronics Solutions provides solutions that power electronics interconnection. We serve all global regions and every step of device...

  • Lead Interventional Radiology Tech

    4 days ago

    Waterbury, United States Trinity Health Corporation Full time

    Employment Type: Full time Shift: Rotating Shift Description: Position Purpose Contribute to efficient operations of the SMH Imaging Services Department, ensuring the quality and continuity of patient care. What you will do * Organize and coordinate all daily activities and workflow of the Interventional Radiology Department * Assign daily room...

  • Research Operations Manager

    5 days ago

    Waterbury, United States Element Solutions Inc Full time

    Business OverviewMACDERMID ALPHA ELECTRONIC SOLUTIONSThrough the innovation of specialty chemicals and materials under our Alpha, Compugraphics, Electrolube, Kester, and MacDermid Enthone brands, MacDermid Alpha Electronics Solutions provides solutions that power electronics interconnection. We serve all global regions and every step of device manufacturing...

  • Director, SEC Reporting

    3 days ago

    Waterbury, United States Webster Bank Full time

    If you’re looking for a meaningful career, you’ll find it here at Webster. Founded in 1935, our focus has always been to put people first--doing whatever we can to help individuals, families, businesses and our colleagues achieve their financial goals. As a leading commercial bank, we remain passionate about serving our clients and supporting our...

  • Applications Specialist

    5 days ago

    Waterbury, United States Element Solutions Full time

    Business Overview MACDERMID ALPHA ELECTRONIC SOLUTIONS Through the innovation of specialty chemicals and materials under our Alpha, Compugraphics, Electrolube, Kester, and MacDermid Enthone brands, MacDermid Alpha Electronics Solutions provides solutions that power electronics interconnection. We serve all global regions and every step of device...

  • Applications Specialist

    2 days ago

    Waterbury, United States Element Solutions Inc Full time

    Business OverviewMACDERMID ALPHA ELECTRONIC SOLUTIONSThrough the innovation of specialty chemicals and materials under our Alpha, Compugraphics, Electrolube, Kester, and MacDermid Enthone brands, MacDermid Alpha Electronics Solutions provides solutions that power electronics interconnection. We serve all global regions and every step of device manufacturing...

  • Applications Specialist

    1 day ago

    Waterbury, Connecticut, United States Element Solutions Inc Full time

    Business OverviewMACDERMID ALPHA ELECTRONIC SOLUTIONSThrough the innovation of specialty chemicals and materials under our Alpha, Compugraphics, Electrolube, Kester, and MacDermid Enthone brands, MacDermid Alpha Electronics Solutions provides solutions that power electronics interconnection. We serve all global regions and every step of device manufacturing...

  • Project Manager

    6 days ago

    Waterbury, United States Tri-Force Consulting Services, Inc. Full time

    Job DescriptionJob DescriptionTitle:Project ManagerLocation: Waterbury, VermontClient: The Vermont Department of Public SafetyNote : This is a remote positionJob Description:The Agency of Digital Services (ADS) Enterprise Project Management Office (EPMO) is seeking remote senior project management support for an IT project in partnership with the Agency of...