DEPARTMENT: Information Technology
REPORTS TO: VP of Systems Development and Applications
CLASSIFICATION: Exempt
SALARY: $100000 $110000 per year
DATE: May 2025
The Senior Applications and Database Analyst will lead the enterprise systems operations with a primary focus on Reporting and Ticketing applications. The day-to-day job responsibilities will include building and customizing reports on our enterprise business intelligence platforms SSRS and Power BI tools. The Senior Applications and Database Analyst will also work closely with the business units to determine where system improvements can be made in order to maximize the potential of enterprise systems and help deploy systems that will meet the business goals and will also be responsible for project management of various initiatives. This position requires an established technical and functional knowledge of working with enterprise databases and applications with an understanding of disaster recovery back up procedures and information security protocols.
ESSENTIAL FUNCTIONS
- Develop and maintain reports mainly using platforms such as Pentaho SSRS and Power BI to address organizational day-to-day reporting needs.
- Manage the portfolio of IT Enterprise and reporting applications and Point of Sale (POS) systems including Gateway Ticketing and Business Intelligence systems.
- Support and maintain high volume high availability production databases.
- Administer and support existing databases while ensuring optimized performance stability monitoring and uptime.
- Write scripts to automate various tasks that are currently performed manually by the Museum staff.
- Optimize database queries for reporting performance and accuracy.
- Manage/upgrade/install the POS systems in the Museum by working alongside the IT Applications team.
- Work closely with internal and external stakeholders to understand needs and requirements that can be solved through process and technology.
- Provide production support for all enterprise applications and provide subject matter expertise on related business processes and functionalities.
- Create comprehensive documentation on reporting and enterprise systems and other technical guides (training debug install etc.).
- Administer Gateway eGalaxy webstores according to IT and Admissions requirements.
- Work with vendors in procuring maintaining upgrading and modifying enterprise applications.
- Implement PCI and security compliances and disaster recovery and back-up procedures around enterprise platforms and applications by working with the server administration team members.
- Establish organization-wide operational procedures to ensure high stability and performance of enterprise applications.
VOLUNTEER REQUIREMENT
- Participate in the Annual 5K Fundraiser and September 11th Commemoration as assigned.
- Assist with other special projects and events in support of all 9/11 Memorial and Museum as assigned.
QUALIFICATIONS/SKILLS REQUIREMENTS
- Position requires a Bachelors or Masters degree in CS or IT or equivalent work experience.
- Professional certifications in relevant technologies are a plus.
- Deep knowledge of SQL and hands-on experience with MySQL and/or SQL Server databases.
- Demonstrated experience working with Pentaho or other Business Intelligence platforms with understanding of ETLs and automated scheduled jobs.
- Hands-on experience with creating and managing SSRS and Power BI reports.
- Experience with ticketing systems is preferred particularly with Gateway Ticketing Systems.
- Familiarity with front-end development (HTML CSS. JS) is a plus.
- Experience working with NoSQL databases is a plus.
- Able to navigate and utilize cloud platforms effectively.
- Minimum of 3 - 5 years of experience working with enterprise applications (preferably ticketing systems) in a cultural attraction or similar environment.
- Experience working with point-of-sale systems is an advantage.
- Ability to effectively manage multiple projects/tasks of varying complexities meet deadlines and work well under pressure.
- Ability to handle some of the database administrator responsibilities.
- Able to navigate and perform tasks in both Linux/Unix and Windows systems.
- Willingness to work non-traditional hours (weekend or late/early hours may be needed based on project timelines) think independently take initiative and meet deadlines.
- Ability to present complex technical information to both technical and non-technical audiences.
- JIRA and other project management software skills preferred.
- Must have strong communication organizational and problem-solving skills.
The National September 11 Memorial & Museum (9/11 Memorial & Museum) is an equal opportunity employer. Applicants who meet the qualification requirements of the role will receive consideration without regard to their race color religion sex sexual orientation age national origin disability status as a protected veteran or any other characteristic protected by applicable law. The 9/11 Memorial & Museum endeavors to make reasonable accommodations for applicants with disabilities and other accommodation needs under applicable law. If you are an individual with a legally recognized accommodation need and require assistance during the application process please contact Ronni Cantor at with your specific accommodation request.
The 9/11 Memorial & Museum is committed to an organizational culture that supports and reinforces our institutional values including our commitment to inclusive representation. We are committed to reflecting the unique experiences of the nearly 3000 victims who were killed indiscriminately in the 1993 and 2001 terroristattacks and the wider communities impacted in lower Manhattan at the Pentagon and near Shanksville PA.
Required Experience:
Senior IC