MicroStrategy Developer (Near / Offshore)

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

Job summary

A leading technology company in the United States is seeking a skilled MicroStrategy Developer to design and maintain enterprise-level BI data architecture. Responsibilities include collaborating with business stakeholders, optimizing SQL queries for performance, and utilizing data warehouse concepts. Ideal candidates will have experience in SQL programming and data modeling. Competitive compensation offered.

Qualifications

• Experience in designing and developing BI data architecture.
• Strong SQL programming skills.
• Familiarity with data warehouse concepts.

Responsibilities

• Design and maintain BI data architecture using MicroStrategy.
• Collaborate with stakeholders to optimize KPIs and metrics.
• Optimize database structures for performance.

Skills

MicroStrategy tools

SQL programming

Data modeling

Data warehousing

Performance optimization

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.