Microstrategy Architect

Microstrategy Architect

Duration: 6 Months+ Location: Springfield, NJ

The Data Warehouse and Business Intelligence group is responsible for providing actionable insights into various aspects of the business to drive value and support improvements within the business. DW and BI group focus areas include Merchandising, Supply Chain, ECOM, Customer Analytics, Finance and many others.

Responsibilities

• Design and develop data models to support ongoing and new reporting initiatives through data analysis, data discovery and requirements gathering.
• Work in collaboration with Data Warehouse Data Integration team in developing the data models and validate the data to ensure it meets the defined business rules.
• Architect MicroStrategy schema and work closely with other team members to support reporting needs.
• Closely work with report developers to help them understand the architecture and provide necessary solutions.
• Develop reports and dashboards using MicroStrategy as part of POC to validate design.
• Migration of MicroStrategy objects between environments as needed to support existing MicroStrategy Administrator.
• Troubleshoot and optimize existing MicroStrategy reports as part of support activities.
• Evaluate and test new features of MicroStrategy before they are rolled out to end users.
• Working closely with other infrastructure teams to assist in software upgrades.
• Work with cross-functional teams on the day-to-day execution of data & analytics projects and initiatives.
• Produce dynamic data driven analytic solutions to support the strategic goals of the company.
• Develop process improvements, analytical frameworks, share expertise with others, mentor and continually strive to improve overall contributions to the department.
• Help MicroStrategy Administration team in automating manual tasks.

Requirements

• At least 8 years of experience with MicroStrategy and at least 5 years of recent experience as MicroStrategy Architect.
• Advanced skills in development of attributes, facts, dimensions, transformations, grids and Dashboards in MicroStrategy.
• Ability to understand complex multidimensional business source systems and provide with Dimensional Data Models for reporting.
• Experience working with the full life cycle BI reporting development process, which includes analysis, design, construction, testing and post implementation support.
• Strong SQL skills with ability to optimize as needed on various database platforms primarily on Teradata and Netezza.
• Willingness and the ability to closely work with User community, DBAs, ETL developers, and the project team in general.
• A flexible analytic approach that allows for results at varying levels of precision.
• Prior working experience in the area of Retail Industry is preferred.
• The ability to communicate complex quantitative analysis in a clear, precise and actionable manner.
• Possess excellent verbal and written communication skills, attention to details, and the ability to multi-task.
• Ability to work independently and as a team with strong analytical and interpersonal skills.
• Be detail-oriented and comfortable with a fast-paced, structured, retail environment.

Required Knowledge

• Expertise knowledge in latest versions of MicroStrategy BI tool suite.
• Advanced knowledge with database tools.
• Expertise knowledge in SQL.
• Domain experience in retail business is preferred.
• Experience with MicroStrategy Administration is preferred.
• Experience in other BI tools a plus