What are the responsibilities and job description for the Programmer position at Perr&Knight?
What We'll Bring to the Table:
What You'll Be Doing:
For over 30 years, Perr&Knight has provided exemplary insurance consulting and software solutions to the property & casualty and life, accident & health industries. Services include actuarial consulting, risk strategies & solutions, applied AI consulting, product development, insurance policy and forms consulting, regulatory compliance, compliance and operational assessments/training, state filings, licensing, technology consulting, statistical reporting, data services, predictive analytics, and bureau monitoring & maintenance. Software includes StateFilings.com, the leading cloud-based state filings management solution. With offices nationwide and more than 150 insurance professionals, including 30 credentialed actuaries, Perr&Knight is among the largest independent actuarial and insurance consulting firms in the United States.
Our mission as an actuarial and insurance operations consulting firm is to provide extraordinary value to our clients by offering innovative and unique solutions to complex challenges they face while providing a positive and motivating work environment for our employees that respects diversity and recognizes ingenuity and hard work.
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. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements.
Perr&Knight will also provide reasonable accommodation to qualified individuals with disabilities, in accordance with applicable laws. If you need to inquire about an accommodation, or need assistance with completing the application process, please email accommodations@perrknight.com
- 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
What You'll Be Doing:
- 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
- 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
For over 30 years, Perr&Knight has provided exemplary insurance consulting and software solutions to the property & casualty and life, accident & health industries. Services include actuarial consulting, risk strategies & solutions, applied AI consulting, product development, insurance policy and forms consulting, regulatory compliance, compliance and operational assessments/training, state filings, licensing, technology consulting, statistical reporting, data services, predictive analytics, and bureau monitoring & maintenance. Software includes StateFilings.com, the leading cloud-based state filings management solution. With offices nationwide and more than 150 insurance professionals, including 30 credentialed actuaries, Perr&Knight is among the largest independent actuarial and insurance consulting firms in the United States.
Our mission as an actuarial and insurance operations consulting firm is to provide extraordinary value to our clients by offering innovative and unique solutions to complex challenges they face while providing a positive and motivating work environment for our employees that respects diversity and recognizes ingenuity and hard work.
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. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements.
Perr&Knight will also provide reasonable accommodation to qualified individuals with disabilities, in accordance with applicable laws. If you need to inquire about an accommodation, or need assistance with completing the application process, please email accommodations@perrknight.com
Salary : $80,000 - $90,000