Previous Job
Architect Microstrategy Sr
Ref No.: 18-00649
Location: Wilmington, Delaware
Microstrategy Architect in Wilmington, DE 19801

Interview Logistics:

Phone screen or Skype followed by

Onsite in person interview

Required Skills Set:

Years of Experience: 5 Plus years experience with Microstrategy Development and Architecture.

Education Required: Bachelors Degree

MicroStrategy Architect

Understand the requirements and convert them into Logical Data Model/Hierarchies

Must understand the concept of Slowly Changing Dimensions and should know how to architect them in Microstrategy.

Experience working with capturing reporting on Current and Historical Data.

Experience working with Transformations.

o MicroStrategy Developer

Experience working with Complex reports.

Experience with Report Services Documents (Dashboards).

Experience with Rolling Metrics, Nested Metrics, Relationship Filters, etc..

Experience with VLDB Properties (multi-pass sql, hints, etc)

Work on Tuning reports with Performance issues.

Experience with Narrowcast Server( nice to have). Should be able to create Static and Dynamic Subscription sets.

o MicroStrategy Administration ( this position does not need to do any administration work but good to know concepts)

Experience with Upgrades, regression testing, etc..

Experience with setting up Narrowcast Server.

Experience with Object Manager

Experience with Intelligence Server / Web Server administration.

Experience with Security roles, Security Filters, User management, Access Control Lists, etc..

Experience with Enterprise Manager

o Database Skills

Good Oracle SQL writing skills

Good Oracle SQL tuning skills

Additional Preferred Skills:

Assume ownership of various initiatives across Solution Delivery and/or BTG as agreed with team or tech lead for complete and successful delivery.

o Provide functional expertise within his/her skills to assist delivery team members, foster collaboration.

o Work closely and maintain ongoing communications with project lead, project sponsor, business analyst and technical leads.

o Provide issue response and root cause analysis on Unicenter and Quality Center tickets as assigned by team lead tech lead or project lead.

o Escalate issues on a timely basis to team lead, tech lead, and project lead.

o Communicate incoming work requests to team lead when requested to work on unplanned items. Responsible to work only on tasks assigned by team lead or tech lead.

o Report over or under allocation to the team lead, forecast work remaining, identify and communicate variance to plan. If colleague is a contractor he/she should request approval prior working overtime.

o Report progress, delays and risks on assigned activities to project lead.

o Provide feedback on lessons learned and retrospective meetings.

o Raise awareness when existing code, systems or processes do not meet current quality expectations and standards.

o Initiate User Account/Hardware/Software requests needed to perform the assigned tasks.

o Ensure proper Timesheet submittal by the agreed SLA, every week, reflecting actual hours worked on any projects or assignments.


o Develop code, configuration files, build scripts, schemas or other artifacts associated by the features, QC and UC tickets, as assigned by team or tech lead.

o Maintain code and all related artifacts in source control; perform code merges and resolve conflicts as defined by development process, update documentation and automated tests.

o Develop unit tests for new code created; modify existing unit tests for altered functionality.

o Develop system integration test to verify the code running in its functional environment.

o Work with the project lead, tech lead and team lead to schedule features into Releases.

o Create implementation plans and Change Management Requests as assigned by team lead or tech lead.

o Maintain accurate feature status in Quality Center during development by the agreed SLA.

o Verify build and deployment completeness of the features owned in the QA environment before making it Testing Ready in Quality Center.


o Analyze the feature requirements as presented by the business analyst and the delivery team, in context of the overall project feature set and existing implementation. Translate requirements to technical concepts.

o Help business analyst to refine and enhance initial requirements.

o Contribute to logical/physical data models, class diagrams, activity diagrams, sequence diagrams and UI prototypes.

o Responsible for organizing code review and obtaining sign-up on the code he/she delivered.

o Provide follow-ups and resolution to the issues raised on design and code reviews.

o Perform peer reviews on code and design as requested.

o Perform additional design tasks as assigned by team or tech lead.


o Responsible for documentation and audit artifacts as defined in SDLC and published standards.

o Provide documentation as appropriate to the Component Owner.

o Complete documentation in time with the release schedule and SLA agreed with team, tech or project lead.


o Test all code, content, build and unit test changes in the lowest environments first, if such environments exist.

o Develop Unit, Functional and System Integration (SIT) test plans.

o Execute and document Unit, Functional and SIT tests.

o Assist QA and production testing and deployment; assume ownership of the feature until passes successful Production Verification Test.

Project Description:

Assist with the Development and Architecture of new projects in the business intelligence space utilizing Microstrategy.

Physical Environment and Working Conditions:

• Ability to work on site in Wilmington, DE

• Must be able to demonstrate high degree of attention to detail, accuracy and deadlines.