Senior MicroStrategy Developer / Business Intelligence Specialist (HYBRID)
Serigor
Contract
On-site
Washington, District of Columbia, United States
Development
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 Supporting and program teams in business intelligence and analytics to develop a longitudinal database.
Qualifications:
Responsibilities:
Minimum Education/Certification Requirements:
Skills
Skills:
Location: Washington, DC
Duration: 12 Months+
Job Description:
This is a Long term position working in the Client Supporting 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 write-back functionalities
- Bachelor’s 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
- 2-3 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 problem-solving skills to provide insight on development and application support
- Effective verbal and written communication skills with technical and non-technical 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 ad-hoc 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 (Write-Back), Dossier (dashboards), Metrics, Filters, built-in 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 self-join, 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, real-time network and serial data communications, and real-time graphics and logic applications.
- Troubleshoots problems.
- Ensures project life-cycle is in compliance with District standards and procedures.
Minimum Education/Certification Requirements:
- Bachelor’s 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. | 5 | Years | |
| Experience in testing of enterprise wide MSTR BI/Analytics applications. | 5 | Years | |
| Overall MIS / IT experience | 11 | Years | |
| Technical Requirements gathering, analysis and modelling experience | 11 | Years | |
| Develop technical design documents | 8 | Years | |
| Hands on SQL code experience | 5 | Years | |
| Experience in testing of enterprise-wide BI applications preferably MicroStrategy | 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 |