Senior Data Engineer

Spectraforce Technologies; Newark (NJ); On-site; USD 120,000 - 180,000; Full time

Job summary

Spectraforce Technologies in Newark, NJ is seeking a hands-on Senior Data Engineer to design, build, and maintain scalable virtualized data products using Denodo.

The role partners with architects, AI engineers, and SMEs to deliver governed, AI-ready data assets. Key tasks include Denodo development, cloud-based ETL/ELT, and API enablement.

Candidates should have 5+ years in data engineering, 3+ years in Denodo, strong SQL and data warehousing expertise, and experience with AWS Lambda.

Qualifications

• 5+ years of Data Engineering experience.
• 3+ years of Denodo development experience.
• Strong knowledge of data modeling and data integration.

Responsibilities

• Develop and maintain Denodo data views and virtualized layers.
• Build and optimize ETL/ELT pipelines using AWS services.
• Integrate data from multiple sources including APIs and cloud platforms.
• Tune performance of Denodo queries and data workflows.

Skills

Virtual Data Models

Data Integration

SQL

Data Warehousing

Dimensional Modeling

ETL/ELT

APIs & Web Services

Data Product development

Tools

Denodo

AWS Lambda

Job description

Title: Senior Data Engineer

Duration: 06 months (potential to hire)

Location: Newark, NJ

Job Description

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