Enterprise Data Architect

$83,896 - $125,844/Yr

Utica Mutual Insurance Co - New Hartford, NY

Full-time - Mid Level

New Hartford, NY

1,001-5,000 employees

Insurance Carriers and Related Activities

About the position

The Data Solutions Specialist at Utica National Insurance Group plays a vital role in developing and optimizing database solutions that enhance operational efficiency and support business processes. This position requires a blend of technical expertise and collaboration with various teams to ensure data integrity and compliance.

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.

Requirements

• 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.

Benefits

• Medical and Prescription Drug Benefit
• Dental Benefit
• Vision Benefit
• Life Insurance and Disability Benefits
• 401(k) Profit Sharing and Investment Plan
• 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