Senior Data Integration Engineer: AI-Driven ETL on Azure

Socket.dev; Charlotte (NC); On-site; USD 110,000 - 140,000; Full time

Job summary

Socket.dev in Charlotte is seeking an IT Data Integrations Engineer III to design, implement, and maintain complex data integration solutions across ETL pipelines, databases, and APIs. You will mentor junior developers and ensure code quality, security, and performance.

The role requires deep hands-on expertise with SSIS, Azure Data Factory, SQL Server, .NET API integration, Python scripting, and experience delivering AI-enabled data workstreams in enterprise environments.

Qualifications

• Five or more years of experience in data integration, ETL, and data warehousing.
• Proficient with SSIS and Azure Data Factory for integration workflows.
• Strong SQL skills and database design experience.
• Experience with .NET API integration and Python scripting.
• Familiarity with AI concepts and data security governance.

Responsibilities

• Lead, design, develop, and optimize ETL processes using SSIS/ADF.
• Analyze data requirements and translate them into effective integration solutions.
• Develop API calls using .NET for system integrations.
• Tune SQL Server performance and design databases.
• Implement ingestion patterns on Azure (ADLS Gen2) for batch and near-real-time feeds.
• Apply data governance and security standards.
• Drive AI adoption in data pipelines and workflows.
• Mentor junior developers and contribute to architectural designs.

Skills

ETL development

Data integration

Azure Data Factory

SQL Server

Python

API integration

Data warehousing

Git workflows

Education

Bachelor's degree in Information Systems/CS/Engineering

Two years of education beyond high school

Tools

Azure DevOps

Snowflake

Job description

Socket.dev in Charlotte is seeking an IT Data Integrations Engineer III to design, implement, and maintain complex data integration solutions across ETL pipelines, databases, and APIs. You will mentor junior developers and ensure code quality, security, and performance.

The role requires deep hands-on expertise with SSIS, Azure Data Factory, SQL Server, .NET API integration, Python scripting, and experience delivering AI-enabled data workstreams in enterprise environments.