Full Stack Web Developer - IN OFFICE BROOKLYN, NY

Full Stack Web Developer This Position is ON SITE in Brooklyn, NY 11218. All applicants MUST be able to commute to our office location. IF YOU REQUIRE ANY CURRENT OR FUTURE SPONSORSHIP PLEASE DO NOT APPLY. About Us 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. Role Overview 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. Key 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 Required Qualifications • 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 Preferred Qualifications • 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 What We Offer • Competitive salary and comprehensive benefits package • A key contributor role on the ongoing development of our ERP system, Spex • Professional development support, including training and certifications • A collaborative, innovative culture that celebrates ownership and continuous improvement If you’re a proactive Full Stack Developer who thrives in a team environment and is passionate about building end‑to‑end solutions, we’d love to hear from you. Job Type: Full-time Pay: $70,000.00 - $90,000.00 per year Benefits: • 401(k) 2% match • 401(k) matching • Dental insurance • Health insurance • Paid holidays • Paid sick time • Paid time off • Vision insurance Compensation Package: • Performance bonus • Yearly pay Schedule: • 8 hour shift Ability to Commute: • Brooklyn, NY 11218 (Required) Work Location: In person