Back to jobs
New

Data Engineer Denodo

LATAM

NTT DATA is seeking a driven Data Engineer (Denodo) to identify and cultivate new business opportunities within the CPG industry, with a focus on our client in the Bottle and Brewing segment. This is a performance-based role centered on relationship development and market access, designed for a professional with established networks in the CPG space who is ready to open doors and create meaningful introductions for our sales and delivery teams.

 

Responsibilities:

  • Design, build and maintain the Denodo semantic layer, translating business requirements into governed, reusable views and data products published to the Data Catalog and Data Marketplace.
  • Optimise query performance end to end through delegation, caching, summary views and model refactoring, so that reports and dashboards meet agreed response time targets.
  • Integrate new sources (AWS, Oracle, Redshift, APIs and enterprise systems) into the virtualization layer, defining connection, security and refresh strategies for each.
  • Build and evolve the gold layer: curated dimensional models, certified metrics and aggregates that serve as the single point of consumption for analytics teams.
  • Support the visualization teams as the technical counterpart for data access: model adjustments, aggregate design and troubleshooting of slow or failing reports.
  • Develop and maintain ingestion and transformation pipelines with Informatica and AWS Glue where physical processing is required upstream of the virtual layer.
  • Apply and document development standards, naming conventions, modelling patterns and promotion procedures across Dev/QA/Prod environments.
  • Provide L2/L3 support for the virtualization platform: incident analysis, root-cause investigation, cache and workload tuning, and continuous-improvement backlog.
  • Collaborate with data governance and security teams to enforce access policies, lineage capture and metadata quality on every published asset.
  • Contribute to technical estimation, solution design reviews and knowledge transfer to other engineers.

 

Required Experience:

  • Logical modelling and layering: base views, derived views (join, union, selection, projection, aggregation, flatten) and interface views; disciplined separation between source, integration and business/semantic layers; naming conventions, reusability and version control of metadata.
  • Semantic layer for data products: business-friendly models, certified KPIs and metrics, association and hierarchy definition, field-level descriptions and business metadata so that consumers can self-serve without re-modelling.
  • Advanced SQL: complex queries, stored procedures, custom functions.
  • Query optimization (core requirement): cost-based optimizer, statistics management, query pushdown and delegation to Redshift/Oracle/S3, branch pruning, join strategy selection (merge, hash, nested), partitioned unions, and execution-trace analysis to diagnose and remediate slow queries.
  • Acceleration and caching: full, partial and incremental cache strategies, cache refresh scheduling and invalidation, summary views and smart query acceleration, and MPP acceleration over object storage.
  • Visualization performance: tuning of the consumption layer for Power BI, Tableau and similar tools: live vs. import trade-offs, aggregate awareness, result set reduction, concurrency and workload management to keep dashboard response times within agreed SLAs.
  • Publication and consumption: Data Catalog and Data Marketplace publication, tagging and categorization.

 

Nice-to-Have:

  • Informatica: IDMC (Cloud Data Integration, Cloud Mass Ingestion) or PowerCenter, with mapping and taskflow development, pushdown optimization, and data quality rules feeding the curated layers.
  • AWS Glue: PySpark jobs, crawlers and Data Catalog management, and Glue workflows for ingestion and transformation into S3/Redshift.
  • Orchestration and DataOps: AWS Step Functions or equivalent schedulers, Git-based workflows, CI/CD pipelines, code review and environment promotion practices.
  • Python and SQL for automation, validation and data reconciliation.

 

Tools & Technologies:

  • Medallion architecture: clear understanding of bronze, silver and gold responsibilities, and where virtualization complements or replaces physical persistence at each stage.
  • Gold layer construction: dimensional and star-schema modelling, conformed dimensions, slowly changing dimensions, aggregates and business-rule implementation for consumption-ready models.
  • Data products: definition of data contracts, ownership, quality expectations, SLAs and versioning; documentation and lifecycle of published assets.
  • Working knowledge of Data Mesh and Lakehouse principles and of data governance practices (lineage, cataloguing, stewardship).

 

Education & Certifications:

  • Denodo Platform 9 Certified Developer Associate or Professional
  • Denodo Platform 9 Certified Administrator Associate or Professional.
  • Denodo Platform 9 Certified Architect Associate

 

Required Equipment: This role requires the use of a personal laptop. Candidates must be comfortable with company security software and device management tools being installed on their laptop as part of the onboarding process and for the duration of the engagement.

 

About NTT DATA

NTT DATA is a Top 5 global IT services provider with more than 190,000 professionals across 50+ countries. We combine industry expertise with capabilities in consulting, technology, AI, cloud, applications, infrastructure, and connectivity to help organizations innovate, optimize, and transform. Through responsible innovation, we deliver meaningful business outcomes, accelerate client success, and create a positive impact on society.

 

Equal Opportunity Employer

NTT DATA is committed to hiring and retaining a diverse workforce. We are proud to be an Equal Opportunity/Affirmative Action-Employer, making decisions without regard to race, color, religion, creed, sex, sexual orientation, gender identity, marital status, national origin, age, veteran status, disability, or any other protected class. NTT DATA is an Equal Opportunity Employer Male/Female/Disabled/Veteran and a VEVRAA Federal Contractor.

Create a Job Alert

Interested in building your career at NTT DATA, Europe & LATAM, Branch in USA, Inc.? Get future opportunities sent straight to your email.

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf

Education

Select...
Select...
Select...
Select...
Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in NTT DATA, Europe & LATAM, Branch in USA, Inc.’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 07/31/2029

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.