MicroStrategy Developer (Near / Offshore)

Blue.cloud Inc; United States; Remote; USD 85,000 - 120,000; Full time

Job summary

A leading company in BI solutions is seeking a MicroStrategy Developer to design and optimize enterprise-level data architecture. In this role, you will work directly with business stakeholders to define KPIs, refactor reports, and improve performance using MicroStrategy tools and SQL. Candidates should have experience in data modeling and a strong understanding of the data warehouse concepts.

Qualifications

• Experience in designing and maintaining BI data architecture with MicroStrategy.
• Proficiency in SQL and data modeling techniques.
• Ability to collaborate effectively with stakeholders to define metrics.

Responsibilities

• Design, develop, and maintain enterprise-level BI data architecture using MicroStrategy.
• Collaborate with stakeholders to prioritize KPIs and optimize data layers.
• Refactor existing reports for better performance using MicroStrategy.

Skills

SQL

Data Modeling

Data Warehousing Concepts

MicroStrategy Tools

Performance Optimization

Collaboration with Business Stakeholders

Job description

• MicroStrategy Developer
  • Design, develop, and maintain enterprise-level BI data architecture and solutions using MicroStrategy tools and technologies, data modeling and warehousing concepts, and SQL programming.
  • Build and maintain the schema objects and abstraction layer
  • Create, publish, and optimize a data layer
  • Collaborate with business stakeholders to identify and prioritize KPIs and metrics, including maintaining data ecosystems, sourcing analytics expertise
  • Refactor reports developed using other tools to be scheduled, generated, and published using MicroStrategy server.
  • Modify existing reports and/or develop new reports by analyzing databases, data sources, and structures for the benefit of Users.
  • Optimize SQL queries and database structures for performance and scalability, including identifying and resolving performance bottlenecks, optimizing database indexes, and tuning SQL queries
  • Utilize data warehouse concepts including Star/Snowflake, Normalization, and Slowly Changing Dimensions.