Senior Analyst - Microstrategy Developer - (Enterprise - SAP/Oracle)

Fractal Analytics
  • Mumbai
  • Confidential
  • 3-4 years
  • 29 May 2015

  • Project/ Program Management IT

  • IT/ Technology - Software/ Services, KPO/ Analytics, IT/ Technology - ERP/ CRM/ SCM
Job Description

Position Description

Fractal is seeking to hire a Mircostrategy Developer to support Fractal's strategic client in Mumbai, India.

Key Responsibilities

Provide functional Microstrategy expertise to clients and manage face to face and collaborate with customers/analysts to develop functional requirements, identify options for meeting those requirements, recommend a course of action and follow through implementing or overseeing all technical aspects
Provide direct technical support on Microstrategy projects: Production support, Modifications, Development, and Testing
Perform problem assessment, resolution and documentation
Be a contributor in setting Data Warehouse BI architecture

Required Skills

More as 2-3+ years of experience in Business Intelligence
Experience in Microstrategy 9.x.
Good knowledge of Microstrategy meta-data
Strong understanding of data warehousing concepts and data modeling.
Good hands on experience with databases like Oracle 11g, Teradata or DB2.
Strong Ability to gather business requirements, design and create reports and dashboards

Candidate Should Have In Depth Experience In The Following

1+ years in Dimensional Modeling/Data warehousing or Business Intelligence.
1+ years Strong SQL Skills with a clear understanding of:

a) Outer joins, Sub-select, EXISTs clause, IN clause

b) Performance tuning of complex multi-pass SQL
+ Years of Microstrategy Experience with a clear understanding of:
Warehouse catalog, Table aliases, Logical Tables, MSTR Partitioning
Automatic vs Manually mapped facts & attributes
Transformations, Metric dimensionality, Different types of hierarchies
Custom Groups, Consolidations, & Derived Elements
Impacts of VLDB settings, Options for prompting
Report Services Documents / Dashboards
Web vs Desktop features
OLAP Services functionality
Delivery Services & Narrowcaster
Microstrategy Office
Security options, Deployment tools, Object dependencies

Preferred Additional Microstrategy Skills

Intelligent Cubes, Multi-source Option
SQL (and drawbacks thereof)
Change Journaling, Integrity Manager
Enterprise Manager, Administration
Recent exposure to Microstrategy experience should be Version 9.x at least with Version 9.4.1 preferred
Must possess excellent interpersonal, verbal, written, and listening skill sets.
Strong analytical skills, proficiency in root cause analysis, and ability to solve problems and craft business solutions
Ability to absorb complex business information and data scenarios, apply analytical skills, and produce thoughtful and strategic recommendations for review with the business partner
Cognos or Qlikview or Tableau is preferred but is not necessary but the acumen to learn a new reporting tool needs to be existent

Job Posted By

About Organisation

Fractal Analytics