Business Intelligence (MicroStrategy Dev), Sr.
At a glance
Senior Data Analysis & BI role at Mindlance. San Francisco · contract.
Pay not stated Data Analysis & BI salary
dataroles summary, based on the employer's posting.
What you'll do
- Design and build MicroStrategy solutions, from architecture and prototypes through development, to serve business needs
- Create reports, dashboards, documents and self-service reporting tools for users across business environments
- Tune BI reports and dashboards, using VLDB settings and SQL optimization to improve execution
- Move MicroStrategy objects through development, QA and production, with rollback plans for migration issues
- Gather project needs with cross-functional teams and train users on ad-hoc reporting and existing BI tools
What you bring
- At least five years building, implementing and supporting large-scale BI solutions with MicroStrategy 9.x or newer
- You can model ROLAP star and snowflake schemas and build MicroStrategy schema and application objects
- You can write complex SQL, find optimization opportunities and tune BI reports, documents and dashboards
Who this fits
This senior contractor role suits a hands-on MicroStrategy developer who can handle architecture, design and delivery. The role is onsite in San Francisco.
From the employer
Mindlance is a national recruiting company which partners with many of the leading employers across the country. Feel free to check us out at http://www.mindlance.com.
• A minimum of 5 years of experience development, implementation and operational support of large scale business intelligence solutions using Microstrategy 9.x and above.
• Deep business intelligence experience --Architect, design, & prototype solutions in Microstrategy products to support business strategies, deliver business value utilizing agile methodologies
• Owning all technical aspects of software development for assigned applications; Performing hands-on architecture, design, and development of systems
• Good understanding of ROLAP Star Schema modeling, Snowflake modeling, Fact, Lookup Tables, Physical and Logical Data Modeling.
• Expertise in creating Schema Objects (facts, attributes, User Hierarchies, Transformations) and Application Objects (filters, metrics, prompts, Custom Groups, Consolidations, Templates, Drill Maps) to Build Documents and reports
• Strong knowledge of Intelligent Cubes
• Expertise in creating MicroStrategy documents, Grid reports, dashboards, Visual Insights for various business environments and knowledge of all widgets to effectively visualize the data
• Experience in developing Ad-hoc interfaces enabling end-users to generate their own reports.
• Ability to performance tune reports/documents/dashboards and knowledge of utilizing VLDB property settings to achieve execution efficiency
• Experience in using Object Manager to migrate objects between development, QA and Production environment. Ability to roll back changes in case of any issues in the migrations.
• Experience in SQL coding, ability to understand and write complex SQL and identify SQL optimization opportunities.
• Works in cross functional teams to assist with gathering and evaluating detailed project requirements to support delivery of effective business intelligence and reporting solutions
• Willing to take the initiative to improve processes and resolve problems
• Ability to train the users for ad-hoc reporting and usage of existing BI solutions.
• Experience with big data technologies is a plus.
• Experience with retail domain is a plus.
Thanks & Regards
Ateeq Ahmed
470-20-1120
ateeqa@mindlance(DOT)com
Mindlance