Analytics Data Engineer

oraclecloud

Bengaluru NM Years Exp Posted 1h ago

Lead development of analytics data models (dimensional and/or domain-oriented) optimized for reporting, business intelligence, and self-service consumption.
Design and maintain a semantic layer (standardized metrics, dimensions, entities, and business definitions) to ensure consistency across dashboards and analyses.
Translate stakeholder requirements into clear modeling deliverables (entities, grains, metric definitions, acceptance criteria).
Build transformations primarily in SQL, leveraging Python when needed for complex logic, automation, or validation.
Implement and champion data quality controls (tests, reconciliations, anomaly checks) tied to business-critical metrics.
Optimize model performance in Snowflake and/or Databricks (efficient joins, partitioning and clustering strategies where applicable, cost/performance trade-offs).
Collaborate with upstream teams on source system understanding (including semi-structured data and non-relational sources) and ensure analytics models reflect correct business meaning.
Establish modeling standards: naming conventions, documentation, lineage, metric governance, and change management for semantic definitions.
- Support enablement by documenting curated datasets, creating user guidance, and helping consumers adopt the semantic layer correctly.