Microstrategy BI Developer

for Calance in Pasadena, CA

Microstrategy, BI, SDK, SQL 
Pasadena, CA
Area Code:
Travel Req:
Pay Rate:
Tax Term:
Position ID:
Dice ID:

The Business Intelligence (BI) Developer works collaboratively with product, engineering and business teams to develop a BI platform to build reports, perform analysis and data visualizations. The BI Developer will provide company wide data warehouse expertise with emphasis on data design, access, usage, security and quality of information assets. Using the MicroStrastegy suite the BI Developer will design and develop solutions that provide insights to our business, our customers, and our partners   Required knowledge and skills: End to end knowledge of business intelligence and data warehousing architectures 3+ years experience in MicroStrategy BI projects with full domain knowledge of the software Full domain knowledge of MicroStrategy software including report development and Meta Data development with certification preferred. Experience in MicroStrategy SDK for Authentication and UI Customizations. Experience with Microstrategy Administration functionality is a plus. Have a fundamental understanding of data management systems and processes within the ecosystem (source systems, data feeds, reference data management, ETL, Data Warehouses and Marts, data cube design, etc.) Thorough understanding of logical and physical database design principles, Data Warehousing architectures, techniques, and methodologies; including Star Schemas, Snowflake Schemas, and Aggregation Techniques 2+ years experience with structured programming languages like Java, C, C++. Very strong SQL skills with the ability to optimize, analyze, and improve database SQL performance preferably in Vertica. Experience in developing and tuning queries for ad hoc, canned reporting, and dashboard use, with back end system such as Vertica. Strong SQL development experience Appreciation and knowledge of the nuances and aesthetics of smart data presentation (scorecards, dashboards, and other advanced analytics) Experience working with customers to identify their BI needs and directly applying technology as a solution for both tactical and strategic problems. Mentor and train business staff so that they can achieve self-service using the developed MicroStrategy platform components. Lead performance tuning and stress testing initiatives. Experience to interacting with people from diverse backgrounds and different experience levels. Excellent analytical, logical and problem-solving skills Excellent spoken and written communication skills Self-motivated, quality-oriented, delivery-oriented, and able to self-prioritize work Ability to thrive in a fast-paced and changing environment


Andy Ballantyne
Phone: (800) 732-4680 ext: 709