Sr. Business Intelligence Developer

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.
Essential Functions/Responsibilities/Duties

• Review, understand, estimate the complexity of, and communicate incoming questions regarding the tools that they support
• Review and refine ambiguous business requests and produce technical requirement documents by using communication skills and collaborating with requesters
• Prioritization of work using an understanding of business needs, and an understanding of the technical complexities involved in meeting those needs.
• Participation in sprint refinement, planning, and kick-off to help estimate stories and clarify requirements.
• Develop necessary transformations and aggregate tables required for the reporting\Dashboard needs
• Develop Schema layer in MicroStrategy by understanding the data model and business requirements
• Develop complex reports and Dashboards in MicroStrategy
• Work on Report SQL optimization
• Investigate and troubleshoot issues with Dashboard, reports, Data, and tables
• Proactively researching new technologies and proposing improvements to processes and tech stack
• Create test cases and scenarios to validate the dashboards and maintain data accuracy

Education and Experience

• 5-8 years of experience in Business Intelligence and Data warehousing
• 5+ years of experience in MicroStrategy architecture and Dashboard development
• 5-8 years of experience in SQL
• Bachelors or masters degree in IT or Computer Science or ECE.
• Nice to have – Any MicroStrategy certifications

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