Data Integration Engineer

Data Integration Engineer
APEI 

The Data Integration Engineer designs, develops, operates, and improves data integration solutions that move information between enterprise source systems, cloud data platforms, databases, applications, and external partners. 

This role is responsible for building reliable, secure, and scalable data pipelines using databases, APIs, files, change data capture, vendor connectors, and other approved integration methods. The Data Integration Engineer ensures that data is delivered accurately, on schedule, and with the monitoring, documentation, security, and operational controls required for production use.

The position works closely with application teams, data engineers, architecture, DevOps, security, data governance, quality assurance, business stakeholders, and external vendors. The role focuses on the technical movement and validation of data and does not independently define business metrics, reporting requirements, enterprise business rules, or data-governance policy.

 KEY RESPONSIBILITIES:

• Design, build, test, deploy, and support data integrations across enterprise applications, databases, cloud platforms, APIs, files, and third-party systems.
• Develop reliable batch, incremental, change-data-capture, API, and secure file-transfer pipelines using approved integration tools and standards.
• Configure and maintain source connections, destinations, schedules, credentials, synchronization methods, and environment-specific settings.
• Create and maintain source-to-target mappings, technical documentation, pipeline diagrams, support runbooks, and deployment records.
• Implement controls for data completeness, accuracy, reconciliation, duplicate prevention, freshness, traceability, and error handling.
• Monitor pipelines, investigate failures, perform root-cause analysis, restore service, and communicate impacts to affected stakeholders.
• Design integrations to support restartability, schema changes, late-arriving data, partial failures, reprocessing, and source-system outages.
• Partner with data engineering, DevOps, security, governance, application teams, and vendors to deliver secure and supportable integration solutions.
• Evaluate source-system changes and communicate risks or impacts to pipelines, downstream systems, and delivery schedules.
• Improve, modernize, and retire legacy integration processes while identifying opportunities to reduce manual effort, improve reliability, and control operating costs

POSITION REQUIREMENTS:

• Five or more years of experience in data integration, data engineering, ETL/ELT development, database engineering, or a related technical field.
• Strong SQL skills and experience developing and supporting production data pipelines in cloud, on-premises, or hybrid environments.
• Experience integrating databases, APIs, secure file transfers, flat files, semi-structured data, and third-party applications.
• Experience with data integration platforms such as Airbyte, CData, Fivetran, Informatica, Matillion, Azure Data Factory, Talend, or comparable tools.
• Working knowledge of batch processing, incremental loading, change data capture, schema evolution, error handling, and restartable pipeline design.
• Experience with a scripting or programming language such as Python, PowerShell, Bash, or Java.
• Experience with cloud data platforms such as Snowflake, Azure, AWS, Google Cloud, Databricks, or comparable technologies.
• Experience with pipeline monitoring, alerting, logging, reconciliation, incident response, and production recovery.
• Working knowledge of source control, CI/CD practices, data security, encryption, credential management, and least-privilege access.
• Strong analytical, troubleshooting, documentation, communication, and cross-functional collaboration skills.

PROFESSIONAL EXPECTATIONS & COMPETENCIES

• Collaborates: Builds and maintains effective partnerships with team members and stakeholders, working collaboratively to achieve shared goals and resolve challenges effectively.
• Communicates Effectively: Delivers clear, concise, and tailored communications through various modes (e.g., written, verbal, and visual) to meet the unique needs of diverse audiences.
• Customer Focus: Cultivates strong relationships with internal and external customers by actively listening to their needs and providing timely, customer-centric solutions.
• Demonstrates Self-Awareness: Regularly seeks and incorporate feedback from peers, leaders, and stakeholders to understand and address personal strengths and areas for growth.
• Ensures Accountability: Consistently meets deadlines and delivers on commitments, ensuring work quality and aligning with organizational standards.
• Innovation & Improvement: Encourages forward-thinking solutions, process improvements, and a culture of learning to enhance efficiency and team effectiveness.

Education:

Bachelor’s degree in computer science, information systems, data engineering, software engineering, information technology, or a related field. An equivalent combination of education and relevant professional experience may be considered

Certifications: 

Cloud-platform, database, data-integration, or DevOps certifications are preferred but not required.

About Us:

Online, on campus and in the workplace, we provide higher education and training to our country’s heroes – military service members, veterans, nurses, government employees, and motivated professionals that want to make a difference. American Public Education, Inc. educates service-minded students, ranging from the military, public service, federal agencies, and nursing communities, through American Public University System (APUS), Hondros College of Nursing (HCON), and Rasmussen University.

It is the policy of American Public Education, Inc. (APEI) to afford equal opportunity to all qualified persons.  We treat all qualified individuals equally as to their recruitment, hiring, assignments, advancements, compensation, and all other terms and conditions of employment. American Public Education, Inc. does not discriminate on the basis of race, color, religion, creed, sex, age, national origin, sexual orientation, or physical, mental, or sensory disability, or any other characteristic protected by law.

If you are a resident of a state with designated pay transparency requirements and this role is available remotely, you may be eligible to receive additional information about the compensation and benefits for this role, which we will provide upon request.  Please send an email to recruiting@apei.com.