Senior Business Intelligence Developer

Overview

Ready to write your story? Join MoFo as a SENIOR BUSINESS INTELLIGENCE DEVELOPER on our Business Intelligence & Analytics team! This role can be based in San Francisco, Denver, Boston, or New York.

As a Senior Business Intelligence Developer, you will lead the design, development, and support of enterprise analytics solutions on the Strategy (Micro Strategy) platform. You will partner with Finance and other stakeholders to translate requirements into secure, performant dossiers, dashboards, reports, and automated distributions; maintain and enhance the Strategy metadata and semantic layer and drive modernization efforts from legacy reporting tools to strategic BI platforms.

You will mentor other developers, establish development standards, and collaborate with Data Engineering and Technology Services to ensure high data quality, governance, and reliable production operations.

• Design, build, and enhance Strategy dossiers, dashboards, and reports using prompts, filters, drill paths, and guided navigation.
• Partner with data architects and engineers to develop and maintain Strategy schema and metadata objects (attributes, facts, hierarchies) and reusable enterprise‑aligned metrics.
• Implement scheduling, subscriptions, alerts, and thresholds using Strategy Distribution Services to deliver timely insights.
• Manage the full analytics object lifecycle, including development, testing, documentation, and promotion to production using packaging, migration, and change management best practices.
• Optimize performance through SQL and VLDB tuning, intelligent cube design, caching strategies, and proactive troubleshooting of production issues.
• Promote self‑service analytics by standardizing templates and visual standards, training users, and consulting on KPI definition and dashboard design.

• Partner with business owners and data engineers to define and implement data quality rules, reconciliation checks, and validation processes.
• Build and maintain data quality dashboards and scorecards to monitor data health and issue resolution.
• Develop and operate monitoring for Strategy jobs, including cube builds, refreshes, and distributions.
• Create and maintain runbooks for incident response, troubleshooting, and continuous improvement.
• Support data governance by documenting data definitions and lineage, enforcing access controls, and supporting audits and compliance activities.

• Lead migration and modernization of legacy reporting to Strategy, ensuring functional parity while improving usability and performance.
• Act as the Strategy subject‑matter expert for upgrades and environment changes, coordinating testing, documentation, and stakeholder communications.
• Partner with internal clients, IT, and Financial Systems to deliver effective reporting solutions and develop new BI capabilities aligned with strategic goals.
• Mentor developers and power users, establishing reusable components, standards, and automation (e.g., Strategy SDK/REST API, scripting) to improve productivity.

• 7+ years of experience in data analysis and business intelligence, including 5+ years of enterprise Micro Strategy (Strategy) development.
• Advanced Micro Strategy expertise (Workstation/Developer), including metadata and schema design, metrics/dossiers/reports, security configuration (groups, ACLs, filters), and Distribution Services.
• Strong relational database and expert‑level SQL skills, including performance tuning and complex query troubleshooting.
• Hands‑on experience with BI SDLC best practices: dev/test/prod promotions, change control, and documentation.
• Exposure to Strategy REST APIs/SDKs, automation, or embedded analytics preferred.
• 3+ years of Tableau development experience (Desktop, Server, or Cloud).
• Familiarity with Power BI and SAP Business Objects/Crystal Reports a plus, especially for BI platform migrations.
• Experience with Elite 3E or legal/financial systems strongly preferred.
• Bachelor’s degree in Computer Science, Information Systems, Accounting, Business, or equivalent experience.
• Strong…