Sr. Business Intelligence Analyst

About IFG Companies

IFG Companies, founded in 1985, is one of America’s largest privately held, property and casualty A-rated insurance groups in the United States. As a private company, IFG is focused on profitable growth through superior underwriting of a range of products and service to its producers and insureds.

LOCATION

IFG Companies is hiring in Arizona, Connecticut, Florida, Georgia, Illinois, New Jersey, North Carolina, and case-by-case in Ohio, Pennsylvania, Texas and Virginia. Applicants must reside in one of these states to be hired. Remote and flexible work arrangements are provided to all employees based on manager approval.

SALARY RANGE

The expected salary range is $115,000 to $140,000 and subject to change at any time at the discretion of the Company.

POSITION SUMMARY

The Senior Business Intelligence Analyst will assist business stakeholders and operations gain data driven insights. Partner with underwriting, operations, Actuarial and marketing to develop and provide insights and analysis on trends and facilitate our business, including development and maintenance of underlying data tables. Designs and program new processes and dashboards following corporate data governance model.

POSITION RESPONSIBILITIES

• Work with business partners through the analysis of quantitative and qualitative data using data querying.
• Develop Quality Control measures for the reports and dashboards.
• Designs and develops new reports, dashboards, data tables, etc. to provide speed-to-data insight
• Enhance the efficiency, automation, and accuracy of existing reports by using standard data definitions as per business community.
• Work with Business community to define standard definitions of data elements. Build and maintain data dictionary.
• Follow best practices in data querying and manipulation to ensure data integrity.
• Effectively communicate information to technical and non-technical audiences.
• Provide support to business partners on creative analytical projects including design of custom reports
• Subject matter expert in all aspects relating to data collection and analysis for internal customers

KNOWLEDGE, SKILLS AND ABILITIES

• Strong SQL Development experience including SQL Queries, Stored procedures, SSIS, etc.
• Experience in SSMS, SSRS, SSAS, SSIS
• Experience with visualization tools (Power BI, Tableau, QlikView). Power BI is preferred.
• Strong proficiency in MS Excel
• Strong verbal and written communication skills
• Experience in ACORD model is a HUGE plus

EDUCATION/EXPERIENCE/CERTIFICATIONS

• Bachelor's Degree in related field preferred
• 5+ years of experience in data warehousing and Business Intelligence required
• Experience and knowledge of P&C insurance industry and strong knowledge of insurance products preferred.

PHYSICAL DEMANDS

Physical demands are considered to be that of an office environment, climate controlled, with minimal physical exertion. This position requires prolonged sitting, ability to utilize a computer and interactions with others meetings or via phone.

BENEFITS

IFG Companies offers a competitive benefits package including medical, dental, vision, 401(k), flexible spending, short-term and long-term disability insurance, life insurance, long-term care insurance, educational and professional development assistance, paid time off, company provided leave of absence programs and flexible work arrangements.

IFG Companies is an equal opportunity employer committed to a diverse workforce. M/F/D/V

#LI-JF1