Data Engineer - Denodo

this is a right to hire position with a major investment firm.

Hybrid in Newark, NJ 3days/week

We are seeking a hands-on Senior Data Engineer with strong Denodo experience to design, build, and maintain scalable virtualized data products and semantic-layer solutions. The ideal candidate will have expertise in data integration, virtualization, API enablement, and cloud-based ETL development.

This role will partner closely with Solution Architects, Tech Leads, AI Engineers, and Business SMEs to deliver trusted, governed, and AI-consumable data assets.

• Develop and maintain layers of views;
• Build virtualized data products using Denodo best practices.
• Implement:
  Relationship, joins, standardization, transformations
• Apply enterprise naming conventions and business metadata standards.

• Build and support ETL/ELT pipelines using AWS services.
• Integrate data from multiple source systems, APIs, cloud platforms, and operational applications.
• Support creation of canonical data models and semantic-layer entities.
• Develop reusable data transformation components.

• Optimize Denodo query performance.
• Implement caching and accelerator strategies.
• Tune joins, aggregations, and virtualized query execution.
• Troubleshoot complex performance and integration issues.

• 5+ years of Data Engineering experience.
• 3+ years of Denodo development experience.
• Strong knowledge of:
  • Virtual Data Models
  • Data Integration
  • SQL
  • Data Warehousing
  • Dimensional Modeling
• Experience with:
  • AWS Lambda
  • ETL/ELT development
  • APIs and Web Services
  • Data Product development
• Experience implementing:
  • Join strategies
  • Aggregations
  • Union operations
  • Data standardization frameworks

• Exposure to:
  • AI/Agent engineering ecosystems
  • LLMOps concepts

payrate: 60 - 70 per hour.