About the Role
We’re seeking a results-driven Full Stack Developer to join our engineering team and work alongside our technical lead on critical data and application solutions across our e-commerce and operational platforms. Your primary focus will be enhancing and maintaining our proprietary ERP / CRM system (SPEX), building ETL pipelines, backend services, and BI dashboards to ensure data accuracy, performance, and usability.
Responsibilities
- Contribute to the design, development, and enhancement of our proprietary ERP (Spex), delivering intuitive and responsive experiences for internal users
- Build and deploy ETL pipelines using PHP and MySQL to feed data warehouses and analytics platforms
- Develop backend services and APIs in Laravel to support internal workflows and tools
- Create responsive frontend components with Vue.js and Bootstrap for dashboards and internal applications
- Implement and maintain data models in MySQL, and collaborate on SQL Server/SSIS integrations as needed
- Monitor and troubleshoot error rates, performance bottlenecks, and security issues across applications, databases, and infrastructure
- Work with Content, Platforms, Purchasing, and other teams to gather requirements and deliver enhancements on an agile cadence
- Document system designs, data flows, API contracts, and deployment procedures to ensure maintainability
Requirements
- 5+ years of professional software development experience
- Proficiency in at least one programming language and one SQL dialect
- Familiarity with PHP, MySQL, JavaScript, and modern version control tools (e.g. Git)
- Hands-on experience with relational databases and data-warehousing principles
- Exposure to CI/CD pipelines and automated testing frameworks
- Excellent problem-solving skills and the ability to take ownership of projects end-to-end
- 3+ years with PHP and the Laravel framework
- 3+ years with MySQL schema design and optimization
- 3+ years with JavaScript frameworks, especially Vue.js (or similar)
- Experience with SQL Server & SSIS
Skills
- PHP
- MySQL
- JavaScript
- Git
- Laravel
- Vue.js
- Bootstrap
- SQL Server
- SSIS
Location
- Brooklyn, NY 11218
Work Type
- Onsite
- Full-time
Experience Level
- Mid Level
- 5+ years
Benefits
- Competitive salary and comprehensive benefits package
- Professional development support, including training and certifications
About the Company
- At Focus Camera, we fuel creativity, support our partners, and deliver an exceptional customer experience. Guided by our core values—teamwork, responsibility, excellence, adaptability, and results—we collaborate to build robust, scalable solutions that drive growth and empower our teams.
