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