Note: The job is a remote job and is open to candidates in USA. Avinya Technologies is hiring a Senior MicroStrategy Analytics Architect & Platform Administrator to design, develop, administer, and optimize enterprise BI solutions. The role owns the technical health, scalability, reliability, and performance of the MicroStrategy environment across development, QA, and production.
Responsibilities
- Design end-to-end BI architecture, including dimensional data models, semantic layers, project schemas, dashboards, dossiers, metrics, and reporting solutions
- Install, configure, administer, and maintain MicroStrategy Intelligence Server, Web, Library, Workstation, and related platform components
- Manage server clustering, high availability, load balancing, failover, disaster recovery, backup, and restore procedures
- Develop and optimize complex SQL queries, analyze execution plans, and improve report and dashboard performance
- Design and maintain data warehouse models, including Star and Snowflake schemas, facts, dimensions, hierarchies, indexes, and partitions
- Manage platform upgrades, patches, migrations, and cloud deployments across AWS, Azure, Google Cloud Platform, or MicroStrategy Cloud Environment
- Implement enterprise security, user access controls, LDAP/Active Directory, SSO/SAML, security filters, and governance standards
- Manage object migration, release processes, change control, and administrative automation using MicroStrategy tools and REST APIs
- Troubleshoot critical production incidents and serve as the primary technical escalation point
- Establish architecture standards, documentation, development guidelines, and operational procedures
- Mentor developers and administrators, conduct technical reviews, and collaborate with business and IT stakeholders
Skills
- 10+ years of overall experience in Business Intelligence, Data Analytics, or enterprise data platforms
- 8+ years of hands-on MicroStrategy experience spanning architecture, development, and platform administration
- Strong knowledge of MicroStrategy / Strategy One architecture, Intelligence Server, metadata repository, project schema, and platform components
- Extensive experience with MicroStrategy Workstation, Architect, Developer, dashboards, dossiers, reports, metrics, filters, prompts, and semantic layer design
- Proven hands-on experience with server installation, configuration, administration, clustering, high availability, security, upgrades, and production support
- Expert-level SQL skills, including complex joins, analytical functions, window functions, query optimization, and execution plan analysis
- Strong data warehousing and dimensional modelling expertise, including Star/Snowflake schemas, fact and dimension design, indexing, and partitioning
- Experience with VLDB properties, SQL generation, caching, Intelligent Cubes, and performance tuning
- Experience with enterprise databases such as Oracle, SQL Server, Teradata, Snowflake, Databricks, BigQuery, Redshift, or similar platforms
- Demonstrated ownership of at least two full-cycle production upgrades or platform migrations
- Proven technical leadership, mentoring, troubleshooting, and critical incident management experience
- Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field
- No visa sponsorship available
- MicroStrategy platform administration, architecture, or developer certifications
- Experience with MicroStrategy Cloud Environment and cloud platforms such as AWS, Azure, or Google Cloud Platform
- Scripting and automation using Python, PowerShell, or Shell
- Familiarity with Power BI, Tableau, ETL/ELT tools, CI/CD, Git, and DevOps practices
- Experience in financial services, retail, healthcare, life sciences, or other large enterprise environments
Benefits
- 100% remote work
Company Overview