Audit and Data Coordination Specialist

Job Title
Audit and Data Coordination Specialist

Agency
Texas A&M University

Department
Sponsored Research Services

Proposed Minimum Salary
Commensurate

Job Location
College Station, Texas

Job Type
Staff

Job Description

Our Commitment

Texas A&M University is committed to enriching the learning and working environment by promoting a culture that respects all perspectives, talents & lived experiences. Embracing varying opinions and perspectives strengthens our core values which are: Respect, Excellence, Leadership, Loyalty, Integrity, and Selfless Service

Who We Are

Sponsored Research Services (SRS) provides research administration services to The Texas A&M University System. We further the research goals of the university by delivering efficient and superior service to members of the Texas A&M System research community. Through our services, SRS teams work with several stakeholders to ensure the success of research projects. To learn more, visit ;br>
What We Want

The Audit and Data Coordination Specialist serves as a liaison between Sponsored Research Services (SRS) and internal and external auditors on financial data, and sponsored projects within SRS. Analyzes and maintains data supporting specialized and complex reporting projects. Interprets findings and data ensuring accuracy of research reports year to year. Develops and performs assessments to ensure accuracy, consistency, and reliability of SRS data from Maestro research administration system and various agency financial systems. Advises the Assistant Director of Research Reporting on problematic data, data fields and attributes, and makes corrections through advanced technical support and troubleshooting.

What You Need To Know

Compensation will be commensurate to the selected hire's experience.

A cover letter and resume are strongly recommended.

Qualifications

Required Education and Experience:

• Bachelor's degree in applicable field or equivalent combination of education and experience.
• Four years of related experience in auditing or data collection and analysis and using data management information systems.

Required Knowledge, Skills, and Abilities:

• Ability to participate in and foster a collaborative team environment.
• Excellent oral and written communication skills.
• Ability to gather information requirements, retrieve accurate information, and present information.
• Ability and willingness to learn new data analysis tools and methodologies.
• Ability to multi-task and work cooperatively with others.
• Skilled with word processing and spreadsheets.

Preferred Qualifications:

• Professional work experience in auditing, data collection, analysis, interpretation and reporting, and reconciling.
• Knowledge with FAMIS, Data Warehouse, Business Objects (BO), Maestro, Concur, Aggiebuy, Academic Analytics and Power Bl.
• Ability to work under deadlines and projects with short turn-around times.
• Ability to design, develop, conduct and assess effectiveness of programs and applications, specifically with research productivity and administration.
• Experience in troubleshooting, problem solving, and technical consultation. Taken CPA exam or has a CPA.

Responsibilities

• Audit Liaison - Serves as a liaison between Sponsored Research Services (SRS) and internal and external auditors on financial data, and sponsored projects within SRS. Prepares, maintains, and presents data population for audit review. Responds to requests for information and documentation to auditors in desired formats. Develops and performs quality assurance activities related to sponsored projects within SRS. Analyzes and reviews internal controls, sponsored research records, and processes to ensure compliance and accuracy. Assists in coordinating and scheduling audit work, attending entrance and exit meetings, and developing management responses to audit observations.
• Data Analysis & Reporting - Analyzes and maintains data supporting specialized and complex reporting projects. Interprets findings and data ensuring accuracy of research reports year to year. Develops and consolidates data and responses for required surveys including the NSF Higher Education R&D Survey, THECB annual survey of R&D expenditures, NIH Annual Survey of Expenditures, and assessments required by external federal and state agencies. Develops comprehensive reporting of data and research metrics from Texas A&M and TAMUS agencies which includes Agrilife Research & Extension, TEES, TTI, TVMDL, TAMU HSC Office, Systems Office, TAMU Galveston, and Texas A&M Research Foundation. Prepares, maintains, and presents historical and comparative data for internal and external reports. Develops and maintains internal metrics for SRS Pre and Post award units.
• Data Integrity, Accuracy & Quality Assurance - Develops and performs assessments to ensure accuracy, consistency, and reliability of SRS data from Maestro research administration system and various agency financial systems. Analyzes data attributes in FAMIS and Maestro systems for new funding sponsors, research accounts, and projects. Reconciles indirect costs and performs financial tasks for Sponsored projects. Prepares exception reports to ensure data fields are completed for accurate reporting of R&D metrics (expenditures, awards, and proposals). Maintain and updates procedures for integrating University data.
• Provides training and consultation with Texas A&M and TAMUS agencies ensuring data consistency and accuracy. Implements process mapping on document processes and identifies areas of improvement.
• Technical Support & Training- Advises the Assistant Director of Research Reporting on problematic data, data fields and attributes, and makes corrections through advanced technical support and troubleshooting. Performs assessments to research and analyze technical errors, provide recommendations, and implement effective solutions. Serves as technical resources for staff offering assistance and consultation on assessment and data activities.

Why Texas A&M University?

We are a prestigious university with strong traditions, Core Values, and a community of caring and collaboration. Amenities associated with a major university, such as sporting and cultural events, state-of-the-art recreation facilities, the Bush Library and Museum, and much more await you. Experience all that a big city has to offer but with a reasonable cost-of-living and no long commutes.

• Health , dental , vision , life and long-term disability insurance with Texas A&M contributing to employee health and basic life premiums
• 12-15 days of annual paid holidays
• Up to eight hours of paid sick leave and at least eight hours of paid vacationeach month
• Automatically enrollment in theTeacher Retirement System of Texas
• Health and Wellness: Free exercise programs and release time
• Professional Development: All employees have access to free LinkedIn Learning training, webinars, and limited financial support to attend conferences, workshops, and more
• Employee Tuition Assistance and Educational Release time for completing a degree while a Texas A&M employee

Instructions to Applicants: Applications received by Texas A&M University must either have all job application data entered or a resume attached. Failure to provide all job application data or a complete resume could result in an invalid submission and a rejected application. We encourage all applicants to upload a resume or use a LinkedIn profile to pre-populate the online application.

All positions are security-sensitive. Applicants are subject to a criminal history investigation, and employment is contingent upon the institution's verification of credentials and/or other information required by the institution's procedures, including the completion of the criminal history check.

Equal Opportunity/Affirmative Action/Veterans/Disability Employer.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.