Programmer

🌍 Remote, USA 🎯 Full-time 🕐 Posted Recently

Job Description

Perr&Knight is seeking a Programmer to join our PK1Cloud team to support our data processing needs. This role involves designing and maintaining SQL queries and ETL workflows to enhance data processing and reporting capabilities.

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

Skills

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

Benefits

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

Company Overview

Perr&Knight provides insurance consulting and software solutions. It was founded in 1994, and is headquartered in Boca Raton, Florida, USA, with a workforce of 51-200 employees. Its website is https://www.perrknight.com.

Company H1B Sponsorship

Perr&Knight has a track record of offering H1B sponsorships, with 2 in 2025, 2 in 2024, 1 in 2023, 1 in 2022, 2 in 2021. Please note that this does not guarantee sponsorship for this specific role.

Apply To This Job