Position : Analytics Architect (Micro Strategy)

Purpose of the Position :

Micro Strategy Architect will be responsible for defining and implementing the reporting architecture for the migration of legacy reporting solutions to the target data warehouse platform. The role requires a hands-on technical leader who can architect solutions, perform SQL analysis, recreate complex reports in Micro Strategy, drive performance optimization, and collaborate with business and technical stakeholders to deliver scalable reporting solutions.

Location: Pune/Nagpur/Bangalore/Chennai

Type of Employment: Full time

Key Result Areas and Activities:

- Micro Strategy Architecture & Development - Design Micro Strategy architecture, metadata, and reporting frameworks while actively developing complex reports, dashboards, and schema objects.
- Reporting Migration & Modernization - Lead and execute the migration of legacy SQL-based reports to Micro Strategy, ensuring reporting accuracy and alignment with business requirements.
- SQL Analysis & Root Cause Investigation - Perform hands-on SQL analysis, troubleshooting, and root cause investigations to resolve reporting and data-related issues.
- Performance Optimization & Governance - Implement performance tuning, security, and governance best practices to ensure scalable and maintainable reporting solutions.
- Technical Leadership & Stakeholder Collaboration - Provide technical guidance to project teams while working directly with business and engineering stakeholders throughout design, development, testing, and deployment.

Work and Technical Experience:

Essential Skills:

- Expert in Micro Strategy architecture, solution design, development,



and enterprise reporting implementations.
- Strong hands-on expertise in Micro Strategy schema design, metadata management, reports, dashboards, documents, metrics, filters, prompts, attributes, and facts.
- Proven experience in migrating and modernizing legacy reporting solutions into Micro Strategy environments.
- Strong SQL expertise with hands-on experience in query optimization, data analysis, troubleshooting, and root cause investigation.
- Experience translating legacy SQL reporting logic into scalable reporting and analytics solutions.
- Deep understanding of data warehouse concepts, dimensional modelling, and reporting architectures.
- Experience implementing Micro Strategy security, governance, and performance optimization frameworks.
- Ability to work as an individual contributor while leading technical solution design and delivery discussions.
- Experience supporting end-to-end SDLC activities including requirements analysis, development, testing, deployment, and production support.

Desirable Skills:

- Experience with Snowflake and cloud data warehouse platforms.
- Exposure to reporting migration and data modernization programs.
- Experience with Power BI, Tableau, or other BI tools.
- Knowledge of Agile delivery methodologies and enterprise reporting governance.

Qualification:

- Bachelor’s degree in Computer Science, Engineering, Information Technology, or related field.
- 9+ years of experience in Micro Strategy architecture, development, enterprise reporting, and analytics solution delivery.
- Strong experience working with data warehouse, BI, and reporting ecosystems.
- Micro Strategy certifications and cloud platform certifications will be an added advantage.

📌 Architect (India)
🏢 InfoCepts
📍 India