Business Systems Manager

Business Systems Manager

The International Center of Photography (ICP) is the world's leading institution dedicated to photography and visual culture. Through exhibitions, education, public programs, and community outreach, ICP provides an open forum for dialogue about the power of the image. Since 1974, ICP has presented more than 700 exhibitions and offered thousands of classes at every level. ICP's integrated center on the Lower East Side brings the school and museum together in one space as a cultural anchor of Essex Crossing.

Position Summary

The Business Systems Manager supports ICP's business systems, CRM platforms, and institutional reporting infrastructure. Reporting to the Director of IT, this role partners with departments across the organization to analyze data, manage system integrations, develop reporting solutions, and improve data accessibility for operational and strategic decision-making.

This position plays a key role in strengthening ICP's reporting capabilities, data quality, system connectivity, and business intelligence functions. The Business Systems Manager serves as a primary resource for institutional reporting and works closely with Development, Marketing, Membership, Education, Public Engagement, Finance, and other departments to ensure data is effectively connected, interpreted, and leveraged across the organization.

Key Responsibilities

• Create, maintain, and optimize database objects from various CRM and business systems, including tables, views, functions, triggers, and stored procedures to support reporting and operational needs.
• Develop, maintain, and enhance dashboards, reports, and visualizations using Power BI and other reporting tools.
• Create and maintain SQL queries, semantic models, and data structures to support institutional reporting and analysis.
• Partner with stakeholders across departments to gather reporting requirements, develop dashboard solutions, refine ad hoc reporting requests, and translate business needs into actionable data insights.
• Serve as a subject matter resource on institutional data, reporting capabilities, and available system information.
• Ensure data accuracy, consistency, and integrity across reporting platforms and business systems.
• Serve as the primary technical resource for business system integrations and data connections between platforms including Raiser's Edge, HubSpot, AcmeTicketing, and other institutional systems.
• Develop and maintain standards for data quality, reporting documentation, and business system best practices to ensure consistency and reliability across institutional reporting.
• Develop and maintain processes for prioritizing reporting requests, managing project workloads, and supporting organizational workflow improvements through data-driven solutions.
• Collaborate with software vendors, CRM support teams, and internal stakeholders to troubleshoot issues and support organizational objectives.
• Document reporting processes, data sources, system integrations, and reporting definitions to support consistency and knowledge sharing across departments.

Core Competencies

• Ability to analyze complex data sets and translate findings into clear, actionable insights.
• Strong understanding of how data flows across multiple systems and applications.
• Commitment to data accuracy, integrity, and consistency.
• Ability to identify reporting gaps and recommend practical solutions.
• Strong cross-functional collaboration and stakeholder management skills.
• Ability to communicate technical concepts effectively to both technical and non-technical audiences.
• Strong project management, prioritization, and organizational skills.
• Ability to balance multiple projects and competing deadlines.
• Commitment to continuous improvement and process optimization.

Requirements

Specialized Knowledge, Licenses or Certifications required:

• Experience with Power BI, semantic models, Microsoft Fabric, and related business intelligence tools.
• Advanced SQL querying and data modeling experience.
• Advanced Microsoft Excel skills.
• Proficiency with Microsoft Office applications, including Word, Excel, Outlook, and Teams.
• Experience working with CRM platforms such as Raiser's Edge, HubSpot, AcmeTicketing, or similar systems.
• Microsoft, Power BI, SQL, or related certifications preferred.

Education Qualifications:

• Bachelor's degree in Data Analytics, Information Systems, Computer Science, Business Analytics, or a related field preferred.

Experience Qualifications:

• 4+ years of experience in data analysis, reporting, or business systems support
• Experience working with CRM systems and cross-functional stakeholders
• Strong analytical and problem-solving skills
• Ability to communicate technical concepts to non-technical audiences
• Ability to manage multiple priorities and deadlines
• Four (4) or more years of experience in data analysis, business intelligence, reporting, business systems administration, or a related field.
• Experience supporting CRM platforms and working with cross-functional stakeholders.
• Strong analytical and problem-solving skills with a focus on data governance and best practices.
• Experience developing dashboards, reports, and reporting solutions for operational and strategic decision-making.
• Demonstrated ability to manage multiple priorities and deadlines in a collaborative environment.

Working Conditions

Physical Demands:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

•The employee must frequently lift and/or move up to 25 pounds and occasionally lift and/or move up to 50 pounds.

•While performing the duties of this Job, the employee is regularly required to sit and talk or hear.

•The employee is occasionally required to stand and use hands to finger, handle, or feel and reach with hands and arms.

Compensation and Benefits

•Compensation Range: $68,000-$74,000 annually, commensurate with experience.

•ICP offers a comprehensive benefits package, including:

• Medical, dental, and vision coverage (with employer contributions and HRA support)
• Employer-paid life insurance, short- and long-term disability, and Employee Assistance Program
• 403(b) retirement plan with employer match up to 5% after one year
• Flexible spending accounts and pre-tax commuter benefits
• Generous paid time off, including vacation, sick time, personal days, holidays, floating holidays, and a birthday day off
• Free or discounted museum admission, staff discounts, and access to perks programs
• Professional development opportunities, including tuition-free ICP courses and discounted education programs for employees and dependents.

The International Center of Photography is committed to equal opportunity employment. We believe that diversity, equity, and inclusion are values that are integral to offering an open forum for dialogue around photography and visual culture that is open to all. Through this lens, we hope to engage, educate, and inspire our visitors, students, and community at large.