Job Description :
Role: Data Engineer
Location: Richmond, VA (Must be able to sit onsite in Richmond for this role)
Length: Long term contract until the end of December 2020 with high potential to extend based on performance
Compensation: Competitive and negotiable based on experience


Data Engineer Responsibilities:
Create and maintain optimal data pipeline architecture for enterprise big data and analytics in a cloud based big data environment.
Design and assemble large, complex data sets that meet functional / non-functional business requirements.
Implement internal process improvements in data analytics: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
Build the infrastructure and workflows required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and ‘big data’ technologies.
Build analytics applications that utilize the data pipeline to provide actionable insights into key business performance metrics.
Create tools and processes to keep sensitive data, including PHI and PII data separated and secure across clients.
Work with data and analytics experts to strive for greater functionality in data systems to help make our client a market leader in big data.

Data Engineer Requirements:
Advanced SQL query skills
SSIS experience building ETL pipelines
Azure Data Factory (ADF)
HIPPA/Healthcare experience and knowledge

Data Engineer Pluses (Not Required):
DataBricks (Azure or Cloudera)
PySpark or Python for DataBricks
PowerBI or Tableau experience
Hadoop
.NET development experience
DevOps - source control, etc.
Notes :
Candidates must be able to sit onsite for this role in Richmond, VA. Client is open to candidates relocating to Richmond and for these candidates will conduct a phone interview and then a video interview with the candidate in a local Apex Systems office. If the candidate is within 1 hour driving distance to Richmond client will require them to come to Richmond for in person interview as final round.

Client : Advantasure