Programmer at Perr&Knight in Charlotte, NC

Summary: 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. 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 Required Qualifications: - 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 Required Skills: SQL Programming, Application Programming, ETL Software Important Skills: Database Performance Optimization, Data Model Design Nice-to-Have Skills: Unit Testing 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