Job Title: Senior Business Intelligence Lead – Strategy (MicroStrategy)

Location: Bengaluru / Hybrid

Experience: 9+ Years

Department: Enterprise Data & Analytics / Capital Markets Technology

Role Overview

We are seeking an experienced Strategy (formerly MicroStrategy) BI Developer to design, build, and optimize scalable enterprise reporting and analytics solutions. You will be responsible for end-to-end semantic layer modeling, Intelligent Cube optimization, and executive dashboard development. While prior experience in Investment Banking or Capital Markets is not mandatory, candidates with exposure to financial risk, trading, or regulatory reporting workflows will have a distinct advantage.

Key Responsibilities

- Semantic Layer & Schema Architecture: Design, develop, and maintain Strategy/MicroStrategy schema objects (Attributes, Facts, Hierarchies, Transformations, and Partition Mappings) aligned with enterprise data warehouse star and snowflake schemas.
- Application & Dashboard Development: Build high-performance, interactive Dossiers, Report Services Documents, Grids, and Graphs using MicroStrategy Web, Workstation, and Library.
- Cube & Query Optimization: Architect and manage Intelligent Cubes, dynamic aggregation, incremental refresh schedules, and VLDB (Very Large Database) properties to optimize SQL generation and reduce report execution latency.
- Data Integration & SQL Tuning: Write complex, high-efficiency SQL queries, views, and stored procedures to validate report metrics against source data warehouses (e.g., Snowflake, Oracle, SQL Server, Teradata).
- Platform Administration & Governance: Support object migrations using Object Manager, manage user security filters and ACLs (Access Control Lists), and troubleshoot performance bottlenecks using Enterprise Manager and Integrity Manager.
- Stakeholder Collaboration: Partner with business analysts, data engineers,



and end-users to translate complex analytical requirements into intuitive self-service BI assets.

Mandatory Technical Qualifications

- Core BI Expertise: 5+ years of hands-on experience in Strategy / MicroStrategy (v2021 / Strategy ONE or later), covering Architect, Developer, Workstation, and Web.
- Schema & Application Objects: Deep understanding of multi-dimensional modeling, custom groups, consolidations, derived metrics, nested prompts, and level dimensionality.
- Database & SQL: Strong proficiency in writing and tuning complex SQL across relational or cloud data warehouses (Snowflake, PostgreSQL, Oracle, or MS SQL Server).
- Performance Tuning: Proven track record of resolving slow-running reports through VLDB settings, indexing strategies, caching, and Intelligent Cube partitioning.
- SDLC & Agile: Experience working in Agile/Scrum environments with version control, automated testing, and structured CI/CD deployment workflows.

Good-to-Have Qualifications (Investment Banking & Modern BI)

- Investment Banking Domain Knowledge: Familiarity with Corporate and Investment Banking (CIB) concepts such as Global Markets, Trade Lifecycle, PnL attribution, Credit/Market Risk, Liquidity reporting, or Regulatory Compliance (e.g., Basel III/IV, RWA).
- Multi-BI & Migration Experience: Exposure to Power BI or Tableau, particularly in environments migrating legacy BI reports to cloud-native analytics platforms.
- AI & Modern Analytics: Familiarity with Strategy’s AI capabilities (Strategy AI / Auto Bots), Python scripting for data validation, or REST API integrations.
- Cloud Ecosystem: Hands-on experience connecting Strategy/MicroStrategy to cloud data platforms such as Snowflake, AWS Redshift, Google BigQuery, or Azure Synapse.

Soft Skills

- Strong analytical and problem-solving mindset with the ability to debug complex data discrepancies independently.
- Explicit communication skills to present technical trade-offs to both engineering teams and non-technical business stakeholders.

📌 Senior Business Intelligence Lead  – Strategy (MicroStrategy) (Bengaluru)
🏢 TuTeck Technologies
📍 Bengaluru