Data Engineer - Boston, MA, Hartford, CT, Princeton, NJ, Philadelphia, PA, New York City, NY.

Job Title: Data Engineer
Location: Boston, MA, Hartford, CT, Princeton, NJ, Philadelphia, PA, New York City, NY.
Contact: 12+ Months

Looking for W2 candidates. No C2C

Job Summary:

• Data Engineer with strong expertise in ETL/ELT development, data warehousing, cloud data platforms, and SQL.
• The ideal candidate will have hands-on experience building scalable batch and near real-time data integration solutions and maintaining enterprise data warehouses.

Key Responsibilities:

• Design, develop, and maintain enterprise ETL/ELT pipelines.
• Build scalable batch and near real-time data integration solutions.
• Develop and optimize data warehouse solutions.
• Create and maintain SQL-based data transformation processes.
• Work with cloud-based data platforms including Snowflake.
• Implement data models using Kimball, Inmon, or similar methodologies.
• Collaborate with business and technical teams to deliver data solutions.

Required Skills:

• 6+ years of experience in Data Engineering.
• Strong experience with relational databases and SQL programming.
• Expertise in ETL/ELT tools such as:
• Informatica
• ODI
• Matillion
• SSIS
• Experience with Snowflake or other cloud data platforms.
• Strong understanding of data warehouse architecture.
• Experience developing batch and near real-time integration solutions.
• Knowledge of Kimball and Inmon data modeling methodologies.

Mandatory Skills:

• ETL
• ELT
• Snowflake
• SQL
• Data Warehouse
• Informatica / ODI / Matillion / SSIS
• Data Modeling
• Relational Databases