Data Engineer (34225275)

$166,400 - $170,560/Yr

Innova Solutions USA - Woodbridge Township, NJ

Full-time - Mid Level

Woodbridge Township, NJ

10,001+ employees

Professional, Scientific, and Technical Services

About the position

The Data Engineer position at Innova Solutions is a contract role focused on developing and managing Enterprise Data Warehouse solutions. The role requires a candidate who can work independently in a fast-paced environment, performing detailed analysis and fostering relationships with stakeholders. The Data Engineer will be responsible for database design, troubleshooting, and ensuring compliance with quality and security standards while supporting ongoing data management efforts across various environments.

Responsibilities

• Hands on experience designing, modeling and developing Enterprise Data Warehouse solutions.
• Hands on experience coordinating and executing SIT and UAT testing for Enterprise Data Warehouse solutions.
• Proficient writing SQL queries and programming including stored procedures and reverse engineering existing processes.
• Leverage SQL, programming language (Python or similar) and/or ETL Tools (Azure Data Factory, Data Bricks, Talend, SSIS etc) to develop data pipeline solutions to ingest and exploit new and existing data sources.
• Proficient on data analysis and complex problems resolution.
• A significant contribution to an enterprise-wide Cloud Data Platform migration.
• Participate in the improvement of our DevOps initiatives.

Requirements

• 6+ years of experience in development of high-availability, high volume transactional processing systems.
• Proficiency in working with systems required to effectively process large volumes of both real-time and batch transactions.
• Experience designing, modeling and developing Enterprise Data Warehouse solutions.
• Proficient writing SQL queries and programming including stored procedures and reverse engineering existing processes.
• Ability to perform physical modeling and metadata analysis efforts.
• Experience providing guidance and direction to less experienced staff in resolution of escalated issues and/or complex production, application or system problems.

Nice-to-haves

• Azure Cloud platform experience.
• Azure Data Factory or similar ETL tool experience.
• Azure Data Bricks experience.
• Experience with Columnar Data Warehouse solutions like Snowflake, RedShift, Vertica, Greenplum.
• Any capital markets industry knowledge or experience.
• Snowflake development experience.
• SQL Server development experience.

Benefits

• Medical & pharmacy coverage
• Dental/vision insurance
• 401(k)
• Health saving account (HSA)
• Flexible spending account (FSA)
• Life Insurance
• Pet Insurance
• Short term and Long term Disability
• Accident & Critical illness coverage
• Pre-paid legal & ID theft protection
• Sick time
• Employee Assistance Program (EAP)