Data Engineer

Not Interested
Bookmark
Report This Job

profile Job Location:

Montpelier, VA - USA

profile Monthly Salary: Not Disclosed
Posted on: 2 days ago
Vacancies: 1 Vacancy

Job Summary

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

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 Expe...
View more view more

Key Skills

  • Apache Hive
  • S3
  • Hadoop
  • Redshift
  • Spark
  • AWS
  • Apache Pig
  • NoSQL
  • Big Data
  • Data Warehouse
  • Kafka
  • Scala