Data Engineer

ZVST Cloud Technologies, Inc.,; Richmond (VA); On-site; USD 110,000 - 150,000; Full time

Job summary

ZVST Cloud Technologies, Inc. in Richmond, VA is seeking a Data Engineer for a long-term contract. The role requires 5+ years of hands-on experience across ETL/ELT design, SQL, BI reporting, UNIX/Linux scripting, and modern data tools like Databricks and Python; familiarity with Informatica, Talend, and Spark is a plus.

Telephonic/Zoom interviews are used in the process. Strong knowledge of data modeling (Star Schema, SCD1) and data quality governance is expected, along with ability to

Qualifications

• 5+ years designing and implementing ETL/ELT on large data volumes.
• 5+ years dimensional modeling and integration to Star Schema and SCD1.
• 5+ years writing complex SQL for data warehouses.
• 5+ years delivering BI reporting using MicroStrategy, Tableau, or Birst.
• 3+ years orchestrating workflows on UNIX/Linux and shell scripting.
• 3+ years working with Spark/Python/Spark SQL data integration patterns.
• 3+ years ensuring data quality, data definitions, and data integrity with SQL/Databricks.
• 2+ years using Databricks, SnowFlake, Python, or Jupyter for data analysis.

Skills

ETL/ELT design

SQL for data warehousing

BI reporting

UNIX/Linux scripting

Spark/Python integration

Data quality monitoring

Databricks

Python

Jupyter

Tools

Informatica

Talend

DMS Syncsort

Job description

Data Engineer Richmond, VA

Type: Contract Duration: Long Term Contract Mode of Interview: Telephonic / Zoom

Title: Data Engineer

Location: VA

Duration: Long Term Contract role

Job Description

• 5+ Years of experience designing, developing and implementing ETL and ELT on large volumes of data using informatica, talend, DMS syncsort
• 5+ Years of experience with dimensional data modeling techniques (Star Schema, Slowly changing Dimensions (SCD1)) and integrating data to these models
• 5+ Years of experience writing complex SQL in a data warehouse setup
• At least 5 Years of experience in delivering business intelligence reporting warehouse using reporting tools (such as MicroStrategy, Tableau, Birst)
• 3+ Years of experience orchestrating complex workflows and exception handling using UNIX / Linux operating system and shell scripting
• At least 3 Years of experience working with recognized industry data integration patterns, methodologies, and techniques (using Spark / Python, Spark / SQL)
• At least 3 Years experience monitoring overall data quality, ensuring data integrity and establishing consistent data definitions (using SQL / Databricks or some procedural language)
• At least 2 Years of experience on one of the modern data analysis tools (Databricks, SnowFlake, Python, Jupyter)