Job Description :
Title: Data Engineer (SQL/HQL)
Duration: 06-09+ Months/w possibility of extension
Location: 100% Remote
Interview Process: 2 Video I/V’s
1st – A 30 minute discussion w/ Director
2nd – A 1 hour technical/coding interview with team members

From the Hiring Manager's Desk:
- Candidates must be senior to expert level on SQL and HQL querying. Must be able to complete end-to-end query solutions.
- Candidates must have Healthcare experience with one of the following: Facets, FHIR, Claims, Payer or Payee Data.
- Working for a healthcare company and supporting HR data or sales data is not the same. Do not send candidates like that.
- We are seeking an experienced Data Engineer (SQL/Hive/ETL) The Data Analyst will be responsible for the development and implementation of Hive SQL (HiveQL – HQL) ETL queries from specification documents.

Job Summary:
- Develop complex data extracts, and ad-hoc queries as requested by internal and external customers using SQL, HiveQL (HQL
- Research, troubleshoot, and resolve data issues impacting extract delivery.
- Work closely with Business Systems Analysts to understand requirements regarding solutions; ensure data quality and match-back to core systems transaction results.
- Collaborate on the definition, development, and maintenance of standards and processes.
- Serve as mentoring resource for other developers.
- Support goals and objectives by working closely with management team to deliver value to the business.
- Participate in Daily Standup.

Job Requisites:
- 7+ Years of SQL Experience including 3+ years of HiveQL (HQL) and Hive Tables
- Experience with entire SDLC of project
- Data Modelling/Data Warehouse concepts
- Strong SQL Development
- Unix Scripting experience
- Performance tuning
- Data Pipeline development (data flow)
- Familiarity with various data types and sources (JSON, Structured, Unstructured)
- Healthcare Domain Experience with experience with Facets or other Claims Data.

Preferred Skills:
- Experience with DBeaver, SSMS, Beeline
- Hadoop experience
- FHIR Data Model experience (V3, V4)
- Informatica Experience

Client : Compunnel