Who We Are
For over 70 years, Glatfelter Insurance Group has believed in doing the right thing for our clients, agents, communities and associates. This founding principle has enabled Glatfelter to grow from the kitchen-table, one-man-operation as it began, to one of the largest managing general agencies in the U.S. with nearly 500 associates across the country, a distribution network of over 4,500 independent brokers and more than 30,000 clients. It is what drives us to innovate—the desire to deliver the best for our clients. Founded as The Glatfelter Agency, which is still in operation, the program basis of Glatfelter Insurance Group, Volunteer Firemen’s Insurance Services (VFIS), was founded in 1969. Throughout the years, Glatfelter has expanded to include specialized program business inclusive of public entities, educational institutions, healthcare facilities, and religious organizations. Glatfelter provides their insureds with comprehensive insurance solutions including property, casualty, life insurance, and more. In 2018, Glatfelter joined American International Group (AIG) and is now part of the AIG family.
About the Position
Glatfelter Insurance Group is seeking a Programmer/Data Analyst to provide programming and data analysis support in developing and maintaining all actuarial data, databases, reports, and analyses. Under general supervision, this position participates in or develops system specifications and prepares, modifies or enhances computer programs for business, reporting, and information capture. This position is required to be onsite at our Leader Height’s office.
Key Responsibilities
- Develop and maintain actuarial databases and reports to support actuarial analysis and reporting
- Evaluate existing processes to improve efficiency
- Produce monthly, quarterly, and annual senior management reports for each program
- Design and code programs for new reports as requested by management
- Provide support in preparing data for semi-annual rate indications, rate reviews, auto impact analyses, and other actuarial analyses as required
- Maintains rate change history database
- Provides support for the renewal pricing worksheets and responding to questions from Underwriting departments related to the pricing worksheets
- Provides support to Program Analytics Manager in maintaining the rate indications and programming enhancements as necessary
- Respond to data requests by querying the data warehouse and providing reports with the requested information
- Fulfill data requests submitted by our consultants, auditors and/or insurance company partner associates
- Provide support in preparing quarterly and annual incurred loss, paid loss and claim count triangles, and other actuarial reports by line of business, both at a program and state level
- Work closely with IT applications staff to define and test system problems and/or changes to the data warehouse
- Provide support in determining back-end system and data warehouse coding requirements resulting from product changes or new programs
- Take advantage of opportunities for professional growth and continuing education
- Maintain a high level of confidentiality and a professional demeanor in the performance of duties
What We’re Looking For
- B.S. in Economics, Mathematics, Statistics, Actuarial Science, Business or Management Information Systems, or Computer Science from an accredited college or university
- Minimum of two (2) years property and casualty insurance company or agency experience.
- Proficient in use of personal computer and use of software applications for word processing, spreadsheets (including Visual Basic) and database management/manipulation.
- Experience with MS Office Suite products and programming languages required.
- Experience with programming in SQL required
- Experience with data warehouse preferred
- Strong computer and programming skills
- Strong numerical/analytical ability
- Strong problem solving skills
- Strong verbal and written communication ability
- Strong preference for activities involving attention to detail, accuracy and timely completion
- Strong sense of organization, follow through and goal achievement
- Ability to maintain confidentiality with respect to company trade secrets and proprietary information.
- Desire to maintain and expand level of technical skills and professional demeanor.
Why Choose Glatfelter?
Glatfelter is honored to have been named a Best Place to Work in PA since 2005. We are proud to offer a range of employee benefits and resources that help you protect what matters most - your health care, savings, financial protection and wellbeing. In addition to 17 paid holidays, (which includes a personal holiday and mental health and wellness day) we provide a variety of leaves for personal, health, family, and volunteer needs.
We believe in fostering our associates' development and offer a range of learning opportunities for associates to hone their professional skills to position themselves for the next steps of their careers. We have a tuition reimbursement program for eligible associates to enhance their education, skills, and knowledge in areas that relate to their current position or future positions to which they may transfer or progress.
Equal Opportunity Employer
It has been and will continue to be the policy of Glatfelter Insurance Group to be an Equal Opportunity Employer. We provide equal opportunity to all qualified individuals regardless of race, color, religion, age, gender, gender expression, national origin, veteran status, disability or any other legally protected categories. At Glatfelter, we believe that diversity and inclusion are critical to our future and our mission – creating a foundation for a creative workplace that leads to innovation, growth, and profitability. Glatfelter is committed to working with and providing reasonable accommodations to job applicants and employees with physical or mental disabilities. If you believe you need a reasonable accommodation in order to search for a job opening or to complete any part of the application or hiring process, please contact Human Resources. Reasonable accommodations will be determined on a case-by-case basis.
Job Grade: 8