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 [email protected]

[[email protected]].