Business Intelligence Lead (Microstrategy/Pentaho) - ClickSoftware
service edge banner

Business Intelligence Lead (Microstrategy/Pentaho)

Job Overview

The Business Intelligence Lead's primary responsibility is to design and develop BI solutions for Xora's product offerings.


ClickSoftware, Inc. #72, 2nd & 3rd Floor, Unituys Technology Center, Intermediate Ring Road, Domlur, Bangalore- 560 071

Position Duties

  • Co-Ordinate and work towards implementation of the design with MIS and Engineering team based in Bangalore, India.

  • Drive data & platform architecture for flexible and self-service reporting by internal customers

  • The person will be responsible for successful definition and implementation of enterprise-wide architecture for business intelligence & Data Warehousing.

  • Produce high quality design and code without much supervision

  • Define and propagate the best practices to write high quality database software and the related processes

  • Conduct feasibility studies and prototypes for integrating latest BI features in the Xora products

  • Troubleshoot and fix production tickets based on priority and take tactical and strategic actions

  • Track the advances in building scalable hosted solutions dealing with large amount of customer data; propose and implement the relevant new technology features in Xora products

  • Mentor other team members on the latest technology

Required Skills/Experience

  • B.Tech/M.Tech in computer science with 6+ years of progressive relevant experience

  • Must have 4+ years overall Business Intelligence & Data Architecture experience.

  • 4+ Years of development experience in Microstrategy.

  • Experience in creating MicroStrategy Schema and application objects such as Logical tables, attributes, facts, Hierarchies, metrics, prompts, filters, consolidations and custom groups

  • Must have experience in Pentaho (or similar) ETL tools

  • Must have extensive understanding of structured data analysis using SQL databases as well as atleast on of the larger scale processing using open-source technologies

  • Experience of working in Solaris and Linux environments; hands-on experience of writing shell scripts to accomplish various tasks

  • Must have worked on designing and developing near real-time reporting solutions for high transaction database solutions

  • Strong experience with improving performance and scalability of hosted/large enterprise applications using applicable techniques like caching, distribution, partitioning etc.

  • Excellent communication (verbal & written), interpersonal, collaboration, and problem solving skills

  • Experience with Change management software SVN or CVS.

Desired Skills/Experience

  • Experience with Sales reporting, Finance & commission analysis, Site User/Usage analysis in SaaS application services environment is a definitive plus

  • Hands on experience on database programming (ORACLE/SQL SERVER)

  • Experience of working with other relational (such as MySQL) and non-relation databases will be a great plus

  • Experience with SaaS applications is a great plus

  • Experience with cloud computing is a great plus

How to Apply

Interested applicants can submit their resume/CV by clicking here.
Or email Tejal Sujeeth at with cc'd and the job title in the subject.

Ready to transform your business? So are we.

Get started