What are the responsibilities and job description for the MicroStrategy BI Developer position at InterSources Inc.?
Job Details
Address: Washington DC, 20002 (Onsite)
Hybrid - 3 days week / Office
12 Months Contract Position
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
Responsibilities
* The position is responsible for the design, development, and support of client's 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
Responsibilities:
- 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.
Bachelor's degree in Information Technology or related field or equivalent experience
| Skill | Required No. of Years | Actual Years of Experience |
| Design MSTR BI/Analytics solution specifications based on business requirements provided. | 5 | |
| Experience in testing of enterprise wide MSTR BI/Analytics applications | 5 | |
| Overall MIS / IT experience | 11 | |
| Technical Requirements gathering, analysis and modelling experience | 11 | |
| Develop technical design documents | 8 | |
| Hands on SQL code experience | 5 | |
| Experience in testing of enterprise-wide BI applications preferably MicroStrategy | 5 | |
| Interest/Familiarity on HTML5, CSS, JavaScript, NodeJS and ReactJS | Desired - 3 | |
| Development experience on Oracle and SQL Server databases | Desired - 4 | |
| BI Tools certifications preferably MicroStrategy | Desired | |
| B.S. in Engineering, IT, Business, or related field of study | 4 |
If you are interested in this exciting opportunity, please submit your updated resume to or Contact
About Us:
InterSources Inc. is a Small, Woman, and Minority-Owned Business Enterprise, ISO/IEC 27001, SOC 2 Type 2 certified company with massive 18 years of diversified experience in providing IT Consulting Services, Artificial Intelligence, Data Analysis, Application Development, Cloud Services, Cybersecurity, Digital Marketing, ERP Management, Custom Software Development, Web Development, UI/ UX Design, System Integration, QA Support etc. We make reasonable accommodations for clients and employees, and we do not discriminate based on any protected attribute including race, religion, color, national origin, gender sexual orientation, gender identity, age, or marital status. We also are a Google Cloud and Oracle partner company.
