Note: This position requires a cover letter for consideration. Refer to the “How to Apply” section of the job description for details. Applications without a cover letter will not be considered.
POSITION OVERVIEW
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 Bachelor’s or Master’s 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.
HOW TO APPLY
- Include job title in the email subject field.
- Please indicate the location where job posting was seen.
- Please submit a resume and cover letter to [email protected]
____________________
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 [email protected] 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 3,000 victims who were killed indiscriminately in the 1993 and 2001 terrorist attacks and the wider communities impacted in lower Manhattan, at the Pentagon, and near Shanksville, PA.
Job Type: Full-time
Pay: $100,000.00 - $110,000.00 per year
Benefits:
- Dental insurance
- Employee assistance program
- Flexible spending account
- Health insurance
- Paid time off
- Parental leave
- Retirement plan
- Vision insurance
Schedule:
Ability to Commute:
- New York, NY 10281 (Required)
Ability to Relocate:
- New York, NY 10281: Relocate before starting work (Required)
Work Location: In person
