AI-Driven Data & Systems Integration Specialist

Socket.dev; Pittsburgh (Allegheny County); On-site; USD 90,000 - 130,000; Full time

Job summary

IDOC is seeking a data and systems integration specialist to support multiple optical laboratories using DVI as the primary platform. You will manage data, reports, configurations, and business-process integrations across operations, developing scripts and automated workflows to improve efficiency and data visibility.

The role emphasizes AI-assisted development, API integration, and applying automation to reduce manual effort, with responsibilities spanning data quality, dashboards, and

Qualifications

• 5+ years of experience in application support, systems integration, data management, or software development.
• Experience with relational databases and data modeling concepts.
• Experience with SQL Server, JSON, XML, CSV, and flat-file data exchanges.

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.

Skills

Analytical thinking

Problem solving

Communication

Team collaboration

Education

Bachelor's degree in CS/IT or related

Tools

Microsoft SQL Server

SQL querying

REST APIs

JSON/XML/CSV

DVI laboratory management software

Job description

IDOC is seeking a data and systems integration specialist to support multiple optical laboratories using DVI as the primary platform. You will manage data, reports, configurations, and business-process integrations across operations, developing scripts and automated workflows to improve efficiency and data visibility.

The role emphasizes AI-assisted development, API integration, and applying automation to reduce manual effort, with responsibilities spanning data quality, dashboards, and