AWS Data Lakehouse Consultant

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

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

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

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

  • Lactation Consultant

    7 days ago

    Waterbury, United States Waterbury Hospital Full time

    Position Summary: Provides direct lactation support and education to patients and staff that is patient-centered, high-quality, cost-effective, and consistent with the hospital's mission, goals, and strategic plan. Functions collaboratively within the multidisciplinary health care team on the FBC and NICU units to provide comprehensive, specialized lactation...

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

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

  • Part-time IP Residential Psychiatrist Position in Connecticut

    1 week ago

    Waterbury, United States CompHealth Full time

    Posted 30+ days ago$130 - $140/hr Your compensation offer will be calculated according to your experience, qualifications, and the complexity of the role. Shift length, call, and overtime may positively impact compensation. Please reach out to your consultant for more information.PermanentWaterbury, ConnecticutQuick Facts Now docs needed for this employed...

  • Behavioral Health Clinician

    5 days ago

    Waterbury, United States MosesWeitzman Health System Full time

    **Job Description Summary:** Community Health Center, Inc. (CHC), with offices in Connecticut, Colorado and California, is one of the country's most creative and dynamic providers of primary medical, dental, and behavioral health services, and a leader in practice-based research, health professionals training, and use of innovative technologies to advance...

  • School Based Behavioral Health Clinician

    5 days ago

    Waterbury, United States MosesWeitzman Health System Full time

    Job Description Summary: Job Description: The SBHC Licensed Behavioral Health Clinician is a licensed independent provider who performs diagnostic psychosocial evaluations, develops care plan with clients and their families, offers individual, family, or group therapy as appropriate, collaborated with psychiatric and/or medical providers who are part of...

  • School Based Behavioral Health Clinician

    4 days ago

    Waterbury, United States MosesWeitzman Health System Full time

    **Job Description Summary:** **Job Description:** The SBHC Licensed Behavioral Health Clinician is a licensed independent provider who performs diagnostic psychosocial evaluations, develops care plan with clients and their families, offers individual, family, or group therapy as appropriate, collaborated with psychiatric and/or medical providers who are...

  • School Based Behavioral Health Clinician

    3 weeks ago

    Waterbury, United States Community Health Center Full time

    Job Description Summary: Job Description: The SBHC Licensed Behavioral Health Clinician is a licensed independent provider who performs diagnostic psychosocial evaluations, develops care plan with clients and their families, offers individual, family, or group therapy as appropriate, collaborated with psychiatric and/or medical providers who are part of the...

  • Stroke Coordinator

    2 weeks ago

    Waterbury, United States Waterbury Hospital Full time

    SCOPE OF POSITION: The Stroke Coordinator, reporting to Vice President of Patient Care and Chief Nursing Officer, is responsible for the administrative and clinical support of the hospital’s Stroke Center. Administer and maintain the standards of practice for the care of stroke patients and interaction with all healthcare providers, patients, families and...

  • Stroke Coordinator

    2 weeks ago

    Waterbury, United States Waterbury Hospital Full time

    SCOPE OF POSITION: The Stroke Coordinator, reporting to Vice President of Patient Care and Chief Nursing Officer, is responsible for the administrative and clinical support of the hospital's Stroke Center. Administer and maintain the standards of practice for the care of stroke patients and interaction with all healthcare providers, patients, families and...

  • Manager Talent Development

    4 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 firstdoing 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 communities....

  • Cash Room Manager

    4 days ago

    Waterbury, United States Restaurant Depot Full time

    Position Title: Cash Room Manager Department: Cash Room Supervisor: Assistant Branch Manager FLSA: Non-exempt Position Summary: Works closely with Assistant Branch Manager and Branch Manager to ensure efficient operation of the Cash Room. Responsible for maintaining accurate records of Cash Room related transactions. Follows-up...

  • Head of Personal Training

    5 days ago

    Waterbury, United States Crunch Fitness Full time

    Job Description Summary: The primary objective of the Head of Personal Training is to maximize the number of members who participate in, and as a result retain, our paid Personal Training Services. This will be accomplished by meeting and exceeding both new client acquisition and existing client retention goals. The Personal Training Manager will achieve...

  • Director of Athletics

    3 days ago

    Waterbury, United States NCAA (National Collegiate Athletic Association) Full time

    POST UNIVERSITY - Waterbury, CT JOB SUMMARY DIRECTOR OF ATHLETICS: The Director of Athletics provides administrative direction and oversight for all athletics staff, programs, facilities, activities and coaches. The director is responsible for ensuring compliance with all federal, NCAA, conference (Central Atlantic Collegiate Conference, or CACC) and...