Data Engineer

MicroStrategy development & BI delivery

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
- 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
- Transaction services (where applicable)

Strategy AI / AI analytics capabilities

Hands-on experience with Strategy AI features:
- Creating and configuring AI agents
- Developing conversational analytics experiences
- Using AI-assisted insights generation
- Implementing auto narratives / natural language explanations
- Leveraging 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.

Data modelling & data architecture

Strong understanding of dimensional modelling concepts:
- Star schema
- Snowflake schema
- Fact and dimension modelling
- Slowly changing dimensions (SCD)
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.

SQL & data engineering

Write complex SQL queries for data extraction, transformation, validation, and performance tuning.
Strong knowledge of 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.

ETL / data integration

Experience working with any enterprise ETL/data integration tool 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.

Python & automation

Use Python for data analysis, automation, data validation, API integrations, and reporting utilities.
Experience with Python libraries such as Pandas, NumPy, Requests, and PySpark (preferred).

Performance optimization & support

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.

Mandatory

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.

Preferred

Bachelor’s degree in computer science, information technology, engineering, data analytics, or related field.

See also