NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us.
We are currently seeking a Software Development Senior Analyst to join our team in GDL, Jalisco (MX-JAL), Mexico (MX).
Role Summary
Data engineer specialised in data virtualization with Denodo, responsible for designing, building and optimising the semantic layer that exposes governed data products to business consumers, BI tools and downstream applications. Integrates heterogeneous sources such as AWS, Oracle, Redshift and enterprise systems, combining virtualization with curated gold layer models under a medallion architecture, and is accountable for query performance and the responsiveness of the visualization layer. Works close to data governance and consumer teams, with proven delivery experience in enterprise or highly regulated environments.
Required Technical Skills
Denodo
- Semantic Layer & Data Services (mid-expert level)
- 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 accele

📌 Software Development Senior Analyst (Guerrero)
🏢 Ntt Data North America
📍 Guerrero