- Location: Iselin, NJ
- Job Type: Contract
- Ref No: 21-04336
- Date: August 03, 2021
Job Description - Data Engineer
Under the leadership of the Data Management and Analytics organization, Data Engineer is responsible for delivering data warehouse, data lake ingestion, .NET Web applications and business intelligence solutions. The main function of this role is serving as senior technical person for coding, debugging, testing, documenting, and implementing Data as a Service (DaaS) environments, and maintenance/enhancement to existing data lake environments.
- Design, develop, and test enhancements to Data Warehouse on SQL Server
- Design, develop, and test enhancements to Data Lake environment in AWS
- Design, develop, and test enhancements to In-House C# Web applications
- Work with complex Data modeling and design patterns for BI/Analytics reporting requirements.
- Serve as senior technical person for data solutions and architectures in relation to storage, governance, quality, cleansing and distribution.
- Design the infrastructure and reusable processes for optimal execution of data transformation.
- Facilitate the evaluation and selection of data toolsets required to achieve business objectives.
- Provide design decisions around data warehouse solutions that involve multiple disparate business systems.
- Ensure quality level of documentation is produced and maintained in regard to data solution architecture
- Bachelor's Degree in Computer Science or related field.
- 7+ years of overall experience
- 4+ years' experience in a data engineering environment, report automation, batch and real time processing
- 2+ years' experience in C#. .NET environment
- 4+ years' experience in SQL Server environment
- Current Hands on SQL experience
- Experience working in an Agile/Scrum environment
- Background in banking and financial services industry
Strong data skills required:
- SQL, ETL/ELT and MDM
- AWS Data Lakes related skills Hadoop, HDFS, S3, EMR, Hive
- Familiarity with Linux Shell Scripting
- AWS Certified is a plus