Responsibilities
- Design, develop, and maintain enterprise BI solutions using MicroStrategy ONE (latest versions).
- Develop complete BI applications including schema objects, attributes and hierarchies, facts, metrics, filters, prompts, advanced reports and dashboards, and dossiers and interactive visualizations.
- Translate business requirements into scalable BI solutions.
- Build reusable semantic models and reporting frameworks.
- Implement advanced MicroStrategy features including Intelligent Cubes, caching strategies, incremental refresh, derived metrics, advanced analytics functions, and transaction services.
- Create and configure AI Agents, develop conversational analytics experiences, use AI-assisted insights generation, implement Auto Narratives, and leverage AI-powered dashboard and visualization capabilities.
- Enable business users to interact with data using AI-driven analytics.
- Evaluate opportunities to automate reporting and insight generation using AI capabilities.
- Design logical and physical data models for BI consumption.
- Optimize semantic layers for scalability and performance.
- Perform data validation and reconciliation between source systems and BI outputs.
- Write complex SQL queries for Data extraction, Transformation, Validation and Performance tuning.
- Write complex SQL queries utilizing Joins, Window functions, CTEs, Stored procedures and Query optimization techniques.
- Experience working with enterprise databases/data warehouses such as Amazon Redshift, Oracle, SQL Server, Snowflake, Azure Synapse, Databricks.
- Experience working with enterprise ETL/data integration tools such as Matillion, Informatica, Azure Data Factory or Other cloud ETL platforms.
- Understand ETL pipeline design, scheduling, monitoring, and troubleshooting.
- Work closely with data engineering teams to ensure reliable data availability.
- Use Python for Data analysis, Automation, Data validation, API integrations and Reporting utilities.
- Experience with Python libraries such as Pandas, NumPy, Requests and PySpark.
- Monitor and optimize MicroStrategy reports, dashboards, and cubes.
- Troubleshoot performance issues across SQL layer, Data model, MicroStrategy objects and Application layer.
- Perform root cause analysis and implement improvements.
- Support production BI environments and resolve user issues.
Requirements
- 5+ years of experience in Business Intelligence development.
- Strong hands-on experience with MicroStrategy platform.
- Experience with MicroStrategy ONE / Strategy One latest versions.
- End-to-end MicroStrategy development experience: Modelling → Metadata → Reports → Dashboards → Deployment.
- Strong SQL development skills.
- Experience with at least one ETL tool.
- Python scripting experience.
- Strong understanding of data warehousing concepts.
- Experience working with large enterprise datasets.
- Experience implementing Strategy AI solutions.
- Experience creating AI Agents and conversational analytics solutions.
- Experience migrating/upgrading MicroStrategy environments.
- Knowledge of BI governance, security, and user access management.
- Experience with cloud data platforms (Azure/AWS/GCP).
- Experience in retail, finance, supply chain, or enterprise analytics domains.
- Strong analytical and problem-solving skills.
- Ability to translate business needs into technical solutions.
- Excellent communication skills.
- Ability to work independently and collaborate with cross-functional teams.
- Strong ownership mindset and attention to detail.
Skills
- MicroStrategy ONE
- Schema objects
- Attributes and hierarchies
- Facts, metrics, filters, prompts
- Advanced reports and dashboards
- Dossiers and interactive visualizations
- Intelligent Cubes
- Caching strategies
- Incremental refresh
- Derived metrics
- Advanced analytics functions
- Transaction services
- Strategy AI features
- AI Agents
- Conversational analytics
- AI-assisted insights generation
- Auto Narratives
- AI-powered dashboard and visualization capabilities
- Dimensional modelling
- Star schema
- Snowflake schema
- Fact and dimension modelling
- Slowly Changing Dimensions (SCD)
- SQL
- Data extraction
- Data Transformation
- Data Validation
- Performance tuning
- Joins
- Window functions
- CTEs
- Stored procedures
- Query optimization
- Amazon Redshift
- Oracle
- SQL Server
- Snowflake
- Azure Synapse
- Databricks
- ETL
- Matillion
- Informatica
- Azure Data Factory
- Cloud ETL platforms
- ETL pipeline design
- ETL scheduling
- ETL monitoring
- ETL troubleshooting
- Python
- Pandas
- NumPy
- Requests
- PySpark
- BI governance
- BI security
- User access management
- Azure
- AWS
- GCP
- Retail analytics
- Finance analytics
- Supply chain analytics
- Enterprise analytics
Experience Level
- 5+ years of experience in Business Intelligence development
Education Level
- Bachelor’s degree in Computer Science, Information Technology, Engineering, Data Analytics, or related field.
