Senior Business Intelligence Developer (Hybrid)

The Company

At Utica National Insurance Group, 1,400 employees countrywide take our corporate promise to heart every day: To make people feel secure, appreciated, and respected. Utica National Insurance Group is an AM Best "A" rated $1.5B award-winning, nationally recognized property & casualty insurance carrier. Operating along the Eastern half of the United States, based in our Home Office in Central New York, with Regional Office locations including Boston, NYC, Chicago, Atlanta, and Dallas. 

What you will do

Sr. Business Intelligence Developer will gather business requirements, translate them into reporting solution, design, develop, code and test Business Intelligence solutions that meet business requirements and its purpose. Sr. BI developer is crucial in leveraging software tools to transform data into useful insights that guides business users in making sound business decisions.

By aggregating data from multiple sources, into different reporting levels then applying vertical and horizontal data drilling, Sr. BI developer provides valuable insights into overall (or individual business unit) business performance and allows business to make data driven decisions and improve business performance.  Either by revealing underperforming segments or more profitable areas of business, Sr. BI developer helps decision makers to take steps toward more profitable business outcome.

• Develop and Maintain Business Intelligence solutions including Physical data models, Dimensional analyses, KPI Alerts, Operational Reports, Dashboards, Scorecards and Ad hoc reports.
• Design, code, test, and aggregate results from SQL queries, analyze data to ensure correct output, troubleshoot issues and perform Unit Testing.
• Gather Business Requirements accurately and create comprehensive Business/Technical documentation.
• Translate business requirements and technical designs into well-developed reporting solutions that meet the business goals defined by the business and management.
• Conduct BI solution performance tuning, troubleshooting, support and capacity estimation.
• Write queries and output efficiently, and have in depth knowledge of the data available in the area of expertise. Pull the data needed with standard query syntax; periodically identify more advanced methods of query optimization.
• Identify, quantify and propose solutions to address data integrity and data quality issues including performing source data analysis and data profiling to assess data quality.
• Commit to deliverables what the business leads.

• Meet Project deadlines.

• Performs other duties as assigned

• Conforms with all corporate policies and procedure

What you need:

• 4-7 years experience building reporting solutions
• Extensive Experience working with Microsoft Power BI/other advanced BI tools with a focus on usability, flexibility and standardization.
• Broad and deep skills in PL/SQL development and Data Warehouse related functionality: materialized views, partitioning etc.Strong knowledge of data visualization
• techniques and dashboard design.
• Knowledge of ETL processes and data warehousing principles.
• Proven track record of implementing Business Intelligence Solutions.

Salary Range: $80,000-$143,600

The final salary to be paid and position within the internal salary range will take into consideration the individual’s work experience, geographic location, education, certification(s) or additional qualifications, and scope and responsibilities within the role.

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