Job Title – MicroStrategy Cube Developer
Seattle Based Client
Location: Seattle, WA - Hybrid working is highly preferred( 3days office)
What is cube development ?
Intelligent Cubes act as a set of data for other reports to connect to and use OLAP Services to report, analyze, and display data. Since Intelligent Cubes function simply as a set of data, Intelligent Cubes do not need to contain objects that modify the display of data.
MicroStrategy Developer Duties & Responsibilities
Advanced experience in BI Reporting design and development
Experience in migrating data from Tableau to MicroStrategy
As a MicroStrategy Developer, lead BI design and development activities, identify risks and recommend risk mitigation plans
Perform MicroStrategy Project design and provide expertise in D2I (MicroStrategy & BICS) development
Contribute to the database design through collaboration with BI analysts, Data Analysts and Data Modelers
Experience with MicroStrategy version 10 development solutions
Develop MicroStrategy Mobile applications for both Android and IOS platforms
Building and maintaining MicroStrategy schema objects (attributes, facts, hierarchies, tables, views)
Strong experience with MicroStrategy Dashboard and Report Development
Development experience in the (Azure ) cloud environment preferred
10+ years of experience with Business Intelligence tools required
3 years of experience with MicroStrategy architecture and project development
strong SQL skills required
Skills required
Understand technical specifications and create report design documents
Data/dimension modeling and concepts
Data Warehouse design and Star Schema methodology
Must have strong SQL and RDBMS (Data model) skills
Provide support for all phases of testing such as integration testing, and user acceptance testing
Sound understanding of the MicroStrategy reporting tool capabilities
Develop Key Dashboards, Reports and Documents
Enhance a lot of Mobile Dashboard's, Dynamic Dashboards using URL Api's
Worked on complex Metrics Creation, Filters, Prompts
Develop reporting architecture (attributes, metrics, cubes, etc), reports and dashboards
Create and manage all of all D2I (Microstrategy & BICS) objects, including, but not limited to, attributes, facts, metrics, and prompts
Ability to build and maintain MicroStrategy application objects (metrics, filters, templates, reports, dashboards)
Creating advance report functionalities (level metrics, consolidations, custom groups, free-form SQL reports, pass-through functions)
Administration of I-Server
Handling project creation and duplication
Setting up ODBC connection, DB Instance and configuring it to project
Performing Object migration using Object Manager or migration packages
Creating and managing the users, Security Groups and Security Roles
Manage I-cubes and caches and troubleshooting the issue
Provided solutions on Data model, SQL and Reports Performance improvement (Performance Tuning)
10+ years experience with Microstrategy tuning and configuration and development
Must have been involved in at least one microstrategy upgrade
Experience working in environments that use Tableau /Teradata/ Informatica is strongly preferred
Experience implementing various types of reports, dashboards and mobile applications is a must
Address: 10150 Mallard Creek RD, Ste # 107, Charlotte, North Carolina 28262