Semantic Layer Architect.
This mandate is run by SYMPHONI HR, a Mumbai-based executive search firm, est. 2003. Applications are email-verified and reach the search team running the role — confidentially, always.
About the organisation.
Our client is a leading global technology and analytics services provider operating at significant scale across industries. They serve enterprises with data-driven solutions spanning software, analytics and digital transformation. The organization fosters a collaborative, innovation-led culture that values continuous learning and engineering excellence.
About the role.
The Semantic Layer Architect will design and govern the enterprise semantic layer that gives business users trusted, consistent access to metrics and KPIs across reporting and analytics platforms. This hybrid role combines hands-on architecture with governance, performance optimization and mentorship of engineering teams. You will work closely with data engineers, modelers, BI developers and business stakeholders to make analytics self-service and auditable.
What you will do.
- Design and implement enterprise semantic layers using platforms such as Cube.dev, AtScale, Microsoft Fabric and Power BI semantic models, LookML and dbt Semantic Layer
- Create governed business metrics, KPI definitions, reusable dimensions, measures and calculated metrics
- Build subject-area semantic domains spanning Finance, Risk, Customer Analytics, Marketing, Supply Chain and Operations
- Establish metric governance, metadata management, data lineage and data catalog integration in partnership with governance teams
- Maintain semantic model versioning and change management processes
- Optimize query performance, aggregate-awareness strategies, caching and acceleration mechanisms for large-scale analytical workloads
- Enable self-service analytics across BI tools and support executive dashboards and enterprise reporting
- Conduct architecture reviews and solution design sessions, and mentor engineering teams on semantic modeling best practices
What you bring.
- 10–15 years of experience in data architecture, analytics engineering or semantic modeling
- Must-have hands-on expertise with AtScale and MDX
- Strong dimensional modeling skills including star schema, snowflake schema, Data Vault 2.0, entity relationship and business vocabulary modeling
- Advanced SQL proficiency and experience with business metric governance
- Experience with cloud data platforms such as Azure, Microsoft Fabric, Azure Synapse, AWS, GCP, Snowflake or Databricks
- Familiarity with dbt Semantic Layer, LookML, Power BI semantic models or MetricFlow is a strong plus
- Bachelor's degree in Computer Science, Information Technology, Engineering or a related field; Master's degree preferred
- Strong stakeholder management, leadership and communication skills
Other open roles.
Quantitative Analyst - Treasury (IRRBB) — Mumbai · Hybrid
Control Testing Specialist — Kolkata · On-site
Investment Analytics Senior Associate — Mumbai · Hybrid