Description

Key Responsibilities

MicroStrategy Asset Design: Design, develop, and maintain modern MicroStrategy Dossiers, interactive dashboards, financial/operational reports, complex metrics, filters, and prompts.

Schema & Semantic Modeling: Build, manage, and optimize MicroStrategy metadata, schema objects, attributes, facts, user hierarchies, transformations, and logical tables.

Database Querying & SQL Tuning: Write, validate, and performance-tune advanced SQL queries, database views, stored procedures, and Intelligent Cubes against multi-terabyte data warehouses.

Requirements Gathering & Technical Translation: Collaborate with business analysts, product owners, and data engineers to convert ambiguous business requirements into high-performance technical deliverables.

Data Validation & Quality Control: Integrate and validate data across disparate source systems to ensure mathematical accuracy, consistency, and alignment with business definitions.

Production Support & Troubleshooting: Diagnose and resolve complex report performance bottlenecks, cube refresh errors, and data discrepancies across Dev, Test, and Production environments.

Agile Consulting Delivery: Participate in daily Agile/Scrum ceremonies, maintain technical documentation, execute deployment validation, and provide seamless knowledge transfer to client teams.

Required Technical Skills & Qualifications

Professional Baseline: 5+ years of dedicated, hands-on MicroStrategy development experience.

Core MicroStrategy Stack: Proven mastery of MicroStrategy Architect (schema object creation: facts, attributes, hierarchies, transformations), MicroStrategy Dossiers, Documents, Intelligent Cubes, and prompt design.

Advanced SQL & Database Depth: Advanced hand-authored SQL skills with a proven ability to analyze, optimize, and troubleshoot complex multi-table joins, CTEs, and window functions.

Data Warehousing Principles: Solid understanding of dimensional modeling, star/snowflake schemas, fact/dimension table design, slow-changing dimensions (SCD), and aggregation strategies.

Enterprise Platform Exposure: Hands-on experience querying enterprise relational or cloud data platforms (e.g., Snowflake, Oracle, MS SQL Server, PostgreSQL, Teradata)

Key Skills

Education

Bachelor's degree