Data Engineer Job at Cloud Consulting Services Inc, Montpelier, VT

ZGNqKys3bUpSSVB1cXBZeHlSNmJHUGlzb3c9PQ==
  • Cloud Consulting Services Inc
  • Montpelier, VT

Job Description

Hi,

Hope you are doing well

We currently have an opening for a Data Engineer, Remote (Montpelier, VT). The position details are given below. If you are interested, please email me or call me.

Job Details:

Title: Data Engineer

Duration: 12+ Months

Location: Remote (Montpelier, VT)

Required Technical Expertise:

  • The Data Engineer must demonstrate proficiency in the following areas:
  • Advanced SQL with emphasis on complex SELECT statements, joins, subqueries, and transformation logic.
  • MySQL/MSSQL database architecture and schema discovery.
  • Data modeling, normalization concepts, and reverse-engineering undocumented schema.
  • ETL methodology and preparing structured data for ingestion into third-party systems.
  • Experience with public-safety RMS, case-management, or similarly complex relational data structures (preferred).
  • Strong analytical and documentation skills with the ability to interpret incomplete or ambiguous legacy data.
  • Experience with ETL processing binary large objects, PDF, and other unstructured data.

Overall Deliverable Requirements

  • All SQL queries must be repeatable, deterministic, and optimized for large datasets.
  • Extracted data must be complete and comply with the new RMS vendor’s ingestion format and validation rules.
  • Documentation must be clear, complete, and suitable for technical maintenance by Agency staff.
  • Work must be executed independently with minimal supervision, while maintaining timely progress communication.
  • Participate in technical discussions with Agency IT staff, RMS vendor teams, and subject-matter experts.
  • Assist with iterative test migrations, adjusting SQL scripts and mappings in response to data issues or schema changes.
  • Provide knowledge transfer to Agency personnel, including walkthroughs of queries, mappings, and logic design.

 

Job Tags

Similar Jobs

Behind the Design

B2B Sales Manager Job at Behind the Design

 ...B2B Sales Manager: Interior Design & Trades Location: Chicagoland (Remote, Full-Time) Schedule: MonFri, 85 or 96 CST; occasional evening networking Behind the Design is growing. Were hiring a full-time, single-brand B2B Sales Consultant to own the sales... 

Roofing Talent America (RTA)

Chief Executive Officer Job at Roofing Talent America (RTA)

 ...Chief Executive Officer Dallas, TX $250,000 $400,000 + Equity, Bonus & Benefits Opportunities Like This Dont Come Around Very Often! This is a confidential search for a CEO to take the reins of a nationally recognized commercial roofing organization with an... 

Apex Health Functional Wellness

Nurse Practitioner Job at Apex Health Functional Wellness

 ...functional health, thyroid optimization, and hormone optimization. Flexible scheduling, as practitioner becomes independent in managing patient care. This is a part-time to full-time opportunity, anywhere from 10-30 hours per week, as schedule begins to fill. Must... 

Rhode Island Rural Water Association

Water Quality Specialist Job at Rhode Island Rural Water Association

 ...Water Quality Specialist (WQAS) Small & Rural Wastewater Systems Location: Rhode Island (with potential regional travel) Position...  ...capacity . Support rural and tribal publicly owned treatment works in meeting compliance standards and strengthening operational... 

GreatAuPair LLC

Housekeeper Job at GreatAuPair LLC

We are interested in someone to be part of our family longterm, helping out around the house and keeping the home clean. Someone with top notch house keeping experience. Duties: - Keeping the house clean (housekeeping) daily, --making of beds. -Laundry Grocery shopping...