Data Engineer
Key responsibilities
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.
Required skills & experience
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
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.
Education
Bachelor’s degree in computer science, information technology, engineering, data analytics, or related field.
Key competencies
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