Programmer

Perr&Knight

6d • $80,000 - $90,000 • Hybrid

About The Position

Perr&Knight is seeking a Programmer to join our PK1Cloud team to support our data processing needs. This position will work hybrid from one of our offices in Newark, NJ, Charlotte, NC, or Boca Raton, FL.

Requirements

• BA or BS degree
• 1.5 years of related experience
• Intermediate SQL Programming
• Intermediate Application Programming (VB, C, C#, PHP, JAVA)
• Intermediate Microsoft Products
• Intermediate Extract, Transform and Load (ETL) Software

Responsibilities

• Designing, developing, and maintaining complex SQL queries, stored procedures, functions, and views to support data processing and reporting needs.
• Building and enhancing ETL workflows to extract, transform, and load data from various internal and external systems.
• Developing scalable and efficient data transformation logic to support business requirements.
• Creating and maintaining staging tables, integration layers, and curated datasets for downstream consumption.
• Optimizing database performance through query tuning, indexing strategies, and execution plan analysis.
• Participating in data model design and contribute to improving database structure and maintainability.
• Troubleshooting and resolving data quality and performance issues within ETL processes and database environments.
• Assisting in deploying database changes across development, staging, and production environments.
• Collaborating with business analysts and application developers to translate functional requirements into technical solutions.
• Performing unit testing and support system and user acceptance testing for new enhancements.
• Maintaining clear documentation of database objects, ETL workflows, and technical design decisions.
• Adhering to coding standards, version control practices, and change management procedures.

Benefits

• Friendly, dynamic work environment – Includes certification as a Great Place to Work® (five years in a row!) along with Climate Neutral Status
• Competitive salary including merit-based bonus plan
• Flexible Work Program
• Clear opportunities for career progression
• Company-funded professional educational program
• Visible management commitment to our company core values of: Diversity & Inclusion, Environmental, Community and Employee Wellbeing, Excellent Work Product, Innovation, Integrity and Superior Customer Experience
• Medical, dental, and vision insurance
• Company-paid life insurance
• 401K with matching Company contributions
• PTO
• Community Support Program including VTO and donations with Company match
• Employee Recognition Program

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level