Data Integration Specialist

Old Dominion University; Norfolk (VA); On-site; USD 70,000 - 110,000; Full time

Job summary

Old Dominion University is seeking a Data Integration Specialist for the ODU CRM Team to bridge the CRM, enterprise integration staff, and campus stakeholders, building a 360-degree view of the student in Salesforce Education Cloud.

You will lead requirements gathering, document data mappings, and debug pipelines connecting Banner, Common App, and Axiom Elite, translating business needs into actionable technical tasks to support recruitment, enrollment, and retention.

Qualifications

• Experience creating and optimizing data integrations and ETL/ELT processes.
• Ability to translate business needs into technical requirements.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration across teams.
• Experience with enterprise systems and data mapping.

Responsibilities

• Lead requirements gathering and documentation for data pipelines.
• Debug and validate data flows between Banner, Common App, and Axiom Elite.
• Collaborate with CRM and enterprise integration teams.
• Provide end-user support through tickets and training.

Skills

ETL/ELT processes

Salesforce architecture

API architectures

SQL querying

Data integration

Education

Bachelor’s degree in Computer Science/IT or related field

Master’s degree preferred

Tools

Salesforce Education Cloud

Axiom Elite

Informatica

Snowflake / AWS S3

Job description

As the Data Integration Specialist for the ODU CRM Team, you will act as the vital bridge between the CRM team, enterprise integration staff, and campus stakeholders to establish a 360-degree view of the student within Salesforce Education Cloud. In this highly collaborative role, you will lead the requirements gathering, documentation, and debugging of critical data pipelines connecting systems like Banner, Common App, and Axiom Elite. By actively translating business needs into actionable technical requirements, you will ensure seamless, accurate data flow that drives the university's recruitment, enrollment, and retention success.

Minimum Qualifications

• Bachelor’s degree in Computer Science, Information Technology or a related field of study, or related education, training and/or work experience equivalent to a bachelor’s degree in the proceeding fields.
• Demonstrated experience in creating, managing, troubleshooting, and optimizing data integrations and ETL / ELT processes.
• Strong analytical and problem-solving skills, with the ability to translate business needs into technical solutions.
• Solid understanding of API architectures ( REST , SOAP ), web services, and data transformation protocols.
• Ability to troubleshoot and explain technical issues and work progress to both technical and non-technical staff.
• Excellent project management skills with keen attention to detail and strong organizational abilities.
• Ability to communicate effectively at all levels of the organization: orally and in writing.
• Proven ability to prioritize tasks, meet deadlines, work under pressure, and when necessary, with minimal resources.
• Expert-level working experience with Salesforce architecture, data structures, and troubleshooting, particularly within Higher Education environments.
• Working experience gathering technical requirements, documenting data mapping, and initiating integration requests for enterprise systems.
• Working experience providing end-user support through tickets, training, and documentation.
• Working experience writing and executing SQL queries for data extraction, analysis, validation, and debugging across relational databases and data warehouses.
• Working experience creating test plans, cases, data, and documentation.
• Working experience working with a distributed staff in an organized and consistent manner.

Preferred Qualifications

• Certified Salesforce Administrator (preferred)
• Working experience with Data 360, as well as modern data storage tools and data warehouses (e.g., Snowflake, AWS S3, etc.).
• Familiarity with enterprise integration platforms (e.g., Informatica, Axiom Elite) and Student Information Systems (e.g., Ellucian Banner) to effectively collaborate with the technical teams that own those platforms.
• Master’s degree in Computer Science, Information Technology or a related field of study required. Or a Bachelor’s degree in Computer Science, Information Technology, or a related field with related work experience equivalent to a master’s degree in the proceeding fields.