Senior ETL & Data Integration Engineer - Local to Denton, Texas (40 Miles)

American Unit, Inc; Denton (TX); On-site; USD 120,000 - 150,000; Full time

Job summary

American Unit, Inc. is seeking a Senior ETL & Data Integration Engineer to design, build, and support enterprise data platforms powering institutional reporting and analytics.

This individual contributor role leads the technical design across enrollment, student records, finance, HR, and institutional research data, collaborating with cross-functional teams in a data-driven environment.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field (equivalent experience considered).
• 8+ years of progressively responsible experience in data engineering, data warehousing, or ETL development.
• Hands-on experience with Oracle Database/PL-SQL or SQL Server/T-SQL.
• Experience with Oracle Integration Cloud (OIC), SnapLogic, or SSIS — OIC and SSIS ideal.

Responsibilities

• Design and maintain enterprise data warehouses, operational data stores, and data lake solutions across cloud and on-prem environments.
• Build ETL/ELT pipelines and reusable integration components using Oracle Cloud and SQL Server tools.
• Integrate enterprise systems (ERP, HCM, SIS, CRM) using REST/SOAP APIs, SFTP, and event-driven patterns.
• Support BI and analytics initiatives, developing curated datasets and semantic models.
• Optimize database performance, partitioning, and query tuning for large-scale datasets.
• Provide technical leadership and mentorship to junior developers and analysts.

Skills

ETL development

Data integration

SQL Server / PL-SQL

Oracle SQL / T-SQL

Cloud/on-prem data platforms

REST/SOAP APIs integration

Mentoring juniors

Education

Bachelor's degree in Computer Science or related

Tools

OIC

SnapLogic

SSIS

Job description

Job Title: Senior ETL & Data Integration Engineer

Engagement Type: Contract to Hire; conversion based on performance, client need, and mutual fit

Location: Denton, TX 76204 (must be within 40-mile commute radius)

Schedule: Monday to Friday, 8:00 AM to 5:00 PM

Interview Rounds: Two mandatory onsite interviews in Denton, TX

Work Authorization: Must be authorized to work in the United States on a full-time, ongoing basis without the need for employer sponsorship now or in the future

Background: Must pass a satisfactory standard criminal background check upon hire.

About the Role

Seeking a Senior ETL & Data Integration Engineer to design, build, and support enterprise data platforms that power institutional reporting and analytics.

This is an individual contributor role for someone who wants to lead the technical design of what they build, working across enrollment, student records, finance, HR, and institutional research data.

What You'll Do

• Design and maintain enterprise data warehouses, operational data stores, and data lake solutions across cloud and on-prem environments
• Build ETL/ELT pipelines and reusable integration components using Oracle Cloud and SQL Server tools
• Integrate enterprise systems (ERP, HCM, SIS, CRM) using REST/SOAP APIs, SFTP, and event-driven patterns
• Support BI and analytics initiatives, developing curated datasets and semantic models
• Optimize database performance, partitioning, and query tuning for large-scale datasets
• Provide technical leadership and mentorship to junior developers and analysts

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field (equivalent experience considered)
• 8+ years of progressively responsible experience in data engineering, enterprise data warehousing, or ETL development
• Hands-on experience with Oracle Database/PL-SQL or SQL Server/T-SQL
• Experience with at least one of: Oracle Integration Cloud (OIC), SnapLogic, or SQL Server Integration Services (SSIS) — OIC and SSIS experience is ideal
• Experience designing and supporting enterprise data warehouses, operational data stores, or cloud-based analytics platforms
• Ability to independently architect a data solution and explain the reasoning behind design decisions

Preferred Qualifications

• Experience with Power BI or Oracle Analytics Cloud (OAC)
• Experience with Ellucian Colleague, Banner, or similar higher-ed SIS platforms (nice-to-have, not required)
• Higher education, healthcare, or other regulated public-sector data experience
• Familiarity with FERPA, HIPAA, or Texas Administrative Code (TAC 202) data standards