
Programmer
Perr&Knight
full-time
Posted on:
Location Type: Hybrid
Location: Florida • New Jersey • United States
Visit company websiteExplore more
Salary
💰 $80,000 - $90,000 per year
Job Level
About the role
- 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.
Requirements
- 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
- Friendly, dynamic work environment – Includes certification as a Great Place to Work® (five years in a row!) along with Climate Neutral Status
- Competitive salary including merit-based bonus plan
- Flexible Work Program
- Clear opportunities for career progression
- Company-funded professional educational program
- Visible management commitment to our company core values of: Diversity & Inclusion, Environmental, Community and Employee Wellbeing, Excellent Work Product, Innovation, Integrity and Superior Customer Experience
- Generous benefits including:
- 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
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
SQLETLVBCC#PHPJAVAdata transformationquery tuningdatabase performance
Soft Skills
collaborationtroubleshootingdocumentationcommunicationproblem-solving
Certifications
BA degreeBS degree