MicroStrategy Engineer

Overview of the Role:

The Senior MicroStrategy Engineer is a key contributor to Privia’s Corporate Analytics team in developing reporting solutions on our MicroStrategy BI platform. Areas of focus include MicroStrategy report/dashboard development, architecture, and administration. This position interfaces with Privia’s IT and Product Development teams on data layer interdependencies in addition to the duties listed below.

We are seeking a highly skilled MicroStrategy engineer with extensive experience in the MicroStrategy platform. The ideal candidate will have a deep understanding of MicroStrategy’s technical aspects and be capable of leveraging the platform to deliver robust and scalable business intelligence solutions.

Primary Job Duties:

• Work with stakeholders and user groups to understand the business needs/objectives and translate them to technical design requirements
• Lead technical solution design and development activities, proactively identify risks, and provide potential alternatives for consideration
• Generate solution documentation for design, training, and support purposes
• Build and maintain MicroStrategy schema objects (Attributes, Facts, Hierarchies, Tables, Views, etc.) as well as MicroStrategy application objects (Metrics, Filters, Templates, etc.)
• Create advanced reporting objects (Level Metrics, Consolidations, Custom Groups, FreeForm SQL Reports, etc.) when required to meet requirements
• Develop reporting solutions in MicroStrategy leveraging Dossiers, Report Services Documents (RSDs), Cubes, Reports, and Transaction Services
• Help field user questions and troubleshoot production issues and defects
• Analyze data and present findings in a consumable format to business users
• Facilitate power-user and end-user training
• Assist Network and Server teams with necessary logs for troubleshooting issues, when needed
• Conduct peer reviews of work products produced in MicroStrategy
• Mentor other team members and guide them on MicroStrategy development best practices
• Collaborate with other team members to create optimal, maintainable, and scalable architecture
• Provide recommendations for performance improvements to deliver optimal results
• Plan and manage testing efforts for MicroStrategy platform upgrades including major and minor patch releases
• Perform migrations using Object Manager
• Manage and maintain roles, groups, folders, projects, etc.
• Create and maintain schedules for different types of subscriptions
• Implement monitoring and alerting solutions for critical components of the MicroStrategy platform
• Assist in the ongoing development of technical best practices for data movement, data quality, data cleansing and other ETL-related activities

Requirements

• Bachelor’s in IT or quantitative field is preferred
• MicroStrategy 11x experience is required
• MicroStrategy Certified Developer or MicroStrategy Certified Engineer credentials is preferred
• Demonstrated experience with translating business requirements into reporting solutions
• Proficient in writing and understanding SQL
• 4+ years of experience with MicroStrategy project architecture and schema design
• 3+ years of experience with MicroStrategy Dossier, Dashboard (RSD), and Report development
• 2+ years of experience with MicroStrategy Transaction Services and Freeform SQL development
• 2+ years of experience with MicroStrategy Administration including installation, configuration, and performance tuning
• Experience with Integrity Manager, Command Manager, Object Manager, and Security Administration
• MicroStrategy SDK experience is a plus, but not required
• Experience using RDBMS, such as SQL Server and Snowflake
• Ability to consistently produce clear and concise status reports
• Ability to handle multiple concurrent projects and tasks
• Experience in a healthcare is preferred
• Must comply with all HIPAA Rules and Regulations

Interpersonal Skills & Attributes:

• Proactive and professional customer service skills as well as a positive and flexible attitude to work with internal business stakeholders
• Communicates clearly and effectively to build confidence and trust with business stakeholders, management, and peers (internal and external)
• Ability to prioritize tasks and work independently and with a team in a fast-paced and high volume environment with emphasis on accuracy and timeliness

The salary range for this role is $100,800.00-$126,000.00 in base pay and exclusive of any bonuses or benefits. This role is also eligible for a comission based incentive plan and restricted stock units. The base pay offered will be determined based on relevant factors such as experience, education, and geographic location.