Reporting to the Director of Applications, the Systems Architect is responsible for managing and maintaining mission-critical database systems that support key programs within External Relations, Membership and Visitor Services, Finance, Purchasing and Human Resources. Building upon these responsibilities, the Systems Architect serves as the key individual at the Museum for fitting these systems together by developing an Applications Architecture, defining overall data and process flow models and implementing data exchanges between the disparate MFA systems and between the MFA systems and those operated by MFA business partners. In addition, the Systems Architect is the driving technical force behind Data Warehouse and Business Analytics dashboards and reporting efforts at the Museum.
• Responsible for specifying the technical platform and for the integration of the Tessitura Ticketing, Membership and Development applications with all other MFA and vendor systems.
• Define the MFA Applications Architecture and maintain a current Applications Inventory and supporting documentation. Produce and maintain a data flow diagram documenting the movement of data between systems.
• Lead the integration of application data into a unified data reporting environment in support of Business Analytics efforts at the Museum.
• Ensure all supported applications are PCI Compliant.
• Champion the use of agile and waterfall application development methodologies, improved testing, better documentation and the use of Microsoft Team Foundation Server as our definitive source code library. Represent the Museum at relevant IT conferences and seminars.
• Research, and if necessary, develop and support new applications as necessary. Write and debug table creation scripts, stored procedures, application code and reporting tools.
• Assist in the support and operation of the Tessitura Ticketing, Membership and Development application.
• Assist in the support of SQL Server-based software including TMS, EMS, PaperFlow and SenSource; and Oracle-based software including Oracle Financials, Oracle Human Relations and Malibu.
• Monitor industry trends and new developments in data base and application capabilities, especially Tessitura and the Oracle Financials application suite, to allow for their use in enhancing the capabilities of the MFA systems. Represent the Museum at relevant IT conferences and seminars.
• Bachelor’s Degree in MIS or Computer Science and 5-7 years experience or Bachelor’s Degree in another field and 7-10 years experience.
• 3-5 years experience developing and integrating custom and third-party applications into a coherent operating environment.
• Demonstrated expertise in Data Base Administration and Data Base Management Systems, especially SQL/Server and Oracle.
• Proficiency in multiple programming languages and with Data Warehouse concepts and tools.
• Familiarity with IT standards and Information Security standards.
• Excellent written, oral and graphical communications skills.
• Superior attention to detail.
• Ability to multi-task and lead multiple software development projects.
For immediate consideration please submit cover letter and resume to: email@example.com
35.00 hours per week
September 5, 2017