Sr./Programmer Analyst (Remote)

Company: Selective Insurance
Location: Branchville
Posted on: March 18, 2023

Job Description:

A new job is a big decision. Don't work just anywhere. Be Selective.

Our Business

Selective is a midsized U.S. domestic property and casualty insurance company with a history of strong financial performance for over 95 years. Focused on exceptional employee and customer experience, we are frequently recognized for awards and honors, including being named to Forbes' 2021 Best Workplaces in Financial Services and Insurance list.

Our Culture

We genuinely care about each other, our customers, and the communities in which we operate. Our leaders actively champion career development and invite us to voice unique ideas and diverse perspectives. If that sounds appealing, we think you would feel inspired on our team to achieve and be rewarded for extraordinary results.

SUMMARY

The Programmer Analyst will be responsible for delivering a variety of unique and complex data and systems solutions for all units within the Actuarial department. This individual will al manage complex processes in successfully meeting these objectives as well as documented data applications in a strong control environment.

**Title and compensation will be based on experience.

RESPONSIBILITIES

• Prepare data and templates for quarterly loss and LAE reserve analyses.
• Ensure balancing of data to source system and reconcile to financials.
• Implement agreed upon changes to templates with guidance from supervisor or responsible actuary. Maintain proper controls and documentation.
• Support production and automation of designated external and internal financial and management reports. These include but are not limited to statutory schedules (P) and the "AY Report". May also include regulatory reports and bureau data calls. Support ceded reinsurance placement by providing information and data for broker submissions.
• Respond to ad hoc requests from brokers with guidance from the responsible actuary. Support commercial and personal lines pricing by providing routine scheduled pricing review data, for both state and countrywide reviews.
• Maintain programming code and associated documentation.
• Support all areas of the Actuarial department by providing ad hoc data as requested and agreed upon. This includes discussing needs, identifying potential solutions, preparing informal project plans, and testing.
• Assist supervisor in managing the process through to the final deliverables.
• Identify potential improvements and efficiencies within current processes.
• Improve data and systems landscape through increased automation, including programming of moderately complex algorithms in a sustainable environment.
• Properly document associated programming code. Support corporate IT objectives where technical business resources are required. This may include project scoping and budgeting, development, testing, and/or documentation. Identify resource constraints and discuss solutions with supervisor.
• Provide training and knowledge sharing opportunities to self and others through cross-training and open communication.
• Ability to learn and apply new tools/technology/ methodologies as appropriate for the department. Requirements and Qualifications:
  • To maintain effectiveness by improving skills and acquiring new skills over time.
  • To anticipate and respond to customer expectations and needs.
  • College degree in computer science, business administration, or a related field is preferred, or completion of computer technical school 2-5+ years related work experience.
  • 2-5+ years of property/casualty insurance experience.
  • 2-4+ years experience working extensively in Informatica Powercenter (9.5.X and above)
  • 2-4+ years in writing complex queries against SqlServer 2012/2014 and Netezza Strong analytic and problem solving abilities
    
    Salary range: Senior level grade range $73,600.00 - $129,500.00. Entry level grade range $51,600.00 - $85,000.00. The actual base salary is based on geographic location, and the range is representative of salaries for this role throughout Selective's footprint. Additional considerations include the candidate's qualifications and experience.
    
    Selective is an Equal Employment Opportunity employer. That means we respect and value every individual's unique opinions, beliefs, abilities, and perspectives. We are committed to promoting a welcoming culture that celebrates diverse talent, individual identity, different points of view and experiences - and empowers employees to contribute new ideas that support our continued and growing success. Building a highly engaged team is one of our core strategic imperatives, which we believe is enhanced by diversity, equity, and inclusion. We expect and encourage all employees and all of our business partners to embrace, practice, and monitor the attitudes, values, and goals of acceptance; address biases; and foster diversity of viewpoints and opinions.
    
    Selective maintains a drug-free workplace
    
    #LI-KVI #LI- Remote

Keywords: Selective Insurance, Paterson , Sr./Programmer Analyst (Remote), IT / Software / Systems , Branchville, New Jersey