Description

  • Guide functional leads through mapping, pre validation, and post validation activities.
  • Interpret mapping activities into crosswalks and manifest data specification for both source and destination at a field and table level.
  • Render technical specifications in extract code in alignment with best practices and performance considerations.
  • Participate in peer review of other developer’s extract code and provide actionable, meaningful feedback.
  • Deliver extracts for pre-validation on target dates.
  • Work with functional lead to review and gain approval on pre-validation and submit extracts on time to the specified extract location.
  • After extracts are run in end-to-end environment, work with functional lead to conduct post validation activities.
  • Facilitate functional leads and other subject matter experts to log issues (with the appropriate priority) in the conversion bug tracker.
  • Resolve issues identified in a prioritized fashion.
  • Participate in daily conversion team meetings.
  • Follow AMP architectural standards or requirements for change management.
  • Liaise with project stakeholders on an ongoing basis. Set and continually manage project expectations with team members and other stakeholders.
  • Participate and contribute to AMP project lessons learned reviews, document process strengths and limitations, and create a recommendations report to identify successful and unsuccessful project elements.
  • Escalate barriers, issues, risks to the AMP conversion lead clearly and with recommendations for resolution.
  • Build, develop, and grow any business relationships vital to the success of the project.

     

Other Duties as Assigned (5% of role): 

 

  • Participate in appropriate activities that enhance general knowledge of, or ability to do, assigned work.
  • Participate in AMP processes and initiatives, including change management, RAID management, etc.
  • Other duties as assigned.

     

Minimum/Required Qualifications

 

  • Bachelor’s degree from an accredited college or university, or equivalent from previous experience.
  • Experience building and optimizing relational database queries in SQL.
  • Experience with source control systems such as Git, GitHub, SVN, or equivalent.
  • Proficiency in PL/SQL or Equivalent Languages
  • Strong experience writing efficient data extraction logic using PL/SQL or similar technologies (e.g., Python, SQL*Plus, Oracle SQL Developer, etc.).
  • Ability to develop maintainable and high-performance scripts for querying and transforming data.
  • Oracle SQL Performance Tuning
  • Strong understanding of query optimization techniques, execution plans, and indexing strategies.
  • Ability to analyze and improve the performance of large-scale data extraction processes.
  • Experience with Oracle Data Extraction and ETL Processes
  • Hands-on experience designing and implementing efficient data extraction routines.
  • Familiarity with tools and techniques for moving data between Oracle and external systems (e.g., flat files, APIs, or ETL tools like EIBs).
  • Four years’ experience writing code project(s) (IT or otherwise).
  • Two or more years with FIN/ ERP specific data
  • Experience working independently as a developer and in team-oriented, collaborative environments.
  • Highly adaptive: can conform to shifting priorities, demands, and timelines through agile, analytical, and problem-solving capabilities.
  • Persuasive, encouraging, and motivating.
  • Ability to elicit cooperation from a wide variety of sources, including management, clients, and other departments.
  • Ability to successfully complete with political sensitivity and tenacity.
  • Strong written and oral communication skills. Demonstrable ability to take initiative with questions that clarify ambiguity in software or functional requirements.
  • Adept at conducting research into project-related issues and products.
  • Ability to effectively prioritize and execute tasks in a high-pressure environment.
  • A demonstrable commitment to promoting and enhancing diversity, equity, and inclusion practices. 

     

Preferred Qualifications

 

  • Bachelor’s degree or higher in Computer Science, Business/Management Information Systems, Engineering, or related field.
  • Experience with enterprise-wide reporting projects leveraging both FIN and Grants data in an institutional setting
  • Experience performing data conversion from Banner to Workday

Education

Bachelor's degree