SQL & PHP Developer

Company:
Cogent Communications is a global, Tier 1 facilities-based ISP, consistently ranked as one of the top five networks in the world and is publicly traded on the NASDAQ Stock Market under the ticker symbol CCOI. Cogent specializes in providing businesses with high speed Internet access and Ethernet transport services. Cogent facilities-based, all-optical IP network backbone provides IP services globally. Since its inception, Cogent has unleashed the benefits of IP technology, building one of the largest and highest capacity IP networks in the world.

This network enables Cogent to offer large bandwidth connections at highly competitive prices. Cogent also offers superior customer support by virtue of its end-to-end control of service delivery and network monitoring. A competitive base salary and a full benefits package including;
Health, Dental, Vision, Paid Time Off (PTO), Short- and Long-Term Disability, Life Insurance, Holidays, Parental Leave, 401(k) plan with employer match, stock options, and an Employee Assistance Program. Most benefits take effect within 30 days of employment, and some require a waiting period.

The SQL & PHP Developer supports the development and maintenance of data-driven applications and business reporting solutions, with an initial focus on SQL query and stored procedure development. This role is responsible for creating, modifying, testing, troubleshooting, and optimizing SQL queries and stored procedures that support application functionality, reporting, dashboards, business analytics, and forecasting. Because the data produced through this work is used to support operational reporting, performance measurement, business analytics, and forecasting, accuracy, consistency, and an understanding of how data is used by the business are important aspects of the role.

As technical skills and knowledge of the applications grow, the position will progressively expand into PHP development, providing a clear path from SQL-focused development to broader back-end application development.

Starting / Initial Base Salary Pay Range: $65,000-$75,000/yr. Specific offers within the listed pay ranges are determined by a variety of factors such as experience, education, skills, certifications and business needs.

• 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,…