Sr Dev MicroStrategy BIAnalyst

Position Title & Code: MicroStrategy BI/Analyt. Sr. Dev.

Location: Washington DC 20003

Short Description:

The client is looking for a resource to provides assessments of technical and operational practices based on leading industry standards specific to the MicroStrategy and similar BI tools/environments to support DCAS.

Complete Description:

This is a long term position working in the DHS Economic Security Administration (ESA) Division of Data Analytics Research and Evaluation (DARE) supporting the DARE and DCAS 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 of DHSs DCAS Government 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


Responsibilities:
1. Coordinates IT project management engineering maintenance QA and risk management.
2. Plans coordinates and monitors project activities.
3. Develops technical applications to support users.
4. Develops implements maintains and enforces documented standards and procedures for the design development installation modification and documentation of assigned systems.
5. Provides training for system products and procedures.
6. Performs application upgrades.
7. Performs monitoring maintenance or reporting on real time databases realtime network and serial data communications and realtime graphics and logic applications.
8. Troubleshoots problems.
9. 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
Bachelors degree in IT or related field or equivalent experience

Skill Assessment: (Please include the years of experience last used and brief description on skills below information is to be submitted along with the resume)

Skill

Required / Desired

Amount of Experience

Years Used

Short Brief Description

Project

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

B.S. in Engineering IT Business or related field of study

Required