8557BR

　　Position Title:

　　Data Management and Quality Analyst

　　Organization:

　　Advancement Services and Administration

　　Job Responsibilities:

　　Data Management

　　Design processes for ingestion, transforming, extracting, and analyzing data across multiple platforms and sources encompassing but not limited to the entire constituent journey. Aim to enhance data integrity, accuracy, and operational efficiency.

　　Help define and monitor procedures pertaining to the collection and coding of advancement data.

　　Collaborate with team members to improve and automate data feeds and produce data extracts, ensuring the accurate flow of data throughout our ecosystem.

　　Communicate data back to other RIT partners.

　　Data Quality & Governance

　　Build tools, routines and checklists to improve data integrity and accuracy by reconciling data discrepancies between internal databases, university partners, and external platforms and data sources.

　　Assist with the maintenance and accuracy of data dictionaries, data metrics and catalogs.

　　Create and perform data quality control checks for internal databases and provide resolution through exploratory data analysis, database comparison, and data cleansing routines.

　　Create and maintain robust documentation for all data standards, processes and procedures.

　　Technology stack and operation

　　Configure/Admin our main systems of records.

　　Assume operational responsibility for data archiving, data appends, requests and extracts in a thorough and timely manner.

　　Perform user acceptance testing and software/services evaluation.

　　Stay up-to-date with the latest tools and techniques related to his job responsibilities.

　　Stakeholder support

　　Build and maintain relationships between University Advancement and RIT Partners.

　　Gather user requirements and advocate for stakeholder’s business needs.

　　Serve as an ambassador for communicating and monitoring governance definitions.

　　FLSA Category:

　　Exempt

　　Requisition Number:

　　8557BR

　　College/Division:

　　University Advancement

　　Required Application Documents:

　　Cover Letter, Curriculum Vitae or Resume, List of References

　　Employment Category:

　　Fulltime

　　Additional Details:

　　In compliance with NYS's Pay Transparency Act, the salary range for this position is listed above. Rochester Institute of Technology considers factors such as (but not limited to) scope and responsibilities of the position, candidate's work experience, education/training, key skills, internal peer equity, as well as, market and organizational considerations when extending an offer. The hiring process for this position may require a criminal background check and/or motor vehicle records check. Any verbal or written offer made is contingent on satisfactory results, as determined by Human Resources. RIT does not discriminate. RIT promotes and values diversity, pluralism and inclusion in the work place. RIT provides equal opportunity to all qualified individuals and does not discriminate on the basis of race, color, creed, age, marital status, sex, gender, religion, sexual orientation, gender identity, gender expression, national origin, veteran status or disability in its hiring, admissions, educational programs and activities. RIT provides reasonable accommodations to applicants with disabilities under the Rehabilitation Act, the Americans with Disabilities Act, the New York Human Rights Law, or similar applicable law. If you need reasonable accommodation for any part of the application and hiring process, please contact the Human Resources office at 585-475-2424 or email your request to [email protected]. Determinations on requests for reasonable accommodation will be made on a case-by-case basis.

　　Required Minimum Education Level:

　　Bachelors or Equivalent Experience

　　How To Apply:

　　In order to be considered for this position, you must apply for it at: http://careers.rit.edu/staff . Click the link for search openings and in the keyword search field, enter the title of the position or the BR number.

