Job Order #2828

Email this Job to a Friend
Posted Date: 5/15/2017
Job Category:
Position Title: Int/Snr MicroStrategy Developer
Salary Range: Commensurate with experience
Location: Toronto, Ontario, Canada
Desired Skills:
Description:

JOB DESCRIPTION
• Provide technical leadership and hands on experience with on solutions architecture, report development, security and data mart design
• Provide business intelligence subject matter expertise on workability of designs, architecture, and testing with regard to end user enablement and self-service.
• Recommend and implement solutions to achieve required business functions, which prove difficult to implement in MicroStrategy
• Lead and mentor other development team members and spread product knowledge to others to create depth within the team
• Work with Vendor to escalate and resolve any BI reporting related technical issues.
• Conceptualize, design and implement a MicroStrategy solution from existing data warehouse, and other enterprise data sources.
• Implement caching, partitioning and bitmap indexes to tune the application.
• Create a report style sheet in compliance with the clients report style guidelines.
• Create and implement basic report objects (ie: parameters, prompt types, descriptions, metric names, filters etc)
• Build reports and dashboards for deployment in a web based environment in accordance to pre-defined detailed report specifications and conduct the required unit testing.
• Play a key role developing project artifacts; business requirements document, detailed design document, and report specifications
• Prepare and execute test cases for unit and integration testing in development and UAT
• Assist the BI Architect in designing logical and physical dimensional data mart models
• Assist in initial performance tuning and recommend options as required
• Work closely with the Project Lead to ensure deliverables and milestones are achieved within the specified time-lines
• provide oral/written project status reports to the Project Lead on an ongoing basis

QUALIFICATIONS
• 5+ years’ experience as a MicroStrategy Developer
• Experience with complex MicroStrategy implementations
• Extensive experience building MicroStrategy projects referencing both a star schema containing atomic level data as well as de-normalized tables with aggregate data.
• Strong experience administering MicroStrategy (defining roles, security, expansion of additional tables, populating data mart tables)
• Extensive experience building MicroStrategy reports for dissemination through a in a web based environment.
• Strong knowledge of dimensional data modeling techniques and theory
• Knowledge of Ralph Kimball or Bill Inmon design theories
• Experience using ERwin or another data modeling tool an asset
• Knowledge of RDBMS concepts and technologies
• Experience writing SQL and PL/SQL
• Experience with the agile software development lifecycle and techniques
• MicroStrategy certification an asset
• Experience with an ETL tool (ideally SSIS, Informatica, DataStage) an asset
• Knowledge of ETL architecture and design an asset
• Experience providing training, knowledge transfer and mentoring.
• Ability to work with minimal direction and supervision
• Excellent interpersonal, facilitation, presentation and communication skills
• The ability to communicate complex information and issues to all levels of an organization



Share this job: