Microstrategy Developer

This is a Full Time Job

Overview

The position is responsible for the design, development, configuration, administration and support of Discovery Communication’s MicroStrategy Business Intelligence platform. The individual will be required to participate in all SDLC phases and responsible for complex data modeling and advanced MicroStrategy project metadata development. The individual will frequently interact and assist with the ad-hoc reporting and access requests from business users. The individual should possess skills around relationships of data, hierarchies and hybrid data models. Continuing production support, platform maintenance and system enhancements are part of the position responsibilities. The Individual is expected to have a thorough understanding of the Business and data contained within every BI project while working on it. Also should be able to work independently in implementing reporting solution.

Responsibilities

• Very strong experience in understanding data related to the Microstrategy project and be able to independently work with end users.
• Strong Experience with all MicroStrategy Products Suite - Architect, Developer, Web, OLAP Services, Dossiers, MTDI cubes and data wrangling during web import.
• Strong experience in writing SQL and good working knowledge on Oracle, Snowflake and Redshift databases.
• Build MicroStrategy dashboards, RSD's and Reports both for Mobile and Web that satisfy and meet business requirements/needs.
• Collaborate with business engagement teams to define dashboards and reporting solutions to meet diverse, complex business needs.
• Develop complex MicroStrategy architecture layer and base objects.
• Experience working with Schema, Transformations, Complex reports, Report Services Documents (Dashboards), Rolling Metrics, Nested Metrics, Level Metrics, Relationship Filters, Pass thru functions, Hierarchies, VLDB Properties (multi-pass sql, hints, Pre-post SQL etc.), built-in and user defined functions like If, case, running sum etc.
• High level of competence in creating complex Datamart reports and Transactional Datasets.
• Experience on creating highly optimized Intelligent Cubes, Incremental Refresh and experience in dynamic sourcing.
• Good Experience in relational database concepts and dimensional modeling techniques: Star and Snowflake schema
• Experience on various features on RSDs like widgets and selectors to provide more user friendly and interactive Dashboards.
• Ability to write custom sql like self-join, nested queries to troubleshoot complex data issues.
• Training Users on the BI functionality and helping them in creating any objects within Microstrategy
• Work with Business users and be able to comprehend their requests into possible solutions using the current BI platform.

Qualifications

• Bachelor’s degree in business, management information systems, computer science, or an equivalent combination of skills, training, and experience.
• 8-10 years of MicroStrategy Development -- Architecture, Reporting Objects, Web customization and Distribution Services.
• Extremely good at comprehending, analyzing data and it’s relationships.
• 2-3 years of strong Data Visualization experience using Microstrategy Dossier.
• Good knowledge of Data Warehousing principles, ETL processes and dimensional modeling concepts.
• Strong understanding of Oracle/Redshift/Snowflake database and the ability to perform data analysis, troubleshoot data issues in comparison to report output.
• Excellent technical, logical, analytical and problem-solving skills to provide insight on development and application support.
• Effective verbal and written communication skills with technical and non-technical audiences.
• Knowledge of Tableau, PHP is a huge plus.
• Experience in the media industry is a plus.
• Must have the legal right to work in the United States.