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:
o Schema objects
o Attributes and hierarchies
o Facts, metrics, filters, prompts
o Advanced reports and dashboards
o Dossiers and interactive visualizations
• Translate business requirements into scalable BI solutions.
• Build reusable semantic models and reporting frameworks.
• Implement advanced MicroStrategy features including:
o Intelligent Cubes
o Caching strategies
o Incremental refresh
o Derived metrics
o Advanced analytics functions
o Transaction services (where applicable)
Strategy AI / AI Analytics Capabilities
• Hands-on experience with Strategy AI features:
o Creating and configuring AI Agents
o Developing conversational analytics experiences
o Using AI-assisted insights generation
o Implementing Auto Narratives / natural language explanations
o 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:
o Star schema
o Snowflake schema
o Fact and dimension modelling
o 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:
o 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