Perrknight is looking for a Programmer to join our PK1Cloud team. You will be responsible for supporting critical data processing needs by designing and maintaining SQL queries, building ETL workflows, and optimizing database performance.
What You'll Do
- Design, develop, and maintain complex SQL queries, stored procedures, functions, and views to support data processing and reporting needs.
- Build and enhance ETL workflows to extract, transform, and load data from various internal and external systems.
- Develop scalable and efficient data transformation logic to support business requirements.
- Create and maintain staging tables, integration layers, and curated datasets for downstream consumption.
- Optimize database performance through query tuning, indexing strategies, and execution plan analysis.
- Participate in data model design and contribute to improving database structure and maintainability.
- Troubleshoot and resolve data quality and performance issues within ETL processes and database environments.
- Assist in deploying database changes across development, staging, and production environments.
- Collaborate with business analysts and application developers to translate functional requirements into technical solutions.
- Perform unit testing and support system and user acceptance testing for new enhancements.
- Maintain clear documentation of database objects, ETL workflows, and technical design decisions.
- Adhere to coding standards, version control practices, and change management procedures.
What We're Looking For
- A BA or BS degree.
- 1.5 years of related experience.
- Intermediate SQL Programming skills.
- Intermediate Application Programming skills (VB, C, C#, PHP, JAVA).
- Intermediate Microsoft Products skills.
- Intermediate Extract, Transform and Load (ETL) Software skills.
Technical Stack
- SQL
- VB
- C
- C#
- PHP
- JAVA
- Microsoft Products
- ETL Software
Team & Environment
You will be part of the PK1Cloud team at Perrknight, a company with a friendly, dynamic work environment. We are certified as a Great Place to Work for five years running, hold Climate Neutral Status, and core values centered on Diversity & Inclusion, Environmental, Community and Employee Wellbeing, Excellent Work Product, Innovation, Integrity and Superior Customer Experience.
Benefits & Compensation
- 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-funded professional educational program.
- Competitive salary including merit-based bonus plan.
Work Mode
This is a hybrid role with offices in Newark, NJ; Charlotte, NC; and Boca Raton, FL.
Perr&Knight is an equal opportunity employer and committed to inclusion and diversity. Perr&Knight does not discriminate in employment on account of race, color, religion, national origin, citizenship status, ancestry, age, sex/gender, sexual orientation, gender identity, marital status, physical or mental disability, Veteran status, or other legally protected characteristics.
