Programmer

Perr&Knight is seeking a Programmer to join their PK1Cloud team to support data processing needs. The role involves designing, developing, and maintaining SQL queries and ETL workflows to enhance data processing and reporting capabilities.ResponsibilitiesDesigning, developing, and maintaining complex SQL queries, stored procedures, functions, and views to support data processing and reporting needsBuilding and enhancing ETL workflows to extract, transform, and load data from various internal and external systemsDeveloping scalable and efficient data transformation logic to support business requirementsCreating and maintaining staging tables, integration layers, and curated datasets for downstream consumptionOptimizing database performance through query tuning, indexing strategies, and execution plan analysisParticipating in data model design and contribute to improving database structure and maintainabilityTroubleshooting and resolving data quality and performance issues within ETL processes and database environmentsAssisting in deploying database changes across development, staging, and production environmentsCollaborating with business analysts and application developers to translate functional requirements into technical solutionsPerforming unit testing and support system and user acceptance testing for new enhancementsMaintaining clear documentation of database objects, ETL workflows, and technical design decisionsAdhering to coding standards, version control practices, and change management proceduresSkillsBA or BS degree1.5 years of related experienceIntermediate SQL ProgrammingIntermediate Application Programming (VB, C, C#, PHP, JAVA)Intermediate Microsoft ProductsIntermediate Extract, Transform and Load (ETL) SoftwareBenefitsMedical, dental, and vision insuranceCompany-paid life insurance401K with matching Company contributionsPTOCommunity Support Program including VTO and donations with Company matchEmployee Recognition ProgramCompany OverviewPerr&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 SponsorshipPerr&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