Enterprise Data Architect

The Company

At Utica National Insurance Group, we employ over 1,400 people across the United States who are dedicated to our corporate promise: To make people feel secure, appreciated, and respected. As an AM Best "A" rated, $1.5 billion award-winning, nationally recognized property & casualty insurance carrier, we operate along the Eastern half of the United States with our Home Office in Central New York and Regional Offices in cities such as Boston, NYC, Chicago, Atlanta, and Dallas.

What You Will Do

We are seeking an experienced Data Solutions Specialist to join our dynamic IT team. This role is crucial in developing and optimizing database solutions that support our business processes and enhance operational efficiency.

Key Responsibilities

• Develop and optimize database solutions to store and retrieve vital company data.

• Install and configure information systems to ensure functionality.

• Analyze structural requirements for new software and applications.

• Migrate data from legacy systems to new solutions.

• Design conceptual and logical data models.

• Conduct tests and troubleshoot to improve system performance.

• Define security and backup procedures to ensure data protection and compliance.

• Coordinate with the Data Science team to identify future data needs.

• Perform prototypes/POC to validate new solutions and methods.

• Provide peer reviews, mentoring, and support to the software development team.

• Ensure compliance with all corporate policies and procedures.

What You Need

• Bachelor's Degree in Business Administration, Computer Science, or a related field preferred.

• 4-7 years of implementation experience with P&C Insurance software applications.

• Strong experience in SQL and relational database design.

• Familiarity with business intelligence, ETL tools, and strong experience in Oracle PL/SQL or T-SQL preferred.

Salary Range: $83,896 - $125,844

The final salary to be paid and position within the internal salary range is reflective of the employee's work experience, their geographic location, education, certification(s), scope and responsibilities in the role, and additional qualifications.

Benefits:

We believe strongly that talented people are core to our success and are attracted to companies that provide competitive pay, comprehensive benefits packages, career advancement and challenging work opportunities. We offer a Comprehensive Benefits Plan for full time employees that include the following:

• Medical and Prescription Drug Benefit

• Dental Benefit

• Vision Benefit

• Life Insurance and Disability Benefits

• 401(k) Profit Sharing and Investment Plan (Includes annual Company financial contribution and discretionary Profit Sharing contribution based upon annual company financial results)

• Health Savings Account (HSA)

• Flexible Spending Accounts

• Tuition Assistance, Training, and Professional Designations

• Company-Paid Family Leave

• Adoption/Surrogacy Assistance Benefit

• Voluntary Benefits - Group Accident Insurance, Hospital Indemnity, Critical Illness, Legal, ID Theft Protection, Pet Insurance

• Student Loan Refinancing Services

• Care.com Membership with Back-up Care, Senior Solutions

• Business Travel Accident Insurance

• Matching Gifts program

• Paid Volunteer Day

• Employee Referral Award Program

• Wellness programs

Additional Information:

This position is a full time salaried, exempt (non overtime eligible) position.

Utica National is an Equal Opportunity Employer.

Apply now and find out what it's like to be a part of an amazing team, thrive in an exciting environment and work for a company you can be proud of. Once you complete your application, you can monitor your status in the hiring process by logging into your profile. A representative from our Talent Acquisition team will be in touch regarding any change in your candidacy.

#LI-MR1