Signal49 Research

Full-stack Engineer

• Design and build interactive, database-driven web dashboards and reporting pages using PHP, MySQL, HTML, CSS, and TypeScript (including JavaScript).
• Integrate data visualization libraries (e.g., Chart.js) to render timelines, bar charts, rankings, and other analytical views.
• Write optimized SQL queries involving multi-table JOINs, embedded queries, aggregations, GROUP BY, and filtered result sets.
• Develop reusable PHP components and include files (e.g., database connection helpers, shared layouts).
• Ensure all output is properly sanitized and escaped to prevent XSS and SQL injection vulnerabilities.
• Use Claude (Anthropic) to generate PHP, SQL, TypeScript, JavaScript, HTML, and CSS code from detailed technical specifications.
• Write precise, well-structured AI prompts that outline detailed technical specifications and requirements, to produce accurate and complete code with minimal iteration.
• Critically review all AI-generated code for correctness, security, performance, and adherence to project standards.
• Test generated code in the live server environment, identify discrepancies, and apply targeted corrections.
• Meet with internal clients to gather, clarify, and document functional requirements for new dashboards and reporting features.
• Propose technical approaches and explain trade-offs in plain language accessible to non-technical stakeholders.
• Deploy and manage PHP web applications on Ubuntu Linux servers with Nginx or Apache.

Full Stack Developer – 6-month contract