Power Business Intelligent Architech

Familiar with the MicroStrategy architecture, Admin Certification Preferred

· Familiar with administrative functions, using Object Manager, Command Manager, installation/configuration of MSTR in clustered architecture, applying patches, hot-fixes

· Monitor and manage existing Business Intelligence development/production systems

· MicroStrategy installation, upgrade and administration on Windows and Linux platform

· Ability to support and administer multi-tenant MicroStrategy infrastructure including server security troubleshooting and general system maintenance.

· Analyze application and system logs while troubleshooting and root cause analysis

· Work on operations like deploy and manage packages, User Management, Schedule Management, Governing Settings best practices, database instance and security configuration.

· Monitor, report and investigate solutions to improve report performance.

· Continuously improve the platform through tuning, optimization, governance, automation, and troubleshooting.

· Provide support for the platform, report execution and implementation, user community and data investigations.

· Identify improvement areas in Environment hosting and upgrade processes.

· Identify automation opportunities and participate in automation implementations

· Provide on-call support for Business Intelligence issues

· Experience of working on MSTR 2021, MSTR 2021 including knowledge of working on Enterprise Manager and new features like Platform Analytics, Hyper Intelligence, Collaboration, MSTR Library, etc.

· Familiar with AWS, Linux Scripting

· Knowledge of MSTR Mobile

· Knowledge of capacity planning and system’s scaling needs

• You would be responsible for Developing SQL Databases, automation of business reports and Developing Business Dashboard using BI Tools.
• Development of high quality database solutions 
• Create complex functions, scripts, stored procedures and triggers to support application development.  
• Develop, implement and optimize stored procedures and functions using T-SQL
• Review and interpret ongoing business report requirements
• Build appropriate and useful reporting deliverables
• Analyze existing SQL queries for performance improvements
• Fix any issues related to database performance and provide corrective measures.  
• MIS Automation
• Provide timely scheduled management reporting
• Create Business dashboard using Tableau BI Tool

Requirement / Desired Skills:

• 5+ years of business Analyst / SQL developer experience in Fintech,internet,consulting etc industry
• Excellent understanding of T-SQL programming
• Excellent understanding of Microsoft SQL Server 
• Good knowledge of HTML and JavaScript 
• SQL Server Reporting Services and SQL Server Analysis Services
• Knowledge of any of the BI Tool (Tableau, PowerBI or Qlikview)

• Experience in Developing QlikView / Qlik Sense BI visualizations and dashboards. QlikSense and NPrintiing experience is a must.
• Strong knowledge of building Qlik Sense dashboards applying business rules and data validations.
• In-depth understanding of Qlik Sense Server Architecture, building QVDs and QVFs, applying business rules and data validations.
• Familiarity with charts and graphs, creating complex visualizations for dynamic aggregation Good Knowledge of Incremental data loading concepts and data modeling.
• Additionally, Qlik developers have to troubleshoot issues and provide the necessary solution

JD of the Scrum Master.

Along with Scrum Master we need couple of BI developers skilled in Power BI with 3-4 Years of relevant experience in BI and 1+ years of experience in Power BI.

• Responsible for handling the scrum process in a POD structure with coordination of POD team and product owner in Agile methodology
• Supporting the Product Owners to groom and maintain the product backlog in good shape and make them ready for the next sprint
• Facilitating discussion, administrating, and conflict resolution to get the work done including monitoring, tracking and communication to relevant stakeholders.
• Follow the scrum rituals such as sprint planning, daily scrum, stand-up meetings, facilitate & scheduled meetings, demo, decision-making process etc.

  Competencies

• Overall 2-4 years of IT project management and delivery experience with 2+ years of Scrum Master experience in data analytics projects
• Ability to take and understand the commitment to deliver the product on time
• Applicable knowledge of the technologies used by the team, for example in Data Analytics/Data Science area
• Planning and problem solving with product management and delivery teams
• Certified Scrum Professional

• 4+ years of extensive EXP in TIBCO SPOTFIRE Dashboard Development is MUST
• Design and create data visualizations in TIBCO Spotfire
• Proven EXP in delivering Spotfire solutions to advance business goals and needs.
• Detailed knowledge of TIBCO Spotfire - report developer configuration
• EXP on creating all charts that exist in Spotfire (scatter, line, bar, combo, pie, etc.) and how to manipulate every property associated with a visualization (trellis, color, shape, size, etc.)
• EXP in writing efficient SQL queries, views in relational databases such as Oracle, SQL Server, Postgres and BigQuery (Optional).
• Ability to incorporate multiple data sources into one Spotfire DXP and have that information linked via data table relations.
• EXP with Spotfire Administrative tasks, load balancing, installation/configuration of servers and clients, upgrades and patches would be a plus.
• Strong background in analytical visualizations and building executive dashboards.
• In-depth knowledge & understanding of BI and Datawarehouse concepts