Applications & Data Integration Specialist
IDOC
Get more replies from employers
Send a job-specific resume in minutes.
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
Tools
Job description
For more than twenty-five years, IDOC has remained committed to the success of independent optometrists and has become the leading alliance of private optometric practice owners in the United States. Founded by an optometrist with first-hand experience in private practice, IDOC empowers independent owners to change lives through better sight.
For more than twenty-five years, IDOC has remained committed to the success of independent optometrists and has become the leading alliance of private optometric practice owners in the United States. Founded by an optometrist with first-hand experience in private practice, IDOC empowers independent owners to change lives through better sight. Our core value - people first, always - combined with a focus on innovation gives our network of more than 3,200 optometrists a significant competitive advantage. IDOC supports members through industry-respected consultants, business analytics, dedicated account management, vendor partnerships, continuing education, and peer networking. We are proud to be a Great Place to Work-Certified™ organization, offering a collaborative and empowering environment for professionals who want to make a difference.
At IDOC, we empower independent owners to change lives through better sight. Every event we host is designed to strengthen relationships, provide valuable education, and create memorable experiences for our members and partners. This role supports multiple optical manufacturing laboratories using DVI as their primary laboratory management platform. It manages and improves data, reporting, application configuration, and business-process integrations across laboratory operations. The role develops and maintains integrations, scripts, and automated workflows; translates laboratory and operational data into actionable business insight; and resolves complex system and data issues across multiple sources. The position also supports the ongoing development and optimization of applications and operational processes, improving efficiency, accuracy, and visibility across the organization. It uses modern automation and AI-enabled development tools to strengthen solution design, delivery quality, and continuous improvement.
- 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, pricing changes, and related DVI configurations.
- Assist users with troubleshooting and functional support related to DVI processes.
- Implement and document workflow enhancements. system configurations and operational procedures.
- Develop, maintain, and troubleshoot integrations between DVI and external systems.
- Support APIs, import/export processes, automated file exchanges, and middleware solutions.
- Maintain and create scripts and automated workflows that improve reduce manual effort and improve quality for data processing, automation, monitoring, and synchronization.
- Design and implement solutions for handling JSON, XML, CSV, flat-file, and other structured data formats.
- Work with proprietary and commercial applications used throughout the organization.
- Troubleshoot application issues and coordinate resolutions with vendors and internal stakeholders.
- Participate in testing, deployment, and change management activities.
- Assist with application development, documentation, training, and knowledge transfer.
- Requirements gathering
- Solution design
- Code generation
- Documentation
- Testing
- Quality assurance
- Identify opportunities where AI can improve operational efficiency and development productivity.
- Evaluate and implement emerging technologies that support business objectives.
- All other responsibilities and/or other related duties as assigned.
- 5+ years of experience in application support, systems integration, data management, or software development.
- Strong applied understanding of relational databases and data modeling concepts.
- Experience working with:
- Microsoft SQL Server
- SQL querying and stored procedures
- Relational database systems (RDBMS)
- JSON
- XML
- CSV and delimited files
- Flat-file data exchanges
Experience developing and maintaining scripts using one or more scripting languages such as:
- PowerShell
- Python
- JavaScript
- VBScript
- Shell scripting
Working knowledge with REST APIs and data integration concepts.
- Experience troubleshooting data and application issues.
- Experience supporting DVI laboratory management software.
- Experience within:
- Optical laboratories
- Manufacturing environments
- Healthcare technology
- Production operations
- Experience with:
- ETL processes
- Data warehousing
- Business Intelligence tools
- Reporting platforms
- Experience integrating SaaS applications through APIs.
- Familiarity with source control systems and software development best practices.
- Experience supporting cloud-based platforms and services.
Candidates should be prepared to discuss and demonstrate:
- How they currently use AI tools in their daily work.
- Examples of AI-assisted development projects.
- Approaches to using AI for:
- Requirements analysis
- Data transformation
- Script development
- Testing and QA
- Documentation generation
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
