Microstrategy Developer

<\/span><\/span><\/span><\/span>
<\/p>

Key Responsibilities<\/b>
<\/h2>
  • Design and develop MicroStrategy reports, dashboards, documents, and dossiers<\/b>.
    <\/p><\/li>

  • Create and manage schema objects<\/b> including facts, attributes, hierarchies, transformations, and metrics.
    <\/p><\/li>

  • Design and optimize data models, star/snowflake schemas<\/b>, fact tables, and dimension tables.
    <\/p><\/li>

  • Work closely with data engineering teams to validate and enhance table structures and data integrity<\/b>.
    <\/p><\/li>

  • Develop and integrate Python scripts<\/b> for data processing, automation, and reporting enhancements.
    <\/p><\/li>

  • Perform SQL query optimization<\/b> and performance tuning.
    <\/p><\/li>

  • Handle schema updates, project configuration, and metadata management<\/b> in MicroStrategy.
    <\/p><\/li>

  • Troubleshoot production issues and provide timely resolutions.
    <\/p><\/li>

  • Collaborate with business stakeholders to understand reporting requirements and translate them into technical solutions.
    <\/p><\/li>

  • Ensure best practices in BI development, documentation, and version control.
    <\/p><\/li><\/ul>


    Required Skills<\/b>
    <\/h2>
    • Strong hands\-on experience in MicroStrategy Architecture & Development<\/b>.
      <\/p><\/li>

    • Expertise in Schema Objects (Facts, Attributes, Hierarchies, Tables, Joins, Transformations)<\/b>.
      <\/p><\/li>

    • Solid understanding of Data Warehousing concepts<\/b> (Star Schema, Snowflake Schema).
      <\/p><\/li>

    • Strong knowledge of Fact & Dimension table design<\/b>.
      <\/p><\/li>

    • Proficiency in Python<\/b> for data manipulation and automation.
      <\/p><\/li>

    • Advanced SQL skills<\/b> (query writing, performance tuning).
      <\/p><\/li>

    • Experience working with relational databases such as Oracle, SQL Server, MySQL, PostgreSQL<\/b>, etc.
      <\/p><\/li>

    • Knowledge of MicroStrategy Intelligence Server and project deployment.
      <\/p><\/li>

    • Strong analytical and problem\-solving skills.
      <\/p><\/li><\/ul>


      <\/div><\/span>

      Requirements<\/h3>

      JOB DESCRIPTION<\/u><\/i>
      <\/span><\/span><\/span><\/span><\/p>

      Key Responsibilities:<\/span>
      <\/span><\/span><\/span><\/span><\/p>

      1. MicroStrategy Schema Development:<\/span>
      <\/span><\/span><\/span><\/span><\/p>

      • Design and develop MicroStrategy Universes (Schema Objects) including Attributes, Facts, Hierarchies, and Transformations.<\/span>
        <\/li>
      • Create Attributes, Facts, and Metrics to support business reporting needs.<\/span>
        <\/li>
      • Develop and maintain Logical and Physical Data Models in MicroStrategy.<\/span>
        <\/li><\/ul>

        2. Report & Dashboard Development:<\/span>
        <\/span><\/span><\/span><\/span><\/p>

        • Design and build Reports, Dashboards, and Documents using MicroStrategy Web, Desktop.<\/span>
          <\/li>
        • Optimize report performance by implementing best practices such as indexing, caching, and partitioning.<\/span>
          <\/li>
        • Create and manage Intelligent Cubes to improve report performance.<\/span>
          <\/li><\/ul>

          3. Metadata & Security Management:<\/span>
          <\/span><\/span><\/span><\/span><\/p>

          • Configure MicroStrategy Security Filters, Roles, and User Privileges.<\/span>
            <\/li>
          • Implement Data\-Level and Object\-Level Security for controlled access.<\/span>
            <\/li>
          • Manage MicroStrategy Projects and Object Migration across environments.<\/span>
            <\/li><\/ul>

            4. ETL & Data Integration:<\/span>
            <\/span><\/span><\/span><\/span><\/p>

            • Work with SQL, Data Warehouses, and ETL teams to ensure data accuracy and consistency.<\/span>
              <\/li>
            • Integrate MicroStrategy with various databases (Teradata, MS\-SQL Server, etc.).<\/span>
              <\/li><\/ul>

              5. Performance Optimization & Troubleshooting:<\/span>
              <\/span><\/span><\/span><\/span><\/p>

              • Conduct performance tuning and troubleshooting of reports and dashboards.<\/span>
                <\/li>
              • Ensure best practices in data visualization and reporting.<\/span>
                <\/li><\/ul>

                6. Collaboration & Documentation:<\/span>
                <\/span><\/span><\/span><\/span><\/p>

                • Work closely with business users, data analysts, and BI teams to gather requirements and deliver effective solutions.<\/span>
                  <\/li>
                • Document design specifications, business logic, and development processes.<\/span>
                  <\/li><\/ul><\/div><\/span>

                  Benefits<\/h3>

                  About Company : www.tislabs.in<\/a>
                  <\/span><\/span><\/span><\/span><\/p>

                  TIS Labs Pvt. Ltd. has been the No. 1 service provider in India for IT Infrastructure including Consulting, Implementation and Support. Incorporated in 2010 started as a small Specialist in Linux & Open Source based Systems Integration & Services. Since 2010 TIS labs has evolved in Virtualization solutions, Mail solutions, Data management , High Performance Computing, IT infrastructure security and IT Consulting. Working with highly qualified engineers supporting globally 24*7. TIS Lab offers capabilities to design, build, migrate, integrate and manage state\-of\-the\-art Linux & Open\-Source solutions at the server side infrastructure that is tailor\-made to suit the business needs. TIS Lab solutions ensure security, flexibility and scalability in the environment apart from significantly reducing CAPEX and OPEX.<\/span>
                  <\/span><\/span><\/span><\/span><\/p>

                  Why Join Us?
                  <\/span><\/span><\/span><\/span><\/p>

                  • Innovative Environment: Work with cutting\-edge technology and a forward\-thinking team.<\/span>
                    <\/li>
                  • Career Growth: Opportunities for professional development and career advancement.<\/span>
                    <\/li>
                  • Competitive Benefits: Comprehensive benefits package, including health insurance and paid time off.<\/span>
                    <\/li>
                  • Dynamic Culture: A collaborative and inclusive work culture that values diversity and innovation.<\/span>
                    <\/li><\/ul><\/div>

                    <\/div><\/span>