Associate II, Data Specialist

Position Title  Associate II, Data Specialist

Reports to       Director, Data & Integration

Classification  Non-Exempt

ABOUT AEF

American Endowment Foundation (AEF), headquartered in Hudson, Ohio, a suburb of Cleveland, is a nonprofit financial services organization and one of the largest independent, national donor-advised fund (DAF) sponsoring organizations.  Since its founding in 1993, AEF has been mission-motivated to expand philanthropy throughout the financial services industry and to communities across the country.

Through our DAF product and technology driven platform, individuals can donate, receive an immediate tax benefit, grow their investment, and make grants from the fund over time.

At AEF, our people-driven culture is at the heart of everything we do. Here philanthropy is personal, and we take an unbiased approach to charitable giving that honors our clients’ intent by directing their gifts and grants to the charitable causes that are important to them. Every day, we give our best to exceed expectations and make a lasting positive impact together.  

POSITION SUMMARY

The Data Specialist is a member of the American Endowment Foundation’s (AEF) Information Technology team. Under the guidance of the Director, Enterprise Solutions, this position is responsible for executing data processing functions to ensure accuracy, consistency and alignment with AEF’s business requirements and IT strategy. Responsibilities include collecting, storing, converting, and analyzing electronic data and maintaining high quality data standards in a variety of systems that make up the AEF application stack. This individual will work collaboratively with AEF departments to ensure the availability of data and the performance of databases.

ESSENTIAL RESPONSIBILITIES

1. Executes data processing in AEF systems to ensure accuracy, consistency, and quality.
2. Executes regular transactional processes necessary to maintain operations records and databases.
3. Performs extracting, importing, and exporting of data in various database applications.
4. Ensures compliance with Business and Data Governance rules.
5. Performs data reconciliations to identify data anomalies.
6. Assists in preparation of data reports, training materials, business presentations, publications, and other educational materials.
7. Performs data quantitative and qualitative analysis.
8. Creates standard reports for information reporting.
9. Assists with other data related projects as assigned by the Director, Data & Integration.

SKILLS AND QUALIFICATIONS

• Associates of Science or related degree required, or Bachelors of Science or related degree required 
• 2 or more years of analyst experience preferred
• Advance skills and experience with Microsoft SQL Server, Access databases, Excel and word
• Intermediate knowledge in database design and theories
• Extremely detail-oriented
• Strong problem-solving and analytical skills
• Strong communication skills, both written and oral