SQL & PHP Backend Developer — Data-Driven & Growth Path

Cogent Communication; Washington (District of Columbia); On-site; USD 65,000 - 75,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

Paid Time Off (PTO)

Short-Term Disability

Long-Term Disability

Life Insurance

Holidays

Parental Leave

401(k) plan with employer match

Stock options

Employee Assistance Program

Job summary

Cogent Communications is seeking a SQL & PHP Developer to support the development and maintenance of data-driven applications, focusing initially on SQL query and stored procedure development. The role expands into PHP development as expertise grows, with emphasis on accuracy, analytics, dashboards, and forecasting.

The position involves creating, testing, and optimizing SQL queries and procedures to support operational reporting, business analytics, and forecasting, while ensuring data quality

Qualifications

• Associate degree, bachelor’s degree, technical certification, or comparable hands-on experience in computer science or IT.
• 2+ years of SQL Server experience with joins, subqueries, aggregate functions, grouping, conditional logic, and data manipulation techniques.
• 1+ years of PHP web development experience.
• 1+ years of experience with the Laravel Framework.
• Understanding of relational database concepts, including tables, views, relationships, primary and foreign keys, data types, and normalization concepts.
• Familiarity with developing and modifying stored procedures using parameters, variables, conditional logic, temporary data structures, and result sets.
• Ability to analyze, troubleshoot, and modify existing queries and stored procedures while maintaining data accuracy and considering query performance and downstream dependencies.
• Ability to communicate effectively with technical and non-technical team members, learn existing application and business logic, and progress from SQL development into PHP and back-end application development.

Responsibilities

• Support applications, reporting, dashboards, analytics, and other business processes.
• Analyze existing SQL queries and stored procedures to understand business logic, data relationships, dependencies, and expected results.
• Create efficient queries that retrieve, transform, aggregate, and organize data according to application and business requirements.
• Troubleshoot incorrect, incomplete, duplicate, or unexpected query results and identify issues within SQL logic, stored procedures, or application interactions.
• Modify and enhance existing stored procedures as application functionality and business requirements change.
• Test SQL changes to confirm data accuracy, expected functionality, and appropriate performance before implementation.
• Review and optimize queries and stored procedures to improve efficiency and reduce unnecessary processing.
• Understand how data generated by queries and stored procedures is consumed by downstream applications, dashboards, reports, analytics, and forecasting processes.
• Work with business and technical team members to understand reporting and analytical requirements and translate those requirements into appropriate SQL logic.
• Recognize the business impact of data quality and ensure that SQL development produces accurate, consistent, and reliable results for operational and analytical use.
• Support data used in dashboards that help business users monitor key performance indicators, identify trends, evaluate performance, and make informed operational and strategic decisions.
• Assist with the development and maintenance of data processes that support historical analysis, business forecasting, and other analytical activities.
• Document stored procedures, complex queries, business rules, data logic, dependencies, and technical changes as appropriate.
• Use source control and established development, testing, code review, and deployment practices.
• Review existing PHP application code to understand how applications execute stored procedures, process returned data, and present information to users.
• Progress from SQL-focused assignments into PHP development tasks as knowledge of the applications, business processes, and development environment grows.
• Develop, troubleshoot, and enhance PHP application functionality under the guidance of experienced developers.
• Take on increasingly independent SQL and PHP development responsibilities as technical proficiency and system knowledge grow.
• Participate in code reviews and incorporate feedback to improve code quality, maintainability, performance, and development practices.

Skills

SQL querying

PHP development

HTML/CSS/JavaScript

Analytical thinking

Communication

Education

Associate degree or higher in CS/IT

Tools

Laravel Framework

Job description

Cogent Communications is seeking a SQL & PHP Developer to support the development and maintenance of data-driven applications, focusing initially on SQL query and stored procedure development. The role expands into PHP development as expertise grows, with emphasis on accuracy, analytics, dashboards, and forecasting.

The position involves creating, testing, and optimizing SQL queries and procedures to support operational reporting, business analytics, and forecasting, while ensuring data quality