AI-Driven Data & Application Integrations Specialist

IDOC; Scottsdale (AZ); On-site; USD 90,000 - 130,000; Full time

Job summary

IDOC in Scottsdale, AZ is seeking an experienced systems integrator and data specialist to support multiple optical laboratories via DVI. You’ll develop data workflows, APIs, and automated processes to improve accuracy, efficiency, and visibility across the organization.

The role emphasizes AI-assisted development, script-driven automation, and data-driven decision support for operations, production, and finance teams.

Qualifications

• 5+ years of experience in application support, systems integration, data management, or software development.
• Strong understanding of relational databases and data modeling concepts.
• Experience with Microsoft SQL Server, SQL querying and stored procedures.
• Experience with REST APIs and data integration concepts.
• Experience with scripting languages: PowerShell, Python, JavaScript, VBScript, Shell scripting.
• Experience handling JSON, XML, CSV, and other structured data formats.

Responsibilities

• Extract, transform, and present data from DVI and related systems.
• Develop recurring and ad hoc reports for operations, production, finance, sales, and management teams.
• Create dashboards, KPIs, and data visualizations for different audiences.
• Validate data accuracy and reconcile information across multiple systems.
• Improve data integrity and 'single source of truth' reporting.
• Maintain pricing tables, product catalogs, translation tables, and DVI configurations.
• Assist users with troubleshooting and functional support related to DVI processes.
• Develop, maintain, and troubleshoot integrations between DVI and external systems.
• Support APIs, import/export processes, automated file exchanges, and middleware solutions.
• Design and implement AI-assisted development and process improvement initiatives.

Skills

Data integration

SQL Server

Data modeling

REST APIs

Scripting

Tools

PowerShell

Python

JavaScript

VBScript

Shell scripting

Job description

IDOC in Scottsdale, AZ is seeking an experienced systems integrator and data specialist to support multiple optical laboratories via DVI. You’ll develop data workflows, APIs, and automated processes to improve accuracy, efficiency, and visibility across the organization.

The role emphasizes AI-assisted development, script-driven automation, and data-driven decision support for operations, production, and finance teams.