MicroStrategy Engineer

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

Primary Job Duties:

• Work with stakeholders and user groups to understand the business needs/objectives and translate them to technical design requirements
• Participate in technical solution design and development activities, proactively communication risks, and provide potential alternatives for consideration
• 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
• Assist Network and Server teams with necessary logs for troubleshooting issues, when needed
• Conduct peer reviews of work products produced in MicroStrategy by other team members
• Collaborate with other team members to create optimal, maintainable, and scalable architecture
• Provide recommendations for performance improvements to deliver optimal results
• Assist with testing efforts for MicroStrategy platform upgrades including major and minor patch releases
• Perform migrations using Object Manager
• Help maintain roles, groups, folders, projects, etc.
• Create and maintain subscriptions
• Assist in the ongoing development of technical best practices for data movement, data quality, data cleansing and other ETL-related activities

Requirements

• MicroStrategy Certified Developer or MicroStrategy Certified Engineer credentials is highly preferred
• 3+ 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
• MicroStrategy 11x experience is required
• Experience with Integrity Manager, Command Manager, Object Manager, and Security Administration
• Experience with MicroStrategy Administration including installation, configuration, and performance tuning
• MicroStrategy SDK experience is a plus, but not required
• Proficient in writing and understanding SQL is required
• Demonstrated experience with translating business requirements into reporting solutions
• Bachelor’s in IT or quantitative field is preferred
• Experience using RDBMS, such as SQL Server and Snowflake
• Ability to consistently produce clear and concise status updates
• Ability to handle multiple concurrent projects and tasks
• Experience in a healthcare is preferred, but not required
• 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 $92,00.00-$115,000.00 in base pay and exclusive of any bonuses or benefits. This role is also eligible for an annual bonus targeted at 15%. The base pay offered will be determined based on relevant factors such as experience, education, and geographic location.