Data Integration Specialist

Socket.dev; Dallas (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

Socket.dev is seeking a Data Integration Specialist to design, build, and maintain enterprise data pipelines using Azure Data Factory, Azure SQL, and related services. You will enable reliable reporting, analytics, and automation across business systems.

You will partner with Enterprise Solutions, platform owners, and analysts to implement scalable, secure integrations, ensure data quality, document data flows, and support cloud-native modernization efforts with Azure and Microsoft Fabric

Qualifications

• 3–5+ years in data integration, data engineering, ETL/ELT, or a related technical role.
• Strong SQL skills with advanced querying and data transformation.
• Hands-on experience with Azure Data Factory, Azure SQL Database/SQL Server, and Azure Blob Storage.
• Experience building and troubleshooting production data pipelines and integration workflows.
• Experience integrating data from APIs, FTP/SFTP, and structured files (JSON/XML/CSV).
• Ability to diagnose data quality issues and resolve pipeline failures.
• Strong ownership mindset, learning orientation, and cross-team collaboration.

Responsibilities

• Design, build, and maintain scalable ETL/ELT data pipelines in Azure.
• Monitor pipeline health, troubleshoot data movement issues, and coordinate remediation.
• Integrate data from various source systems using APIs, FTP/SFTP, and flat files.
• Maintain data platform objects and ensure reliable data movement and transformation.
• Ensure data quality, performance, and cost efficiency through best practices.
• Collaborate with analysts and stakeholders to design practical data integrations.
• Document data flows, mappings, dependencies, and runbooks.
• Support modernization toward cloud-native solutions with Azure and Fabric.

Skills

SQL

Azure Data Factory

Azure SQL

ETL/ELT

Data pipelines

APIs/FTP/SFTP

Data quality

Documentation

Azure DevOps

Education

Bachelor’s degree in Computer Science / Information Systems / Data Analytics

Tools

Git-based source control

Azure DevOps

Microsoft Fabric

SSIS

Job description

Position Summary:

The Data Integration Specialist designs, builds, maintains, and supports enterprise data pipelines and integrations that enable reliable reporting, analytics, automation, and decision‑making across the business. As part of the Enterprise Solutions team, this role helps modernize how enterprise data is integrated, managed, and delivered across business systems, reporting platforms, and centralized data stores. This role leverages Azure Cloud data services, Azure SQL, and other tools to deliver supportable, scalable, and secure data integrations.

Key Responsibilities:

• Design, build, and maintain data pipelines: Develop scalable ETL/ELT processes using Azure Data Factory, Azure SQL, Azure Blob Storage, SQL Server, and related Azure Cloud data services to move, transform, and prepare business data for downstream use.
• Support production data integrations: Monitor pipeline health, investigate failures, troubleshoot data movement issues, resolve incidents, and coordinate remediation to ensure reliable and timely data processing.
• Integrate enterprise source systems: Build and maintain integrations across a broad range of internal and external source systems using APIs, FTP/SFTP, structured files, and secure, supportable integration patterns.
• Maintain data platform objects: Create, update, and support database, warehouse, lakehouse, staging, and integration objects needed for reliable data movement, transformation, and consumption.
• Ensure data quality and performance: Implement validation, reconciliation, error‑handling, tuning, and optimization practices to improve accuracy, reliability, scalability, maintainability, and cost effectiveness.
• Participate in solution design and discovery: Partner with Enterprise Solutions teammates, business analysts, platform owners, and stakeholders to understand requirements, evaluate source and target systems, and design practical data integration solutions.
• Document integration solutions: Maintain clear technical documentation, including data flows, mappings, dependencies, schedules, troubleshooting steps, operational runbooks, and support procedures.
• Support modernization efforts: Help migrate legacy or on‑premises integration processes toward cloud‑native, maintainable, and well‑documented solutions using Azure and emerging Microsoft data platform capabilities.
• Apply modern development practices: Evaluate emerging technologies, automation opportunities, source control practices, Azure DevOps workflows, approved AI‑assisted development tools, and best practices across Azure, Microsoft Fabric, and enterprise data integration.

Required Qualifications:

• 3–5+ years of hands‑on experience in data integration, data engineering, ETL/ELT development, or a related technical role.
• Strong SQL skills, including advanced querying, data transformation, troubleshooting, and working with relational data structures.
• Hands‑on experience with Azure Cloud data services, including Azure Data Factory, Azure SQL Database or SQL Server, Azure Blob Storage, and related data movement or storage services.
• Experience building, supporting, optimizing, and troubleshooting production data pipelines, scheduled jobs, and integration workflows.
• Experience integrating data from a variety of source systems using APIs, FTP/SFTP, structured files, JSON, XML, CSV, or similar formats.
• Ability to diagnose data quality issues, reconcile source‑to‑target results, and resolve pipeline or integration failures through structured troubleshooting.
• Strong ownership mindset, learning orientation, documentation discipline, and willingness to work across technical and business teams.

• Able to perform all work related assigned job duties.

Preferred Qualifications:

• Familiarity with common database development tools, Git‑based source control, Azure DevOps, CI/CD practices, and AI‑assisted development workflows.
• Exposure to Microsoft Fabric concepts or tools, such as pipelines, lakehouses, warehouses, dataflows, or notebooks.
• SSIS experience, especially in environments modernizing legacy integrations to Azure‑based solutions.
• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related field preferred; equivalent hands‑on experience is also valued.
• Relevant certifications, such as Microsoft Azure Data Engineer or Microsoft Fabric credentials, are helpful but not required.

“This role requires regular, ongoing in‑office presence. Employees are expected to work onsite, which includes non-company locations where we conduct business, the majority of the time to support collaboration, productivity, and business operations according to the schedule set by supervisors and/or branch management.