Senior Business Intelligence Developer

Job Summary

As a Senior Business Intelligence developer, you'll understand complex data models and Schema layers to implement complex BI solutions with a keen focus on the healthcare and wellbeing industry. Your SQL skills will play a significant role in data manipulation and delivery, and your extensive experience with MicroStrategy will be vital for creating BI tools and reports. This role will help migrate and build new analytics products based on MicroStrategy to support teams with their internal and external reporting for Health Comp data.Role & responsibilities

Required Knowledge, Skills, and Abilities

• Expert in writing complex SQL, including pivots, window functions, and complex date calculations and able to teach these concepts to others.
• Detail oriented and able to examine data and code for quality and accuracy.
• Self-Starter taking initiative when inefficiencies or opportunities are seen.
• Deep understanding of modern relational and non-relational models and differences between them
• Good understanding of Datawarehouse concepts, snowflake & star schema architecture and SCD concepts
• Develop Schema objects in MicroStrategy
• Develop Public objects in MicroStrategy
• Develop complex reports and dashboards using OLAP and MTDI cubes
• Optimize report performances using VLDB settings
• Maintain and deploy packages across different environments
• Create Python and command manager scripts in MicroStrategy
• Good understanding of project and server level governance settings
• Develop security filters and connection mappings in MSTR

Experience

• 4-8 years of experience in Business Intelligence and Data warehousing
• 4+ years of experience in MicroStrategy architecture and Dashboard development
• 4-8 years of experience in SQL
• Nice to have Any MicroStrategy certifications

Location:

Noida, Remote