Data Integration Engineer 5604

Tier4 Group; Dallas (TX); On-site; USD 95,000 - 135,000; Full time

Job summary

Tier4 Group is seeking a Data Integration Engineer to join the Enterprise Solutions team in Dallas, TX. You will design, build, and maintain cloud-based data integration solutions focusing on Azure Data Factory, Azure SQL, and the broader Azure ecosystem.

You will own modern ETL initiatives, optimize data flows, and collaborate with BI, data architects, and business stakeholders to deliver reliable, scalable integrations across ERP, APIs, and file formats.

Qualifications

• 5+ years in data integration, ETL, or data engineering.
• Strong SQL: write, optimize, troubleshoot complex queries.
• Experience building and supporting enterprise-scale data pipelines and integration workflows.
• Ability to collaborate with analysts, architects, developers, and stakeholders.
• Excellent documentation and communication skills.

Responsibilities

• Design and develop integration solutions from business needs to target systems.
• Build and maintain ETL/ELT processes across cloud environments.
• Develop integrations using Azure Data Factory, Azure SQL, Blob Storage, APIs, SFTP, JSON, XML.
• Create and maintain integrations from ERP systems into centralized data platforms and warehouses.
• Design and maintain databases, write complex SQL queries, and support data movement.
• Collaborate with business analysts, data architects, developers, and stakeholders to gather requirements.
• Ensure data quality and consistency through validation processes and business rules.
• Analyze, troubleshoot, and optimize integration workflows to resolve bottlenecks.
• Maintain technical documentation including mappings, workflows, and configurations.
• Support and enhance integrations involving enterprise applications like Workday, Medius, and other systems.
• Partner with BI to support reporting and Microsoft Fabric initiatives.
• Research and evaluate emerging technologies related to Azure cloud services and data integration.
• Contribute to modernization of the organization’s cloud data platform and future-state architecture.

Skills

Advanced SQL

REST APIs

SFTP

JSON

XML

Flat files

ETL development

Data integration

Data warehousing

Azure Data Factory

Azure SQL

Azure Blob Storage

Power BI

ERP integrations

Tools

Azure Data Factory

Azure SQL

Azure Blob Storage

Microsoft Fabric

Workday integration

Job description

About the Role:

We are seeking a Data Integration Engineer to join the Enterprise Solutions team and play a critical role in advancing the organization’s cloud-based data platform. Reporting to the Director of Enterprise Solutions, this position will be responsible for designing, building, and maintaining data integration solutions across the organization, with a primary focus on Azure Data Factory, Azure SQL, and the broader Azure Cloud ecosystem.

This is a unique opportunity for someone who wants ownership and influence. The successful candidate will help shape the future data landscape, modernize and expand cloud-based integrations, and contribute to the architecture and direction of the company's data platform. Unlike previous iterations of the role that focused heavily on maintaining legacy integrations, this position will be focused on building and optimizing modern cloud-based ETL solutions and helping drive continued investment in Azure, Microsoft Fabric, and AI-enabled technologies.

Key Responsibilities:

• Design and develop integration solutions by understanding business requirements, data sources, and target systems.
• Build, configure, and maintain ETL/ELT processes that extract, transform, and load data between various systems and cloud environments.
• Develop and support data integration processes using Azure Data Factory, Azure SQL, Azure Blob Storage, APIs, SFTP, JSON, XML, and other common integration technologies.
• Create and maintain integrations from ERP systems and other enterprise applications into centralized data platforms and data warehouses.
• Design and maintain databases, write complex SQL queries, and support data movement across multiple systems.
• Collaborate with business analysts, data architects, developers, and business stakeholders to gather requirements and deliver effective integration solutions.
• Ensure data quality and consistency through validation processes and adherence to business rules.
• Analyze, troubleshoot, and optimize integration workflows, identifying and resolving performance bottlenecks.
• Maintain technical documentation, including data mappings, workflows, configurations, and integration processes.
• Support and enhance integrations involving enterprise applications such as Workday, Medius, and other business systems.
• Partner with the Business Intelligence team to support reporting, analytics, and Microsoft Fabric initiatives.
• Research and evaluate emerging technologies, tools, and best practices related to Azure cloud services, data integration, and enterprise architecture.
• Contribute to the ongoing modernization of the organization’s cloud data platform and future-state architecture.

Required Qualifications

• 5+ years of experience in data integration, ETL development, data engineering, or related disciplines.
• Strong hands-on experience with:
• Advanced SQL skills with the ability to write, optimize, and troubleshoot complex queries from scratch.
• Experience developing and supporting integrations utilizing:
• REST APIs
• SFTP
• JSON
• XML
• Flat files
• Experience building and maintaining enterprise-scale data pipelines and integration workflows.
• Understanding of data warehousing concepts, data modeling, and integration best practices.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication and collaboration skills with both technical and business stakeholders.
• Experience creating and maintaining technical documentation.

Preferred Qualifications

• Experience with Microsoft Fabric, Lakehouse architectures, or modern cloud analytics platforms.
• Familiarity with Power BI and business intelligence environments.
• Experience integrating with ERP systems, Workday, Medius, or other enterprise applications.
• Exposure to AI-enabled development tools and automation technologies.
• Knowledge of enterprise integration patterns, middleware technologies, and cloud architecture principles.

Why This Opportunity?

This role offers the opportunity to make a significant impact within a growing data organization. The team has made substantial investments in Azure Cloud, Microsoft Fabric, AI tools, and modern data technologies, creating an environment where engineers can build innovative solutions rather than simply maintain legacy systems. The successful candidate will have meaningful ownership over the organization's data integration strategy, influence technical direction, and help define the future of the enterprise data ecosystem.