Job Title: Senior MicroStrategy Developer / Business Intelligence Specialist (HYBRID)
Location: Washington DC
Duration: 12 Months
Job Description:
This is a Long term position working in the Client and program teams in business intelligence and analytics to develop a longitudinal database.
Qualifications:
- Strong Experience with MicroStrategy familiarity with Tableau is helpful.
- Strong experience in writing SQL and good working knowledge on Oracle and SQL Server databases. Ability to perform data analysis troubleshoot data issues in comparison to report output.
- Experience on creating highly optimized Intelligent Cubes and Incremental Refresh experience
- Experience on various features on RSDs like selectors and writeback functionalities
- Bachelors degree in business management information systems computer science or an equivalent combination of skills training and experience
- Extremely good at comprehending analyzing data and its relationships
- 23 years of Data Visualization experience using MicroStrategy Dossier
- Good knowledge of Data Warehousing principles ETL processes and dimensional modeling concepts
- Excellent technical logical analytical and problemsolving skills to provide insight on development and application support
- Effective verbal and written communication skills with technical and nontechnical audiences
- Basic knowledge and interest in HTML5 CSS JavaScript NodeJS and React
- Must have the legal right to work in the United States
Responsibilities:
- The position is responsible for the design development and support the Client MicroStrategy Business Intelligence platform
- The individual will be required to participate in all SDLC phases and responsible for data modeling and MicroStrategy project metadata development
- The individual will frequently interact and assist with the adhoc reporting and access requests from agency users
- The individual should possess skills around relationships of data hierarchies and hybrid data models
- The position requires production support platform maintenance support and system enhancements support.
- The Individual is expected to have a thorough understanding of the business logic and data contained within every BI project while working on it
- Build MicroStrategy dashboards Report Services Documents and Reports both for Web and Library that satisfy and meet organization requirements/needs
- Collaborate with other teams to define dashboards and reporting solutions to meet diverse complex agency needs
- Experience working with Complex reports Report Services Documents (WriteBack) Dossier (dashboards) Metrics Filters builtin and user defined functions like If case running sum etc.
- High level of competence in creating complex Datamart reports and Transactional Datasets
- Ability to write custom SQL like selfjoin nested queries to troubleshoot complex data issues
- Training Users on the BI functionality and helping them in creating basic reporting objects within MicroStrategy
- Work with agency users and be able to comprehend their requests into possible solutions using the current BI platform
- Make small code changes on MicroStrategy Plugins or Connectors
- Coordinates IT project management engineering maintenance QA and risk management.
- Plans coordinates and monitors project activities.
- Develops technical applications to support users.
- Develops implements maintains and enforces documented standards and procedures for the design development installation modification and documentation of assigned systems.
- Provides training for system products and procedures.
- Performs application upgrades.
- Performs monitoring maintenance or reporting on real time databases realtime network and serial data communications and realtime graphics and logic applications.
- Troubleshoots problems.
- Ensures project lifecycle is in compliance with District standards and procedures.
Minimum Education/Certification Requirements:
- Bachelors degree in Information Technology or related field or equivalent experience
Skills
- 16 yrs planning coordinating and monitoring project activities
- 16 yrs leading projects ensuring they are in compliance with established standards/procedures
Skills:
Skills | Required / Desired | Amount | of Experience |
Design MSTR BI/Analytics solution specifications based on business requirements provided. | Required | 5 | Years |
Experience in testing of enterprise wide MSTR BI/Analytics applications. | Required | 5 | Years |
Overall MIS / IT experience | Required | 11 | Years |
Technical Requirements gathering analysis and modelling experience | Required | 11 | Years |
Develop technical design documents | Required | 8 | Years |
Hands on SQL code experience | Required | 5 | Years |
Experience in testing of enterprisewide BI applications preferably MicroStrategy | Required | 5 | Years |
Interest/Familiarity on HTML5 CSS JavaScript NodeJS and React | Desired | 3 | Years |
Development experience on Oracle and SQL Server databases | Desired | 4 | Years |
BI Tools certifications preferably MicroStrategy | Desired | | |