Senior MicroStrategy Analytics Architect & Platform Administrator

Location: United States — 100% Remote
Employment Type: Full-Time, Direct Hire
Compensation: $150,000 per year
No visa sponsorship available.

Job Summary

We are seeking an experienced Analytics Architect cum Platform Administrator with deep expertise in MicroStrategy / Strategy One to design, develop, administer, and optimize enterprise Business Intelligence (BI) solutions.

The ideal candidate will combine strong BI architecture and dashboard development skills with hands-on platform administration, server management, performance engineering, security, and production support experience. This individual will own the technical health, scalability, reliability, and performance of the MicroStrategy environment across development, QA, and production.

Key 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.

Required Qualifications

• 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.

Preferred Qualifications

• 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.

• MicroStrategy platform administration, architecture, or developer certifications.

• Experience in financial services, retail, healthcare, life sciences, or other large enterprise environments.

Ideal Candidate

The ideal candidate is a hands-on technical expert who can own both MicroStrategy architecture and day-to-day platform administration, lead technical teams, optimize enterprise BI performance, and ensure production stability with minimal supervision.

This is a 100% remote, full-time direct-hire opportunity. No visa sponsorship is available.