MicroStrategy Developer

Location: Media, PA - 4 days a week onsite and Fridays remote

Anyone applying for the role must include 1 professional reference that has a work email address and a LinkedIn profile. Local candidates will get preference but they will do video interviews for non-locals.

Position Summary

Our client is seeking an experienced MicroStrategy Developer to support a key marketing analytics initiative. This individual will work closely with business, analytics, and data engineering teams to understand reporting needs and deliver scalable, production-ready business intelligence solutions.

The ideal candidate will have strong hands-on MicroStrategy development experience, advanced SQL skills, and the ability to translate complex business requirements into effective reporting and analytics solutions.

Responsibilities

• Design, develop, enhance, and maintain MicroStrategy Dossiers, Reports, Dashboards, Documents, metrics, filters, prompts, and related BI assets.
• Build and maintain MicroStrategy metadata, schema objects, attributes, facts, hierarchies, transformations, and semantic/reporting layers.
• Develop, validate, and optimize complex SQL queries, database views, stored procedures, cubes, and reporting data structures.
• Partner with business analysts, product owners, data engineers, and stakeholders to gather requirements and translate them into technical solutions.
• Integrate and validate data from multiple sources to ensure reporting accuracy, consistency, and usability.
• Troubleshoot MicroStrategy, data, and performance issues across development, testing, and production environments.
• Support testing, defect resolution, deployment validation, and production support activities.
• Create and maintain technical documentation and provide knowledge transfer as needed.
• Analyze reporting requirements, identify data dependencies, and recommend appropriate technical approaches.
• Work independently to deliver high-quality analytics solutions within established timelines.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, Data Analytics, or a related field, or equivalent professional experience.
• 5 years of hands-on MicroStrategy development experience.
• Strong experience developing MicroStrategy Dossiers, Reports, Dashboards, Documents, metrics, filters, and prompts.
• Experience with MicroStrategy schema design, metadata management, and troubleshooting.
• Advanced SQL skills with experience writing, tuning, and troubleshooting complex queries against large datasets.
• Experience with relational or cloud data platforms such as Oracle, SQL Server, PostgreSQL, Snowflake, Teradata, or similar technologies.
• Strong understanding of data warehousing and dimensional modeling concepts, including star and snowflake schemas, facts, dimensions, and aggregate structures.
• Ability to gather and analyze requirements, identify data dependencies, and clarify technical assumptions.
• Strong analytical, troubleshooting, documentation, and communication skills.
• Ability to communicate effectively with both technical and non-technical stakeholders.

Preferred Qualifications

• Experience working in Agile/Scrum environments.
• Prior consulting or contract experience.
• Experience supporting production analytics and business intelligence environments.
• Ability to ramp up quickly and work independently in a fast-paced environment.