Micro Strategy Administrator

Role & responsibilties

Mandatory Skill Set:

• MicroStrategy (administration, design, deployment, and support)
• SQL Server & SSIS (to support ETLSA jobs)
• Azure CI/CD

Good to Have:

• .NET(C#)
• Experience working in Agile team

Soft Skills:

• Ability to interact with internal stakeholders and work independently
• Ability work on Agile environment

Exp

Job type

Detailed JD

• Hands on working experience in MicroStrategy Administration and deployment.
• Hands on working experience on creating and integrating MicroStrategy Reports and Objects Attributes, Dossiers, Dashboard, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups
• Experience in MicroStrategy Office, Narrowcast, User security management, Object Manager designing reports grid, drilldown, ad hoc, OLAP cube and dashboards in MicroStrategy
• Experience in creating MSTR data model for any kind of requirements.
• To work as part of support team and enabled to do code and unit test for the issues raised.
• Addresses root cause of problems and find workarounds/permanent solutions
• Design, support and deliver BI / Reporting applications using Micro Strategy
• Provide technical leadership for Micro Strategy suite of tools.
• In-depth understanding of fundamental Data-Warehousing concepts such as Dimensional Modeling, Star and Snowflake Schemas, Data marts, Security and deployment,
  FACT and Dimensional tables, Logical and Physical data modeling.
• Extensive experience in writing SQL and PL-SQL procedures, functions, triggers and packages
• Extensive experience in writing SSIS jobs
• Good at SQL, Good Knowledge Hands-on experience in Query optimization & performance tuning.
• Knowledge in Optimization of Data Migration, ETL Processes.
  Experience in Power BI.
• Understanding of Agile principles and processes will be a plus.
• Must be a self-starter and result oriented person with an eye for detail and ability to provide inputs/ideas for improvement