Cloud Data Engineer

Title : Cloud Data Engineer

Location : Trenton, NJ (Hybrid 3 days in office)

Duration : 12 months

This senior consultant is for a Cloud data Engineer that will lead in data pipelines and data infrastructure as well as build or assist in any data engineering tasks.

This is an ongoing role beyond that of the dates above.

The State of NJ is seeking a Cloud Data Engineer that will assist in maintaining and monitoring infrastructure as well as build or assist in building data transformation pipelines.

Candidate must have prior experience with AWS or Azure and extensive knowledge of python for ETL development. Additional Cloud-based tools experience is important (see skills section)

Additional desired skills include experience with the following :

• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
• Extensive experience leveraging Python to build data transformation pipelines (ETL) and experience with libraries such as pandas and numpy.
• Experience with pyspark.
• Experience using AWS Glue and EMR to construct data pipelines.
• Experience building and optimizing big data’ data pipelines, architectures, and datasets.
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
• Strong analytic skills related to working with unstructured datasets.
• Build processes supporting data transformation, data structures, metadata, dependency, and workload management.
• A successful history of manipulating, processing, and extracting value from large, disconnected datasets.
• Working knowledge of message queuing, stream processing, and highly scalable big data’ data stores.
• Strong project management and organizational skills.
• Experience supporting and working with cross-functional teams in a dynamic environment.
• We are looking for a candidate with 5+ years of experience in a Data Engineer role, who has attained a Graduate degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field.

They should also have experience using the following software / tools :

• Experience with big data tools : Spark, Kafka,etc.
• Experience with relational SQL and NoSQL databases, including Postgres. Experience with data pipeline and workflow management tools : AWS Glue, Airflow,etc.
• Experience with AWS cloud services : EC2, EMR, RDS, Redshift
• Experience with stream-processing systems : Storm, Spark-Streaming, etc.
• Experience with object-oriented / object function scripting languages : Python, Java, etc.

Skill Matrix :

Prior experience with writing and debugging python - Required - 5 Years

Prior experience with building data pipelines. - Required - 5 Years

Prior experience Data lakes in an AWS environment Required - 3 Years

Prior experience with Data warehouse technologies in an AWS environment - Required - 3 Years

Prior experience with AWS EMR Required - 2 Years

Prior experience with pyspark - Highly desired - 2 Years