Senior Business Intelligence Developer

Overview

At MoFo, we couldn’t write our own success story without yours. 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

About The Role

As a Senior Business Intelligence Developer, you will lead the design, development, and support of enterprise analytics solutions on the Strategy (MicroStrategy) 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.

Develop and Maintain Strategy Solutions (Finance)

• 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.

Ensure Data Integrity and Governance

• Partner with business owners and data engineers to define data quality rules, reconciliation checks, and validation processes.
• Build and maintain data quality monitoring dashboards and scorecards to track data health and issue resolution.
• Develop and maintain operational monitoring for Strategy jobs (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 participating in audits and compliance activities.

Special Projects and Platform Leadership

• Lead modernization and migration initiatives from legacy reporting tools to Strategy, ensuring functional parity, improved usability, and enhanced performance.
• Serve as the Strategy subject-matter expert for platform upgrades, patches, and environment changes, coordinating testing, documentation, and stakeholder communications.
• Collaborate closely with internal clients, IT, and Financial Systems to deliver effective reporting solutions and proactively develop new BI capabilities aligned with strategic goals.
• Mentor and review the work of developers and power users; contribute reusable components, standards, and automation (e.g., Strategy SDK/REST API, scripting) to improve team productivity.

Client Service, Confidentiality, and Safety

• Consistently model and promote the Firm’s Client Service Principles through leadership, collaboration, and high-quality work product.
• Ensure compliance with the Firm’s Information Handling Policy by safeguarding confidential and personal information and promptly reporting any suspected breaches.
• Adhere to the Firm’s General Safety Practices and all department- or building-specific safety requirements.

About You

• 7+ years of experience in data analysis and business intelligence, including 5+ years of MicroStrategy (Strategy) development in an enterprise environment.
• Advanced MicroStrategy expertise (Workstation/Developer), including:
  • Metadata and schema design
  • Metrics, dossiers, and report development
  • Security configuration (groups, ACLs, security filters)
  • Distribution Services (scheduling and distribution)
• Strong relational database and advanced SQL skills, including performance tuning and troubleshooting complex queries.
• Hands-on experience with BI SDLC best practices, including:
  • 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 BusinessObjects/Crystal Reports a plus, particularly 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 professional experience.
• Strong analytical, data modeling, and problem-solving skills, with expert-level SQL.
• Expertise in data visualization and storytelling for both technical and non-technical audiences.
• Demonstrated ability to manage multiple priorities in a fast-paced environment, with high attention to detail and data quality.
• Strong project management, stakeholder engagement, and communication skills, including interaction with senior leadership and C-level executives.
  

About Mofo

At MoFo, we collaborate as one firm, across borders, practice areas, and business functions and value fresh ideas and innovation over conformity and competition.

• About Us:
• Inclusion + Engagement:
• Commitment to Pro Bono:
• The MoFo Foundation:

About Our Benefits

MoFo offers a comprehensive benefits package starting on your first day.

• A variety of options for medical, dental, vision, life and disability coverage to meet the needs of you and your family.
• Industry-leading parental leave and family benefits including adoption and fertility treatment options and backup child and elder care.
• Global wellness program, including free access to Talkspace and Calm apps.
• Annual community service day to make an impact on your community and a birthday holiday just for fun.
• Education reimbursement annually.
• Dedicated Talent Development team.
• Competitive annual profit-sharing contribution.

Where required by law, salary ranges are stated below. Additional compensation may include a discretionary bonus, overtime as applicable, health/welfare benefits, retirement contributions, paid holidays, and PTO. The range displayed is specifically for positions performed in those cities/states and may vary based on factors including but not limited to the following: local market data and ranges; an applicant's skills and prior relevant experience; and certain degrees, licensing, and certifications. The application deadline is July 20, 2026.

New York, San Francisco, salary range: $128k to $179k

Boston salary range: $122k to $169k

Denver salary range: $114k to $159k

For questions regarding this position, please e-mail [email protected]