Job Description –
MicroStrategy BI Analyst. Sr. Developer
12 months
skype
Hybrid Washington DC
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 of DHS’s 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 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
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
Bachelor’s degree in IT or related field or equivalent experience
Skill Required / Desired Amount of Experience
5 Years Design MSTR BI/Analytics solution specifications based on business requirements.
5 Years Experience in testing of enterprise wide MSTR BI/Analytics applications.
Overall MIS / IT experience 11 Years
11 Years Technical Requirements gathering, analysis and modelling experience
8 Years Develop technical design documents
5 Years Hands on SQL code experience.
5 YearsExperience in testing of enterprise-wide BI applications preferably MicroStrategy
Interest/Familiarity on HTML5, CSS, JavaScript, NodeJS and Reac 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
From:
Anju Pathak,
Tek Inspirations LLC
anju.pathak@tekinspirations.com
Reply to: anju.pathak@tekinspirations.com