Senior Systems & Data Analyst

Posting Number S01319JP

Department Development Operations

Job Summary

The Development and Alumni Relations ( DAR ) Senior Systems and Data Analyst ( SSDA ) partners with DAR and College departments who utilize data from DAR’s Constituent Relationship Management ( CRM ) system and other DAR function-specific software applications in meeting fundraising and outreach/engagement objectives by providing system and data analytical, technical, and educational support for the storage, access, analysis, extraction and reporting of meaningful advancement information. The SSDA develops and maintains a data warehouse and utilizes various application data extraction tools and reporting platforms to provide highly-specific philanthropic financial, prospect, event, volunteer, relationship, biographical, membership, communication, and engagement reporting for a wide range of audiences and purposes.

Essential Functions:

• Receives and manages a high-volume of deadline-critical data requests from DAR and College department staff.

• Performs data extraction, manipulation, and validation/reconciliation, and builds reports using CRM application tools (query/export), data warehouse systems and MS databases ( SQL , Excel, Access), and reporting platforms (Powerbi, Crystal Reports).

• Partners with assigned ‘Primary Program Areas’ on cyclical and new initiatives to define the most effective and efficient use of system data and processes to track progress and drive strategic action.

• Provides ongoing customer support and education of data and processes for DAR staff as well as sharing in the system, data and process ‘training’ required to onboard newer IS Analysts and assist/collaborate with projects.

• Owns, designs, develops, and maintains the DARIS data warehouse for the purpose of efficient and flexible access to significant and consistent DAR data.

• Produces operational reports and data extraction for both internal departments and external

organizations that are required on a weekly, monthly, quarterly and annual basis.

• Fully participates in the implementation of function-specific DAR (or College-wide) application systems, especially from the perspective of integration with the DAR CRM . Builds exports and imports for system customizations and integrations and validates data accuracy on a regular basis.

  Education/Skills Requirements

Bachelor’s degree or equivalent experience required.

Solid understanding of relational database file structure, design and management concepts as they relate to application software systems. Strong data extraction, reporting, and validation skills using various tools with the ability to learn and adapt to new technical tools as they evolve. Thorough knowledge of MS Excel, Access and SQL . Excellent analytical and organizational skills with attention to detail and commitment to accuracy. Creative problem-solving skills. Effective verbal and written communication skills. Ability to clearly document technical and operational processes. Ability to translate business requirements into effective technical solutions. Ability to manage multiple projects and tasks at the same time cooperatively with others in a fast-paced environment

and under pressure of deadlines and interruptions. Sensitive to and accepting of confidentiality requirements.

Experience Requirements and/or Equivalents

Minimum of 7 years of information systems data analyst experience, preferably in a sophisticated academic fundraising environment and preferably with the Raiser’s Edge enterprise system (Raiser’s Edge certified if possible); extensive experience with query, export and report-writing software, preferably Crystal Reports; extensive experience requiring the use of Access and Excel; experience with accounting procedures; interest in and experience with training and working with people who have a wide range of computer skills.

Standard Work Days and Hours

Hours are primarily Monday through Friday; 8:30 am to 5:00 pm with occasional work after 5:00 pm or weekends. Minimal travel required. This is an exempt position requiring time commitment necessary to satisfactorily complete job requirements.

Benefits and Pay: (FT)

• The salary range for this position is expected to be: $74,500- $81,500 .

• A variety of health insurance plans (Medical, Vision, Dental)

• Generous Retirement Plan – 10.12% annual compensation contribution (Eligible after 1 year of service and age 26)

• Life and Disability Insurance

• Paid time off – Vacation, Personal, Holidays, and Special Days Off Paid parental leave.

• Free fitness and wellness classes!

• And more: https://www.bowdoin.edu/hr/benefits-perks/index.html

  About Bowdoin

Bowdoin embraces diversity in all forms, and the College is home to talented students, faculty and staff—with a variety of racial, ethnic, cultural, and socioeconomic backgrounds; religious beliefs; and gender identities, among other factors.

We encourage applications from candidates committed to the support of an inclusive campus community and those who will enrich and contribute to the College’s multifaceted diversity. We value a community in which individuals of all backgrounds are warmly welcomed and encouraged to succeed.

Founded in 1794, Bowdoin has maintained its commitment to the liberal arts for well over 200 years. Bowdoin’s reputation as a preeminent liberal arts college rests on the excellence of its faculty, students, and staff; intimate size; strong sense of community; and connections to the people, history, and natural beauty of Maine.

Bowdoin’s campus is situated in a beautiful natural setting. Located in Brunswick, Maine, a town of approximately 20,000, the College is a short drive from the Maine coast, twenty-five miles from Portland and 120 miles from Boston.

Shift

Employment Category Full Time Year Round

FTE 1.00

Benefits Eligible Yes

Pay Type Salaried

Background Check Package Requirements Administrative Staff + Credit

Is driving a vehicle (e.g. Bowdoin vehicle or off road vehicle, rental car, personal car) an essential function of this job? No

Is a pre-placement physical required for this position? No

Posting Date 09/06/2024

Applications Accepted Until

Open Until Filled No

Type of Posting Internal/External

Special Instructions to Applicants

EEO Information

Bowdoin College complies with applicable provisions of federal and state laws that prohibit unlawful discrimination in employment, admission, or access to its educational or extracurricular programs, activities, or facilities based on race, color, ethnicity, ancestry and national origin, religion, sex, sexual orientation, gender identity and/or expression, age, marital status, place of birth, genetic predisposition, veteran status, or against qualified individuals with physical or mental disabilities on the basis of disability, or any other legally protected statuses.

Supplemental Questions