The mission of University Advancement is to secure support for Michigan State University in terms of money, talent, service and advocacy by delivering an integrated program of communications, marketing and engagement. Our objective is to build deep and long-term relationships with alumni, stakeholders and potential partners that will ensure increased support in the future.
The Data Quality Analyst is a valued member of the AIS-DS Gift and Record Management team. This team is responsible for recording and maintaining alumni, donor and stakeholder biographical information; researching and updating constituent data and training on data maintenance and governance requirements; inspecting, cleaning, transforming, and modeling data with the goal of highlighting useful information, suggesting conclusions, and supporting decision-making.
He/she will be responsible for having intimate knowledge of the business rules for how University Advancement manages giving and donor records. Additionally, he/she are responsible for working with UA and IT stakeholders to understand business goals and requirements in order to quickly deploy reports and analytics in Cognos that enable better decision making. He/she will be responsible for translating/developing reports based on in-depth understanding of the data quality of the database.
Reporting to the Associate Director of Record Management, key responsibilities of the Data Quality Analyst include, but are not limited to the following:
Characteristic Duties and Responsibilities
Data Collection, Analysis and Reporting / Technical Assistance
Work with Associate Director to execute vendor and campus unit data acquisition projects
Utilize Advance Performance (AP) Cognos Reporting Tool to execute reports and ad hoc query extracts that deliver on Gift and Record Management reporting needs.
Extracts, compiles and manipulates data from data base systems in order to produce reports to fulfill special requests.
Inputs, edits and verifies files, data and job runs in order to establish and ensure accuracy of data and maintain the highest level of high level of key performance indicators.
Produce adhoc global and unit based data quality reports using Cognos Workspace Advance
Data Management, Documentation and Data Integrity / Technical Assistance
Utilize Data Analyst Tools to profile biographical data from Advance and other endpoint subscribers
Work with the Data Integration team on cross-functional team projects, develop testing scenarios, documenting requirements and use diplomatic skills to validate system functionality.
Verifies, maintains and analyzes data in order to ensure accuracy of figures and resolves inconsistencies and discrepancies in data by comparing with historical data.
Provide support and best practices for Record Management customers, including Executive Leadership and fundraising staff
Customer Service and Special Projects
Work on special projects as defined in collaboration with the Associate Director, Director, AVP for AIS-DS, and University Advancement Management
Other duties as assigned
Unit Specific Education/Experience/Skills
Knowledge equivalent to that which normally would be acquired by completing a four-year college degree program in Business, Statistics or Mathematics with relevant course work in computer programming.
1 - 3 years of related and progressively more responsible or expansive work experience in programming, data base management or data collection or an equivalent combination of education and experience.
Bachelor’s Degree in Computer Science, Information Technology, Mathematics or Statistics
3– 5 years of previous online researching, trend analysis, analytics and synthesizing of large data sets or related experience. Including knowledge of wealth indicators, donor motivations for giving, and online and other information resources
3 - 5 years’ work experience with large data sets in an environment with large, complex databases.
Strong working knowledge of Microsoft Desktop Tools (Word, Excel, etc.)
Experience with IBM Cognos Workspace Advance, SQL or other query languages
Experience with data quality tools
Ability to manage, prioritize, and perform multiple tasks in a professional manner with attention to accuracy and detail
Ability to effectively communicate both orally and through e-mail to positively and professionally respond and resolve any concerns or issues with other University Advancement Staff
Willingness to learn new skills or technologies
Ability to evaluate potential changes in process or procedure and embrace changes which emerge as applicable
Effective communicator and collaborator working in a cross-functional environment
Strong project and time management skills with attention to details.
Ability to lead and influence non-hierarchical, cross-functional work groups to drive to consensus on definitions and data usage
Strong knowledge of best practices in data management
Experience around defining and managing data related processes
Strong ability to organize, prioritize, and work independently
Strong analytical and problem-solving skills
The ability to analyze and synthesize information, to manage several projects simultaneously, set priorities, and meet deadlines.
Experience with a large research institution or billion dollar-plus campaigns is preferred.
Required Application Materials
Resume and Cover Letter
Work hours are 8 AM to 5 PM with some nights and weekends.
Bidding eligibility ends on 2/18/2020 at 11:55 PM
Internal Number: 637138
About Michigan State University
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.