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
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
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.
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