The Role
Design, develop, test, and troubleshoot MicroStrategy reports, dashboards, and intelligence cubes. Perform dimensional modeling, metadata creation, advanced SQL scripting, performance tuning, security role and scheduling setup, and manage report lifecycle and automated distribution services.
Summary Generated by Built In
Company Description
Sarian Solutions Inc.
Trusted Partner for your all IT Needs.
Job DescriptionJob Title: Microstratgey Developer
Location: NJ/NYC
Duration: Full-Time
Job Description:
- Understanding of End to End BI/DW Development and Operations Life Cycle
- Analyze requirements, write functional and technical specifications, development of reports
- Prepare and conduct Unit testing
- Should have good knowledge on BI principles, SQL
- Excellent written and verbal communication skills
- Dimensional Modeling understanding.
- Experience of handling complex business requirements in BI reporting and creating intuitive design solutions
- Good conceptual knowledge and working experience on meta data creation framework models Report Development Concepts
- Good experience on reporting tool Microstrategy
- Aggregate Layer hands-on,
- MSTR Desktop advanced reports,
- MSTR Narrowcast Services,
- MSTR Intelligence Cube reports,
- MSTR Web Professional,
- Advanced Metrics, Filters, Custom Group, Consolidation and other application objects,
- MSTR performance tuning,
- DB advanced SQL scripting,
- MSTR report troubleshooting,
- Created security roles, schedules, subscription, User’s and Group’s with their desired privileges as per the requirement.
- MSTR Desktop Architect, Attributes, Facts, Hierarchy, Transformation, Logical table partition (Schema Objects)
- Having experience on Creation of Custom Groups, Attributes, Consolidations, Facts, Filters, Attributes and Metrics, Prompts.
- Having experience on creating of MicroStrategy Reports, Dashboard, scorecards, reports performance tuning.
- Created Transmitters, Devices and User for Automated Distribution Services through Desktop and Web.
- Have loaded and unloaded the project.
- write back to source data based on analysis by business users
- Performance Tuning / Improvement
- Knowledge of the Product Suite, their architecture and details of the components of the individual products in the suite
- Report development lifecycle
- Report Testing Concepts.
Looking forward to hear & work with you soon.
Thanks & Regards
Mohammed Riyaz
Sarian Solutions, Inc.
an IT solutions company
Work: 732-790-2266 x 201|Fax: 732-790-0944
E: Riyaz(AT)sariansolutions.com | G: riyaz.ross(AT)gmail.com
W: www.sarianinc.com
Skills Required
- Understanding of end-to-end BI/DW development and operations life cycle
- Analyze requirements, write functional and technical specifications, develop reports
- Prepare and conduct unit testing
- Excellent written and verbal communication skills
- Knowledge of BI principles and SQL
- Dimensional modeling understanding
- Experience handling complex business requirements in BI reporting and creating intuitive design solutions
- Conceptual knowledge and working experience on metadata creation framework models and report development concepts
- Hands-on experience with MicroStrategy reporting tool
- Experience with Aggregate Layer
- MSTR Desktop advanced reports
- MSTR Narrowcast Services
- MSTR Intelligence Cube reports
- MSTR Web Professional
- Advanced metrics, filters, custom groups, consolidations and other MicroStrategy application objects
- MicroStrategy performance tuning
- Database advanced SQL scripting
- MicroStrategy report troubleshooting
- Create security roles, schedules, subscriptions, users and groups with appropriate privileges
- MSTR Desktop Architect: attributes, facts, hierarchies, transformations, logical table partitions (schema objects)
- Creation of custom groups, attributes, consolidations, facts, filters, metrics, and prompts
- Create MicroStrategy reports, dashboards, scorecards and perform report performance tuning
- Create transmitters, devices and users for automated distribution services via Desktop and Web
- Load and unload MicroStrategy projects
- Write-back to source data based on business user analysis
- Performance tuning and improvement
- Knowledge of the MicroStrategy product suite architecture and component details
- Report development lifecycle and report testing concepts
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Sarian Solutions Inc. is a global information technology and business solutions provider specializing in IT consulting and staffing services. The company delivers comprehensive business solutions using digital technologies including cloud, mobile, security, and data analytics. As a trusted partner, they empower businesses of all sizes to achieve digital transformation through custom software development, strategic guidance, and global talent acquisition.
