Responsible for supporting and extending the business requirements and creating complex MicroStrategy report and dashboards. Will be responsible for quality assurance testing and debugging of the organization's business intelligence applications. This includes thorough testing of MicroStrategy metadata/reports/dashboards. Leverage strong conceptual and technical knowledge of MicroStrategy administration, architecture, software components, design, development, and integration best practices to develop impactful BI solutions.
RESPONSIBILITIES:
- Create, maintain and share reporting applications for the enterprise
- Publish standardized application and report objects and promote from development into the enterprise environment.
- Metadata modeling
- Work with SQL developer to get the queries for reporting purposes
- Work with business to analyze business metrics requirements and determine if they can be developed in reports/dashboards
- Customize attributes and metrics for Business Intelligence analysis
- Document customization in technical and business formats
- Work with users to document reports/dashboards and establish a documentation scheme
- Team lead for MicroStrategy support for users.
- Provide training and support for MicroStrategy users
- Promote the use of MicroStrategy software for analysis
- Assists in verification of data accuracy within reports/dashboards.
- Designs and creates test plans that are designed to find errors, ensure information meets requestor's specifications, and ensures a quality implementation with no negative impact
- Executes test plans, ensuring that data meets business and technical requirements for ensuring quality implementation.
- Helps to debug program / system errors found in testing.
- Provides technical assistance by responding to inquiries from others regarding errors, problems, or questions about reports and programs.
- Performance tuning and troubleshooting
- May be required to assist in project implementation teams.
- Other duties as assigned
REQUIREMENTS:
- Bachelor's degree in Computer Science, Information Technology or related field is desired but not required.
- A minimum of five years of experience in MicroStrategy business intelligence reporting tools is required.
- Experience in MicroStrategy report/dashboard development and usage is a must, preferably in version 10 and above.
- Experience reporting over JD Edwards ERP database strongly preferred.
- Position requires exposure to good development and testing methodologies.
- Applicant must have excellent PC/Computer skills including knowledge of word processing and spreadsheet applications.
- Hands-on report development experience using MicroStrategy, versions 10.0 and higher with version 2020 preferred.
- Experience in development of MicroStrategy attributes, metrics and intelligent cubes required
- Full understanding of the MicroStrategy reporting platform including:
- Experience architecting and managing MicroStrategy applications end to end
- All tools in the MicroStrategy Suite, including Developer, Library (version 2019 and higher), and Web
- MicroStrategy's functionalities and capabilities, such as visualizations, dossiers, documents, cubes, and so on
- Administration of MicroStrategy:
- Creating Users
- Organizing and updating security, granting access to different folders
- Promoting reporting objects from development to production environment.
- Experience with IBM iSeries DB2 and system strongly desired
- Advanced Microsoft Excel skills
- Advanced knowledge of relational databases