Data Engineer

Data Engineer

Experience: 5+ years

SQL, Python, ETL/ELT, Data Modeling (Star/Snowflake), CTEs, AWS (S3, Glue, Athena), Big Data tools, RDBMS, Data Lakes, and Data Architecture.

Must be a U.S. Military Veteran

Location: Bethlehem, PA local to the client location

Candidate should Provide technical expertise in needs identification, data modelling, data movement, translating business needs into technical solutions with adherence to established data guidelines and approaches from a business unit or project perspective. Good knowledge of conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL). Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively

5+ Years of experience as a Data Engineer

Strong technical expertise in SQL is must

Strong knowledge of joins and common table expressions (CTEs)

Strong experience with Python

Strong expertise in ETL process and with various data model concepts

Knowledge of star schema and a snowflake schema

Good to have knowledge on AWS services such as S3, Athena, Glue, EMR/Spark with major emphasis on S3 and Glue

Experience with Big Data Tools and technologies

Key Skills:

Good Understating of data structures and data analysis using SQL or Python

Knowledge of implementing ETL/ELT for data solutions end to end

Understanding requirements, and data solutions (ingest, storage, integration, processing)

Knowledge of analyzing data using SQL

Conducting End to End verification and validation for the entire application