Data Integration Engineer

Department: Information Technology Services

Classification: Info Technology Spec 2

Job Category: Classified Staff

Job Type: Full-Time

Work Schedule: Full-time (1.0 FTE, 40 hrs/wk)

Location: Fairfax, VA

Workplace Type: Hybrid Eligible

Sponsorship Eligibility: Not eligible for visa sponsorship

Pay Band: 05

Salary: $100,000 annual salary; commensurate with education and experience

Criminal Background Check: Yes

The mission of the Enterprise Data Integration Service team is to “enable the university’s sustainable growth, greater return on student investment, and cost‑effective operations via efficient data exchange and integration processes and a robust data integration platform through a relentless focus on reuse, rapid and reliable development, and use of a well‑planned data architecture to increase the speed and quality of data integration implementation for inter‑application data exchange.”

The systems and services include the Banner administrative applications (supporting student, finance, admissions, human resources, payroll, financial aid, and procurement), Ellucian Ethos APIs and Banner Process APIs, Data Mart’s/Business Intelligence (supporting strategic and operational end‑user reporting requirements), Salesforce CRM, decentralized systems and web applications (supporting budgeting, sponsored programs activity, telephone billing, and other University applications), and support for integration and enforcement of architectural standards.

The IT environment is comprised of Oracle databases supporting Ellucian Banner and other administrative systems, third‑party applications, Salesforce CRM, and other Content Management Systems.

The Data Integration Engineer provides primary technical support to ensure reliability, integrity, accessibility, and usability of George Mason University’s applications that support mission‑critical business functions of the university by supporting data exchange and data sharing of university data across applications and platforms. This position is data‑oriented and designs and implements integrations to connect multiple data sources, software platforms, and applications, including ERP, CRM, REST services, documents, and unstructured data.

The Data Integration Engineer provides expert problem solving with programming skills and abilities in multiple coding languages and frameworks. Performs troubleshooting to resolve errors, provide support, and develop procedures to navigate complex system overlaps.

This position supports users in diagnosing and resolving production problems and testing. Provides custom application and integration support using advanced programming techniques and tools (JAVA, Perl, Unix Shell scripting, XML, secure data transfer, web services, automated file sharing, and web programming).

Provides technical leadership and support for new initiatives that enhance the functionality of university applications through data exchange, data integration or application integration.

Guides and advises decentralized business analysts and functional experts in developing and utilizing formal specifications for all new initiatives, following Enterprise Data Integration Services and Reporting (EDIS‑R) standards, as well as industry best practices. Ensures recommendations for business process changes are appropriate. Utilizes advanced techniques to build mission critical data exchange, data and application integrations between Banner and other Mason systems, and applications to fulfill institutional requirements.

• Reads University ERP system and third‑party vendor documentation to use existing Data APIs, web services, or software, and develops additional packages that will allow for reuse of code across applications;
• Collaborates with other Banner institutions, communicating through established listservs, networking with counterparts, sharing ideas and code when possible;
• Codes solutions following EDIS‑R standards;
• Documents and presents solutions to customers and peers for review and ongoing support;
• Documents source‑to‑target‑mappings (STTM) at both entity or object and attribute (column) levels;
• Collaborates and engages…