Programmer

Perr&Knight is a leading insurance consulting and software solutions provider, seeking a Programmer to join their PK1Cloud team. The role involves designing, developing, and maintaining SQL queries and ETL workflows to support data processing and reporting needs.

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

Company H1B Sponsorship