Data Architect - Data
- Happiest Minds
- 11 - 15 years
- Bengaluru
- 5 days ago
- Email to a friend
- Report this job
Job Description
Define and lead the enterprise migration strategy from SSAS (Multidimensional & Tabular) to Power Bl Semantic Models, ensuring minimal business disruption and long-term scalability.
Decompose complex MDX cubes into 23 domain-aligned Power Bl Semantic Models, ensuring functional equivalence, improved usability, and optimized performance.
Analyze existing SSAS multidimensional cube structures (dimensions, hierarchies, KPls, calculated members, perspectives) and translate them into optimized tabular/DAX-based models.
Lead MDX-to-DAX translation strategy, redesigning calculated members, scoped assignments, and cube scripts into efficient DAX measures and calculation groups.
Define target-state semantic architecture within Power Bl Service including certified datasets, shared semantic layers, thin report strategy, and workspace governance.
Establish migration playbooks including:
a. Cube inventory and dependency mapping
b. Feature parity analysis
c. Performance benchmarking (before vs after)
Data validation and reconciliation framework
Design enterprise modeling standards aligned with Kimball methodology, including conformed dimensions, SCD handling, surrogate keys, and cross-model dimension reuse.
Architect performance optimization strategies such as aggregations, composite models, hybrid tables, incremental refresh, and partitioning.
Provide architectural oversight for model development using tools like Tabular Editor and performance diagnostics with DAX Studio.
Define DevOps and CI/CD framework for semantic models using XMLA endpoints, version control (Git), and structured deployment pipelines.
Establish and enforce governance controls including RLS/OLS security models, workspace design, naming conventions, and metadata documentation standards.
Oversee user acceptance testing (UAT), reconciliation validation against legacy cube outputs, cutover planning, and post-migration stabilization support.
Desired Skills (Plus Points):
Implementation experience with Azure Analysis Services (MDX).
Command over MDX Language.
Certifications in Microsoft Bl tec
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Data warehouse Architect / ConsultantEmployement Type: Full timeContact Details:
Company: Happiest MindsLocation(s): Bengaluru
Keyskills: mdx continuous integration metadata ci/cd data warehousing data architecture business intelligence sql git data modeling solution design devops ssrs dax etl msbi architecture cd python ssas power bi azure analysis services sql server tableau dwbi ssis informatica
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in