The Report Writer and Data Analyst is a valued member of the AIS-DS Gift Management team. This team is responsible for recording pledges and gifts; recording and maintaining alumni, donor and friend biographical information; researching and updating constituent data and training on data maintenance and governance requirements; independently communicates with University personnel and donors regarding IRS regulations and University Policies as they relate to charitable contributions for non-profit organizations.
The successful candidate will develop and maintain expert knowledge of the business rules for how University Advancement manages giving and donor records. He/she/they will work with UA and IT stakeholders to understand business goals and requirements to quickly deploy reports and analytics in Cognos that enable better decision making. This role will also be responsible for translating/developing reports based on user requirements and an in-depth understanding the reporting frameworks that are created by the BI Architect.
The Report Writer and Data Analyst will provide development, testing, and support throughout the report development lifecycle.
Reporting to the Director of Gift Management, key responsibilities of the Report Writer and Analyst include, but are not limited to the following:
Characteristic Duties and Responsibilities
Utilize Cognos Analytics Reporting Tool to execute reports, dashboards, and ad hoc query extracts that deliver on Gift Management reporting needs.
Work directly with BI Technical and Applications Programming Teams
Produce and coordinate queries and reports for unit deployment activities, integrity, and monthly reporting
Provide support and best practices for the Gift Management team, including Executive Leadership and fundraising staff
React quickly to changing business demands
Create and provide training and onboarding to new staff
Create and maintain data dictionary, business rules and procedures relevant to department
Other duties as assigned
Work on special projects as defined in collaboration with the Director, AVP, and University Advancement Management
Unit Specific Education/Experience/Skills
Knowledge normally acquired in the first two or three years of college, technical or vocational or business school such as an Associates Degree in computer technology or information systems, with coursework in an information technology specialization related to the area of employment; one – two years of related and progressively more responsible or expansive work experience in an information technology field OR Bachelors Degree in computer science or information systems, with coursework in an information technology specialization; up to six months of related and progressively more responsible or expansive work experience in an information technology area; or an equivalent combination of education and experience.
Degree in Computer Science, Information Technology or knowledge equivalent to that which normally would be acquired by completing a four year college degree program with similar relevant coursework; 3-5 years of specialized training in data entry/processing, advance skills for Microsoft Office Suite, Cognos Analytics and Advance Web, Salesforce, or UCI ascend CRM. Experience in a professional environment. Ability to manage, prioritize, and perform multiple tasks in a professional manner. Willingness to learn new skills or technologies. Ability to evaluate potential changes in process or procedure and embrace changes which emerge as applicable; a flexible attitude is an asset. Professional person with excellent customer service skills and attitude; interpersonal, organizational, analytical, and problem solving skills; strong ability to organize, prioritize, and work independently; a detail oriented, self-directed individual, able to juggle a variety of responsibilities and manage these under pressure; ability to discreetly handle confidential information and material with complete discretion; ability to provide exceptional customer service willingness and ability to take initiative, be flexible, learn quickly, and function as a member of a team with common goal of site success.
Equal Employment Opportunity Statement
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, citizenship, disability or protected veteran status.
Required Application Materials
Resume and Cover Letter
Work hours are 8 AM to 5 PM with some nights and weekends
Bidding and Eligibility Ends on 9/15/2020 at 11:55 PM
Spartans work every day to advance the common good in uncommon ways.Together, we tackle some of the world?s toughest problems to find solutions that make life better?from alternative energy to better food safety to breakthrough medical and environmental applications achieved through rare isotope research.We teach. We explore and we discover. We collaborate and lead. We innovate, inspire, and empower. We achieve our potential and create circumstances that help our students and others achieve theirs.We're good at it, and we've been at it for more than 150 years.The nation?s pioneer land-grant university, MSU began as a bold experiment that democratized higher education and helped bring science and innovation into everyday life. The revolutionary concept became a model for the nation.Today, MSU is one of the top research universities in the world?on one of the biggest, greenest campuses in the nation. Home to nationally ranked and recognized academic, residential college, and service-learning programs, we?re a diverse community of dedicated students and scholars, athletes and artists, scientists and leaders.In ways both practical and profound, we work to create a stronger, more sustainable, and more hopeful future for all.