Data Engineer - Denodo

Creative Solutions Services, LLC; New Jersey; Hybrid; USD 171,924,000 - 200,579,000; Full time

Job summary

Creative Solutions Services, LLC, a major investment firm, seeks a hands-on Senior Data Engineer with Denodo experience to design, build, and maintain scalable virtualized data products and semantic-layer solutions. You will partner with Solution Architects, Tech Leads, AI Engineers, and Business SMEs to deliver trusted, governed data assets.

The role offers a hybrid schedule in Newark, NJ (3 days per week).

Qualifications

• 5+ years of Data Engineering experience.
• 3+ years of Denodo development experience.
• Strong knowledge of virtual data models, data integration, SQL, data warehousing, and dimensional modeling.

Responsibilities

• Develop and maintain Denodo views and virtualized data products.
• Build and support ETL/ELT pipelines using AWS services.
• Optimize Denodo query performance, caching, and virtualized execution.
• Collaborate with architects, AI engineers, and SMEs to deliver governed data assets.

Skills

Data Engineering

SQL

Data Integration

Data Warehousing

Dimensional Modeling

ETL/ELT Development

APIs & Web Services

Data Product Development

Tools

Denodo

AWS Lambda

Job description

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

Hybrid in Newark, NJ 3days/week

Description: Data Engineering

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.

Key Responsibilities

Denodo Development

• 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.

Data Engineering

• 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.

Performance Optimization

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

Required Qualifications

• 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

Preferred Qualifications

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

payrate: 60 - 70 per hour.