Business Intelligence Manager

JOB FUNCTIONS:

The Business Intelligence (BI) Manager is responsible for leading MPW’s Business Intelligence team, overseeing the design, development, and maintenance of BI solutions. This role ensures the delivery of accurate, actionable insights to support organizational goals. The BI Manager will manage a team of BI Developers while working directly with stakeholders to prioritize and deliver BI requests, resolve issues, and maintain MPW’s BI infrastructure.

ESSENTIAL FUNCTIONS:

Team Leadership

• Manage and mentor a team of three BI Developers, providing guidance, training, and career development.
• Assign, prioritize, and oversee BI development tasks, including new requests, enhancements, and bug fixes.
• Conduct performance reviews, one-on-one meetings, and team status updates.

BI Development

• Lead the design, implementation, and maintenance of BI solutions using Microsoft SQL Server, Reporting Services (SSRS), Power BI, SSIS, and Microsoft Fabric.
• Ensure accurate and timely delivery of dashboards, reports, and data visualizations to meet business requirements.
• Oversee the development and optimization of SQL databases, ensuring high performance and data integrity.

System Maintenance

• Perform SQL Server maintenance tasks, including backups, indexing, query optimization, and patch management.
• Monitor the performance and reliability of BI systems, proactively identifying and addressing potential issues.

Stakeholder Collaboration

• Work closely with stakeholders to gather requirements and translate them into actionable BI solutions.
• Provide training and support to internal users for self-service BI tools, including Power BI.
• Communicate complex technical concepts to non-technical audiences effectively.

Strategy and Governance

• Develop and enforce data governance best practices to ensure data quality, security, and consistency.
• Establish and execute a BI roadmap aligned with organizational goals and emerging technologies.

Documentation and Process Improvement

• Maintain documentation for BI systems, processes, and solutions.
• Identify opportunities for process improvements, including automation and advanced analytics adoption.

KEY BEHAVIORS:

• Customer Service: Proactively developing customer relationships both internal and external; anticipating and providing solutions to customer needs; giving high priority to customer satisfaction.
• Professionalism: Maintaining a high-quality professional appearance and standardizing to improve performance and reputation.
• Continuous Improvement: Refining and developing new tools and processes through creativity and innovation.
• Drive to Win: Passionate and candid; challenges are eagerly accepted, and motivated to grow.
• Spirit of Family: Treating all people with respect by supporting and giving back to employees, customers, and local communities. Promoting opportunities within and through referrals.

QUALIFICATIONS:

• Bachelor’s degree in computer science or a related field (or equivalent experience).
• Minimum of 8 years’ experience developing technical BI solutions with Microsoft tools. including Power BI, SSRS, and SQL Server.
• At least 2 years of experience in a leadership or management role overseeing technical teams.
• Proficient in Microsoft SQL Server database design, query optimization, and maintenance.
• Advanced experience with Power BI, including data modeling and dashboard development.
• Proficiency with SSIS for data integration and ETL workflows.
• Experience with Microsoft Fabric is a plus.
• Excellent written and verbal communication skills.
• Strong analytical and problem-solving capabilities, with attention to detail.
• Ability to manage multiple priorities and meet deadlines in a fast-paced environment.