Data Integration & AI Automation Engineer

Socket.dev; Scottsdale (AZ); On-site; USD 90,000 - 140,000; Full time

Job summary

IDOC, a leading alliance serving independent optometric practice owners in the United States, seeks an experienced professional to support data, reporting, and integration across laboratory operations using DVI as the primary platform. The role develops integrations, scripts, and automated workflows to translate data into actionable business insights and to improve efficiency and accuracy.

The position emphasizes AI-assisted development, modern automation, and continuous improvement to

Qualifications

• 5+ years in application support, systems integration, data management, or software development.
• Strong understanding of relational databases and data modeling concepts.
• Experience with JSON, XML, CSV, and flat-file data exchanges.
• Experience scripting with PowerShell, Python, JavaScript, VBScript or shell scripting.
• Familiarity with REST APIs and data integration concepts.

Responsibilities

• Data extraction, transformation, and presentation from DVI and related systems.
• Develop recurring and ad hoc reports for operations, production, finance, sales and management.
• Create dashboards, KPIs, and data visualizations for different audiences.
• Develop, maintain, and troubleshoot integrations between DVI and external systems.
• Assist with application development, documentation, training, and knowledge transfer.
• Leverage AI tools across the development lifecycle for requirements, design, code generation, and QA.

Skills

SQL Server

JSON/XML/CSV

Scripting: PowerShell

Python

JavaScript

VBScript

Shell scripting

REST APIs

Data transformation

ETL / Data warehousing

Job description

IDOC, a leading alliance serving independent optometric practice owners in the United States, seeks an experienced professional to support data, reporting, and integration across laboratory operations using DVI as the primary platform. The role develops integrations, scripts, and automated workflows to translate data into actionable business insights and to improve efficiency and accuracy.

The position emphasizes AI-assisted development, modern automation, and continuous improvement to