Analytics Architect

Position :  Architect (MicroStrategy)  

Purpose of the Position : MicroStrategy 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 MicroStrategy, 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:  

• MicroStrategy Architecture & Development - Design MicroStrategy 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 MicroStrategy, 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. 

Essential Skills:  

• Expert in MicroStrategy architecture, solution design, development, and enterprise reporting implementations. 
• Strong hands-on expertise in MicroStrategy schema design, metadata management, reports, dashboards, documents, metrics, filters, prompts, attributes, and facts. 
• Proven experience in migrating and modernizing legacy reporting solutions into MicroStrategy 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 MicroStrategy 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. 

Desired 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:  

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

Qualities:

• Strong analytical and problem-solving skills. 
• Hands-on technical leader with an individual contributor mindset. 
• Excellent communication and stakeholder management skills. 
• Self-driven, proactive, and outcome-oriented. 
• Strong attention to detail and quality focus. 
• Ability to work effectively in cross-functional and global teams. 
• Adaptable and capable of managing multiple priorities.