Position: Application & SQL Developer
Discipline: Systems & Platforms
Position Type: Full Time, Exempt
Location: Hybrid; Candidates must live within commuting distance of Columbus/Gahanna, OH
Phillips & Cohen Associates, LLC the global leader in estate account management with operations in the United States, United Kingdom, Canada, Australia, and New Zealand, seeks an Application & SQL Developer to join our team.
Reporting to the Senior Systems & Data Developer, the Application & SQL Developer supports internally developed business applications by combining hands-on software development with ongoing production support and maintenance. Using Microsoft SQL, Visual Studio, and VB.NET, this role develops and enhances applications, troubleshoots production issues, investigates defects and system anomalies, and provides support throughout the application lifecycle. Success in this role requires the ability to balance development initiatives with a significant and ongoing application-support workload, take ownership of issues through resolution, proactively identify risks and improvement opportunities, and build strong partnerships with both technical and non-technical stakeholders. The ideal candidate is a curious, analytical problem-solver who communicates effectively, exercises sound judgment during troubleshooting and is comfortable navigating both project-based work and day-to-day operational support.
This position operates in a hybrid work environment and requires employees to reside within a reasonable commuting distance of our Columbus/Gahanna, OH office.
Responsibilities:
- Develop, enhance, test, and maintain internal business applications and user interfaces using Microsoft SQL, Visual Studio, and VB.NET.
- Balance development assignments with ongoing production support and maintenance activities across the application lifecycle.
- Troubleshoot production issues, investigate application defects and system anomalies, identify root causes, communicate status updates, and drive issues through resolution.
- Proactively identify unusual results, data discrepancies, application defects, operational risks, and opportunities for process or system improvements, escalating concerns when appropriate.
- Partner with internal business operations teams and developers to gather requirements, understand business challenges, and deliver practical technical solutions.
- Build productive relationships with business users and communicate technical concepts, issues, and recommendations clearly to both technical and non-technical stakeholders.
- Perform data profiling, source-to-target mapping, querying, aggregation, and transformation using SQL, T-SQL, JSON, and related tools.
- Support the design, development, implementation, and maintenance of ETL processes, stored procedures, controls, and exception handling.
- Review existing production environments with senior developers to promote consistent, reliable workflows and adherence to departmental and company standards.
- Communicate progress, risks, and recommended solutions clearly to stakeholders, ensuring transparency and alignment throughout development and support activities.
Minimum Qualifications:
- Three to five years of experience working with Microsoft SQL Server databases, including query development, performance troubleshooting, and data transformation.
- Software development experience using Visual Studio and VB.NET or a comparable object-oriented language.
- Working knowledge of relational database principles and application development practices.
- Demonstrated troubleshooting and debugging skills, including the ability to investigate issues, determine root causes, and exercise sound judgment in resolving production problems.
- Experience supporting or maintaining applications in a production environment.
- Strong analytical and problem-solving skills, with a proactive approach to identifying risks, defects, and opportunities for improvement.
- Ability to manage competing development and support priorities while maintaining attention to detail and accountability for outcomes.
- Strong communication and interpersonal skills, including the ability to build effective relationships and explain technical information to non-technical stakeholders.
- A proactive approach, with demonstrated ownership, accountability, curiosity, and willingness to learn new technologies.
Preferred Qualifications:
- Exposure to JSON, XML, data migration, data integration, ETL processes, or stored procedures.
- Experience working with business users to gather requirements or translate operational needs into technical solutions.
- Experience with change management, application deployment, or production controls and exception management.
- Bachelor's degree in Computer Science, Information Systems, MIS, or a related field.
Core Competencies:
- Manages Complexity
- Decision Quality
- Ensures Accountability
- Business Insight
- Communicates Effectively
- Manages Ambiguity
- Collaborates
- Nimble Learning
- Action Oriented
- Self-Development
Please note: Applicants must be eligible to work in the U.S. without employer sponsorship, now or in the future.
About Phillips & Cohen Associates, Ltd.
PCA provides Equal Employment Opportunity for all individuals regardless of race, color, religion, gender, age, national origin, disability, marital status, sexual orientation, veteran status, genetic information and any other basis protected by federal, state or local laws and reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of our jobs.
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.
Skills Required
- Three to five years of experience working with Microsoft SQL Server databases, including query development, performance troubleshooting, and data transformation.
- Software development experience using Visual Studio and VB.NET or a comparable object-oriented language.
- Working knowledge of relational database principles and application development practices.
- Demonstrated troubleshooting and debugging skills, including investigating issues, determining root causes, and resolving production problems.
- Experience supporting or maintaining applications in a production environment.
- Strong analytical and problem-solving skills with a proactive approach to identifying risks, defects, and improvement opportunities.
- Ability to manage competing development and support priorities while maintaining attention to detail and accountability.
- Strong communication and interpersonal skills, including explaining technical information to non-technical stakeholders.
- Proactive approach with ownership, accountability, curiosity, and willingness to learn new technologies.
- Exposure to JSON, XML, data migration, data integration, ETL processes, or stored procedures.
- Experience gathering requirements from business users or translating operational needs into technical solutions.
- Experience with change management, application deployment, or production controls and exception management.
- Bachelor's degree in Computer Science, Information Systems, MIS, or a related field.
What We Do
A Reputation for Results Phillips & Cohen Associates has built a successful and rapidly growing business by delivering industry-leading collections results while simultaneously enhancing the brand of each individual client. Phillips & Cohen Associates was formed in 1997 and quickly established a reputation as a responsible and trusted partner to industry leaders around the world. We have three regional offices in the United States (including a dedicated analytics center) and international offices in Manchester United Kingdom, Quebec Canada, Melbourne Australia, and Madrid Spain. Our business has achieved national and international prominence by providing highly effective financial recovery services that include compassionate Deceased Care and Probate, Pre- and Post Charge-Off Credit Card, Business Card, Consumer Retail, Debt Management, and Cease and Desist solutions. Our clients range from mid-sized firms to leading national and international creditor and banking institutions. We serve the consumer credit industry, banking and loan marketplace, as well as specialized industries including healthcare, utility, education, and telecom. Our management includes in-house attorneys who understand the legal process and the evolving statutes that govern our industry. We play leadership roles in our industry’s principle trade groups in America and internationally. And we continually set new standards for technological and service innovation.
