Jobs
>
Montpelier

    Data consultant - Montpelier, United States - Tri-Force Consulting Services

    Tri-Force Consulting Services
    Tri-Force Consulting Services Montpelier, United States

    3 weeks ago

    Default job background
    Description
    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)
    Report this job


    Dice Id:

    Position Id:
    #J-18808-Ljbffr


  • F&W Forestry Montpelier, United States

    About usF&W Forestry Services, Inc is an international forestry consulting firm established in Albany, GA in 1962. The company has a staff of more than 200 professionals serving a variety of clients with operations located across the US, UK and South America. We look for employee ...


  • Bear Lake Memorial Hospital Count on us to care Montpelier, United States Full time (40 hours)

    Job ID: Medical Records Coder · Reports To: HIM Director · Classification: Full Time (40 hours/week) · Date Posted: May 14, 2024 · Experience: Previous coding experience preferred. · Education Level: CCS Certification, or higher, preferred. · Bear Lake Memorial Hospital is seekin ...


  • DuBois & King Montpelier, United States

    DuBois & King, Inc. is currently looking to hire a self-motivated Senior Accountant/Assistant Controller to add to our accounting team in our Randolph office. This is a full-time position. Our ideal candidate is a positive team player, who is ready to jump into a fast paced depar ...


  • Xerox Montpelier, United States 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 clien ...


  • BlueCross BlueShield of Vermont Montpelier, United States

    Job Description · Job DescriptionBlue Cross and Blue Shield of Vermont is looking for a Health & Wellness Consultant to join our Client Solutions team. Our company is built on an unwavering focus on the health of Vermonters, outstanding member experiences and responsible cost man ...

  • Vermont Ethics Network

    Customer Support

    4 weeks ago


    Vermont Ethics Network Montpelier, United States Full time

    Job Description · Job DescriptionCustomer Support & Data Management Specialist – Full Time · Are you a motivated, organized, and energetic individual who would enjoy being an essential member of a mission-driven non-profit organization? If so, now is the perfect time to join the ...


  • CBRE Montpelier, United States

    CBRE · Consulting Director - Organizational Design & Transformation · Montpelier , · Vermont · Apply Now · Consulting Director - Organizational Design & Transformation · Job ID · 169025 · Posted · 03-Jun-2024 · Service line · Advisory Segment · Role type · Full-time · Areas ...


  • BlueCross BlueShield of Vermont Montpelier, United States

    Job Description · Job DescriptionBlue Cross and Blue Shield of Vermont is looking for a Sales and Service Consultant to join our Client Relations and External Affairs team. Our company is built on an unwavering focus on the health of Vermonters, outstanding member experiences and ...

  • Hatchit Co

    Jr. Data Analyst

    3 weeks ago


    Hatchit Co Montpelier, VT, United States

    Thank you for your interest in joining the JDSAT team. hatch I.T. is facilitating the recruitment process, so please continue your application here for the Jr. Data Analyst All openings are full-time with JDSAT. Who is JDSAT? We're not a data solutions firm. We're a boutique tec ...


  • State of Vermont Montpelier, United States

    Overview · The Vermont Agency of Agriculture, Food & Markets Agriculture Development Division is looking for an individual with interest in grant and contract management. This position will work directly with program management staff supporting the Resilient Food Systems Infrastr ...

  • Highmark Health

    Senior Data Scientist

    14 hours ago


    Highmark Health Montpelier, United States

    Highmark Health · Senior Data Scientist - AI Services and Platforms · Montpelier , · Vermont · Apply Now · Entirely Remote Work From Anywhere Role · We are seeking an experienced data science specialist to join our AI Services and Platforms team and drive the development of ...

  • The University of Vermont Health Network

    Care Coordinator II

    4 weeks ago


    The University of Vermont Health Network Montpelier, United States

    POSITION SUMMARY Under the direction of the Director of Care Coordination and Patient Transitions, the Care Coordinator II is responsible for coordination and management of the hospital based population.As a leader of the multidisciplinary care management team, the Care Coordinat ...


  • Kansas Action for Children Montpelier, United States

    at CrowdStrike, Inc. in Topeka, Kansas, United States · Job Description CrowdStrike, Inc. · at CrowdStrike, Inc. in Topeka, Kansas, United States · Job Description CrowdStrike, Inc. · Full time · R18136 · About the Role: · CrowdStrike seeks a HR Business Partner, based remote ...


  • National Life Group Montpelier, United States

    New Business Associate at Equity Services Inc. · Position Overview: Join our team at National Life Group and contribute to a culture where your work has impact. As a New Business Associate for Equity Services Inc., you'll be instrumental in processing securities applications and ...


  • Cardinal Health Montpelier, United States

    Cardinal Health · Director, Business Development - Real-World Evidence · Montpelier , · Vermont · Apply Now · Our dynamic team of problem solvers understands the complexities of specialty healthcare, and we draw on our deep expertise to help ensure patients get the therapies ...

  • New Breed

    Sales Executive

    1 day ago


    New Breed Montpelier, United States

    Sales Executive · Hi, we're New Breed. · New Breed is a technology-first agency with a keen eye for design, both in media and system architecture. We bring together your customer-facing teams, aligning systems, technology, and your overall GTM to deliver better outcomes for your ...


  • Confluent Montpelier, United States

    Confluent · Senior People Business Partner · Montpelier , · Vermont · Apply Now · Confluent is pioneering a fundamentally new category of data infrastructure focused on data in motion. Have you ever found a new favorite series on Netflix, picked up groceries curbside at Walm ...


  • Kansas Action for Children Montpelier, United States

    Job Description CrowdStrike, Inc. · at CrowdStrike, Inc. in Topeka, Vermont, United States · Job Description CrowdStrike, Inc. · Full time · Posted 2 Days Ago · R16436 · #WeAreCrowdStrike and our mission is to stop breaches. As a global leader in cybersecurity, our team chan ...

  • Alera Group, Inc.

    Accounting Manager

    1 week ago


    Alera Group, Inc. Montpelier, United States

    OVERVIEW · Noyle Johnson is seeking an Account Manager to join their team · Are you looking to be part of a company where you have exciting opportunities to learn, grow and make a positive impact? Join a team where each employee is empowered to listen generously, speak straight, ...


  • Boundlessfellows Montpelier, United States

    We're transforming the grocery industry · At Instacart, we invite the world to share love through food because we believe everyone should have access to the food they love and more time to enjoy it together. Where others see a simple need for grocery delivery, we see exciting co ...