　　Wage Band (https://www.rit.edu/fa/humanresources/content/staff-wage-grade-bands) :

　　119A

　　Required Qualifications:

　　Education / Experience:

　　Bachelor's degree or equivalent combination of education and experience, in an area directly involving hands-on data work.

　　3+ years of work experience in data-centric role with significant data querying and SQL programming exposure.

　　Skills, Abilities, Knowledge

　　Understanding of databases, data models, and extract transform & load (ETL) processes.

　　Must be able to work with Microsoft Excel to an advanced level.

　　Work experience with SQL and relational database systems is required.

　　Experience in querying, cleansing, manipulating, analyzing, and summarizing large data sets quickly and expertly.

　　Experience with text pattern matching (e.g. regular expressions) for search, replace, and extraction operations is required.

　　Solid analytical/logical mindset and attention to detail.

　　Strong communication skills (clear, concise, and confident) with the ability to manage internal and external relationships.

　　Apply process-oriented thinking to optimize data flow in alignment with business requirements.

　　Experience with regular expressions, data sampling techniques and basic statistical concepts will also benefit the Data Analyst.

　　Adherence to a high level of security and ethical standards when dealing with confidential information.

　　Preferred Qualifications:

　　Experience in an advancement, fundraising, higher-education, and/or non-profit setting.

　　Experience with non-relational databases and CRM platforms is desirable.

　　Experience in conversion, upgrading and/or migrating projects are desirable.

　　Experience with, or ability to learn quickly about, the technology stack used by the Division of UA: MS Office, MS Azure, MS Purview, Oracle, SQL, PL/SQL, enterprise automation tools, Python and VBA is strongly preferred. MS Power Automate and RPA tools are a plus.

　　Curiosity and openness to explore how AI tools can be leveraged to improve our operation.

　　Experience with user acceptance testing and developing data products.

　　Department/College Description:

　　At Rochester Institute of Technology, our mission is to shape the future and improve the world through creativity and innovation. As an engaged, intellectually curious, diverse and socially conscious community, we leverage the power of technology, the arts, and design for the greater good. In the Division of University Advancement at RIT, we are dedicated to advancing this mission by fostering deep and meaningful connections with alumni, parents, friends, and organizations with the goal of increasing the resources available to the university through greater volunteer engagement and increased philanthropic support. As Advancement professionals, we seek support from a variety of investors to ensure a life-transforming RIT education is accessible to the talented students who seek to join us.

　　RIT’s Division of University Advancement (UADV) is committed to diversity, equity and inclusion. We believe the power of diversity enriches all of us by exposing us to a range of ways to understand and engage with each other, our constituents and our broader communities. We are dedicated to developing and implementing best practices to promote even greater diversity through our employee retention and hiring, accessibility, marketing materials, constituent engagement and in pursuit of our philanthropic goals.

　　What do we believe at RIT?:

　　Rochester Institute of Technology is a diverse and collaborative community of engaged, socially conscious, and intellectually curious minds. Through creativity and innovation, and an intentional blending of technology, the arts and design, we provide exceptional individuals with a wide range of academic opportunities, including a leading research program and an internationally recognized education for deaf and hard-of-hearing students. We are dedicated to building a diverse community, one where employees feel a sense of belonging, and are valued for their contributions and the perspectives they bring.

　　As a member of the RIT community, you'll receive a comprehensive employee benefits package (https://www.rit.edu/fa/humanresources/sites/rit.edu.fa.humanresources/files/docs/Benefits_at_a_Glance.pdf) that offers multiple options and access to additional employment advantages. You can tailor your benefit elections to meet your needs (affordable medical/dental/vision benefits; paid vacation/sick time/retirement saving plan with exceptional employer match; and tuition assistance for you and your family, to name a few).

　　Work Location:

　　Hybrid — Remote/On-campus

　　Job Summary:

　　The Advancement Systems, Data, and Analytics Team makes transformation possible for the RIT community by effectively partnering with and empowering advancement stakeholders at the crossroads of strategy, systems, data, and analytics. As a critical member of this team, the Data Analyst is a data governance and data literacy champion and will be responsible for continually improving the quality, accuracy, availability, and effective use of data throughout our extensive constituent management systems and data ecosystem.

　　A successful Data Analyst will effectively communicate with our stakeholders to understand their data needs and take proactive measures to enhance data management across the Division, including but not limited to modeling, describing, and organizing data assets. They will also create data samples, maintain data standard definitions, monitor data quality metrics, and assess data health prior to update our system of records through meticulous interrogation and reconciliation of data from several complex data sources, spanning the constituent lifetime journey (enrollment, student, alumni, donor, parent, friend, staff, etc.) and to provide data to other RIT partners (such as Marketing, Enrollment, ITS, etc).

　　This position would be well served by an experienced level of SQL and advanced Excel skills, and there will be opportunities to learn and program in other languages such as Python and VBA. The ideal person in this role will be committed to continual learning about data analysis, the RIT community, and the Advancement practice. Demonstrable appreciation for diversity and a willingness to develop personal leadership traits and team relationships is highly desirable.

　　Hourly/Salary Minimum:

　　52300

　　Hourly/Salary Maximum:

　　87600