Applications & Data Integration Specialist
IDOC
Get more replies from employers
Send a job-specific resume in minutes.
Job summary
IDOC is seeking a seasoned data and systems specialist to support multiple optical manufacturing laboratories using DVI. You will develop reports, dashboards, and automated workflows, integrate data from JSON, XML, CSV, and other sources, and translate operations data into actionable insights.
The role emphasizes AI-assisted development, process improvement, and cross-functional collaboration across IT and operations.
Qualifications
- 5+ years of experience in application support, data management, or software development.
- Strong understanding of relational databases and data modeling.
- Experience with SQL querying and stored procedures.
- Experience processing JSON, XML, CSV, and flat-file data.
Responsibilities
- Extract, transform, and present data from DVI and related systems.
- Develop recurring and ad hoc reports for operations, finance, sales, and management.
- Create dashboards and KPIs for diverse audiences.
- Validate data accuracy and reconcile information across systems.
- Improve data integrity and single-source of-truth reporting.
- Develop and maintain integrations between DVI and external systems.
- Support APIs, import/export processes, and automation workflows.
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}
