Database Analyst (Assistant)

The Frick Collection•New York, NY

just now•$33 - $34•Onsite

About The Position

The Database Analyst supports the institution's data infrastructure by helping maintain, analyze, and report on information housed in our CRM (Raiser's Edge) and related systems. This role plays a key part in ensuring data accuracy and accessibility across departments, assisting with data imports/exports, and producing reports that inform institutional decision-making. The ideal candidate is detail-oriented, communicates well across teams, and is comfortable learning new tools and workflows.

Requirements

Knowledge of CRM database solutions, specifically Raiser's Edge
Familiarity with ecommerce and/or event ticketing systems
Strong reporting skills, with demonstrated ability to analyze and interpret data
Proficiency with Tableau for data visualization and reporting
Experience assisting with the maintenance of database solutions in a multi-department or institutional setting
Excellent written and verbal communication skills
Strong attention to detail and commitment to data accuracy
Ability to learn new systems and workflows quickly and independently
Experience importing and exporting data between database systems
Familiarity with Snowflake and AI tools (Claude)
Experience with other reporting tools (Crystal Reports, Microsoft Power BI and/or Power Automate)
Analytical mindset with strong problem-solving abilities
Comfortable working independently as well as collaboratively across teams
Organized, dependable, and able to manage multiple priorities
Curiosity and willingness to learn emerging tools and technologies

Responsibilities

Assist in the maintenance, upkeep, and integrity of database solutions used across the institution
Import and export data between systems, ensuring accuracy and consistency throughout the process
Build and maintain reports and dashboards that support data-driven decision-making
Analyze data trends and provide insights to relevant departments and stakeholders
Support database health and maintenance for various organization databases- including data entry or cleanup
Collaborate with staff across departments to understand reporting needs and translate them into actionable outputs
Assist with data related to ecommerce and/or event ticketing systems as needed
Learn and adapt to new systems, tools, and workflows as the institution's technology needs evolve
Maintain a high level of attention to detail when working with sensitive or high-volume data
Partner with cross-functional stakeholders to implement and uphold data governance policies, including data classification, vendor management, and quality standards across enterprise systems.

Benefits

14 paid holidays, all federal holidays including Juneteenth, and Election Day and four floating holidays
Up to 12 sick days and 15 vacation days their first year of employment, accruing up to 12 sick days and 25 vacation days/year in subsequent years
Paid bereavement and family leave
Health, Dental and Vision insurance for full-time employees and their eligible dependents
Short and Long Term Disability and Life Insurance (cost covered by the Frick)
Participation in a Tax Deferred Savings Plan – 403(b) and a defined benefit pension plan
Retiree health benefits
Wellness Programs including an Employee Assistance Plan, a discount on Citi Bike memberships and a discount on bike helmets
Discounted transit benefit
Flexible spending accounts for health, dependent care and commuting costs