Data Transformation & Solution Design
Conduct thorough data analysis to define and document data mapping requirements and transformation logic. Convert operational specifications into technical designs, ensuring referential integrity and data consistency across heterogeneous systems. Participate in the selection of suitable integration patterns (batch, event-driven, or real-time) to meet university business needs.
Collaboration & Documentation
Partner with functional teams (Registrar, HR, Admissions, Advancement) to translate complex business requirements into technical specifications. Analyze problems and issues presented by end users and develop a solution. When no solution is determined, serve as a liaison between the user(s) and vendor(s) to resolve the issues and confirm changes. Maintain comprehensive documentation for integration designs, data flow diagrams, and problem resolutions. Provide timely updates to functional users and management. Ensure all solutions comply with university data security, privacy, and regulatory standards (e.g., FERPA) and maintain confidentiality of such solutions.
Professional Development & Quality Assurance
Stay current with emerging technologies in data integration, middleware, and cloud platforms. Participate in code reviews to enforce standards and mentor junior staff. Create and execute unit, system, and end-to-end integration tests to validate data accuracy and performance prior to production deployment.
Other duties as assigned.
Physical Demands
Those typical of an office environment.
Work Hours
Typical hours are Monday-Friday,8:00 a.m. to 4:30 p.m. Must be able to work outside normal hours (evenings, weekends, holidays) to support scheduled changes and be on call after hours.
Special Instructions
Applicant's will be required to submit a letter of application (including self-assessment of how the applicant's qualifications satisfy the position requirements), resume, contact information (including email and relationship to applicant) for three recent (36 months) professional references, and a copy of transcripts (official transcripts will be required upon hire). Submission of materials is the applicant's responsibility. Applications without all required materials are incomplete and will not be considered.
Salary
Commensurate with education and experience. Level P2, Grade 13.
Benefits Information
The University offers a competitive benefits package. Benefits include the accumulation of two vacation days per month, one sick leave day per month, and thirteen University holidays. Other benefits include medical and life insurance (shared cost with the university), retirement, optional 401k, and educational benefits.
Minimum Qualifications
Bachelor’s degree from an accredited institution in Computer Science, Information Technology, Computer Engineering, or a related field. 3 or more years of professional experience in integration development, including hands-on experience with ETL tools or middleware platforms. Proficiency in at least one object-oriented or procedural programming language (e.g., Java, C#, Python). Strong working knowledge of SQL and experience with relational database technologies (e.g., Oracle, SQL Server). Demonstrated experience developing and consuming RESTful and SOAP web services. Experience working in a Higher Education environment with enterprise systems such as Ellucian Banner, or Oracle. Experience with cloud-based integration platforms (e.g., MuleSoft, Boomi, Informatica) or Enterprise Service Bus (ESB) concepts. Proven ability to troubleshoot complex data flow issues and optimize performance for high-volume data exchanges. Knowledge of version control systems (e.g., Git/GitHub) and automated deployment pipelines (CI/CD). Familiarity with Learning Management Systems (LMS).
Preferred Qualifications
Ten years of IT experience working in a Higher Education environment is preferred. Experience in web development and data analysis. Experience in an end-user support role. Experience supporting an enterprise resource planning system in a higher education environment. Experience in developing rich, data-driven applications. Experience training information technology professionals. Demonstrated excellence in Communications and interpersonal skills. Experience producing technical documentation. Strong time management and organizational skills with a record of being flexible, accurate, detail-oriented, reliable, and self-motivated. Experience in the administration of web and database services in Windows and Linux environments. Detailed knowledge of current programming technologies. Strong service delivery/customer service orientation. Experience using Bootstrap and jQuery in enterprise application development. Experience developing and interacting with RESTful web services. Experience developing with C++ and PHP programming languages.
