Business Systems Analyst

American Museum of Natural History

New York (NY)

On-site

USD 80,000 - 90,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical insurance

Vision insurance

401(k)

Pension plan

Job summary

A renowned cultural institution in New York is seeking a Business Systems Analyst to support data-related projects and strategies. This role requires strong SQL and Excel skills, along with data analysis experience. The ideal candidate will ensure data integrity and contribute to system improvements. Offering competitive salary and benefits, this position is well-suited for those with a background in Information Technology. Join us to make a significant impact on our educational programs.

Qualifications

At least 3 years of experience in programming (ideally SQL, VBA, C# & .Net), data analysis, system analysis, design and implementation.
Advanced working knowledge of Excel and MS SQL.
Working knowledge of online data collection tools.

Responsibilities

Interpret and evaluate user needs, gather and analyze relevant data.
Develop and maintain relationships with end-users.
Monitor systems to ensure data integrity, consistency, and accuracy.

Skills

SQL

VBA

Data analysis

System analysis

Data visualization

Excel

Education

High School Diploma or equivalent

Bachelor’s degree in Information Technology or Computer Science

Tools

MS SQL

VBA

Excel

Job description

Join to apply for the Business Systems Analyst role at American Museum of Natural History.

American Museum of Natural History provided pay range

This range is provided by American Museum of Natural History. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$80,000.00/yr - $90,000.00/yr

The American Museum of Natural History is one of the world’s preeminent scientific and cultural institutions, and has as its mission to discover, interpret and disseminate information about human cultures, the natural world and the universe through a wide-ranging program of scientific research, education and exhibition.

The Education department is seeking a Business Systems Analyst who will play a primary role in supporting projects with data-related needs and supporting strategy development for the collection, analysis, management, and communication of data and metrics to all stakeholders. The Analyst will ensure the quality and integrity of data from multiple sources throughout the museum and will generate reports and analysis that rely on this data as needed. This position will particularly focus on programs that serve children and youth ages 2-21.

Responsibilities

Interpret and evaluate user needs, gather and analyze relevant data and develop these into appropriately detailed system workflows or new application requirements.
Develop and maintain relationships with end-users to understand requirements.
Review and analyze the effectiveness and efficiency of existing systems and develop strategies for improving or further leveraging these systems.
Define components, interfaces, modules, data, and architecture for applications to satisfy specified requirements.
Create and maintain documentation for workflow, operating procedures and system administration.
Contribute technical skills to projects such as the implementation of business intelligence and data visualization tools, MS SQL database and data warehouse development, ETL processes, statistical analysis, Excel automation through VBA, etc.
Assist in day-to-day coordination of entering and updating program participants and their application and enrollment data into multiple internal database applications for approximately 2,500 students annually.
Monitor systems to ensure data integrity, consistency and accuracy.
Create compelling quarterly reports that demonstrate key attributes of students reached.

The expected salary range for the Business Systems Analyst is $80,000/annual – $90,000/annual. The AMNH offers an extensive benefits package designed to meet the needs of our dedicated and diverse community.

Pay will be determined based on several factors. The hiring range for the position at commencement is based on the type of work and the scope of responsibilities. The salary and placement offered is based on a number of individualized factors, including, but not limited to, skills, knowledge, training, education, credentials, areas of specialization and depth and scope of experience.

Minimum Qualifications

High School Diploma or equivalent.
At least 3 years of experience in programming (ideally SQL, VBA, C# & .Net), data analysis, system analysis, design and implementation.
Advanced working knowledge of Excel and MS SQL.
Working knowledge of online data collection tools.
Familiarity with Business Intelligence and data visualization tools.

Preferred Qualifications

Bachelor’s degree in Information Technology, or Computer Science.
A certification in SQL or other programming language(s).
Working knowledge of Access.
Working knowledge of VBA.
Familiarity with CRM systems.

Physical Demands

Must be able to remain in a stationary position (sitting or standing) for prolonged periods.
Must be able to occasionally lift up to 20 pounds.
Must be able to move about the Museum campus.

Job Details