ESSENTIAL FUNCTIONS:

• Utilize business systems and database tools to define, extract, create queries as well as analyze and compile statistical data to prepare various reports, charts or written summaries for management to support recommendations or validate results.
• Create, analyze, and maintain spreadsheets, relational databases, dashboards and reports used to measure, monitor and manage results of projects and assignments.
• Analyze and summarize data trends/performance using data from internal sources for various audiences including Citizens' management teams and outside parties - frequency may be on a monthly/quarterly/annual basis.
• Serve as liaison between IT and business units for policy data coordination. Utilize knowledge of business systems and database tools to analyze results of projects and assignments.
• Participate in the maintenance and upkeep of standard reporting documentation and documented dependencies.
• Collaborate with business unit and various levels of staff including Executive Leadership. as directed, to evaluate work processes and identify enhancements to system functions or processing to facilitate improved turn-around times and performance risk and controls.

REQUIRED KNOWLEDGE, SKILLS AND ABILITIES:

• Strong working knowledge of COGNOS business intelligence products such as Analysis Studio, Report Studio, Query Studio, Dashboards and Cognos BI Version 8 or equivalent Business Intelligence tools.
• Proficient level of knowledge of Microsoft Office Suite, specifically Excel and Access.
• Ability to perform advanced analysis on business data and deliver reports to management with a high level of quality and attention to detail.
• Professional experience and demonstrated ability to manipulate and analyze data using database tools such as Microsoft Access, ACL, SQL Server Management Studio or Advanced Query Tool, data warehouse, audit automation or data mining tools.
• Demonstrated ability to solve problems through analytical approaches.
• Strong quantitative, data analysis, analytical, and report writing skills.
• Excellent verbal and written communication skills and ability to effectively interact with both internal and external contacts in person, by e-mail, or over the phone.
• Excellent interpersonal and relationship building skills, including ability to work in a team environment.
• Ability to manage multiple assignments and projects simultaneously with high level of attention to detail and accuracy.

REQUIRED EDUCATION AND EXPERIENCE:

• High School Diploma or Equivalent
• Bachelor's Degree OR 3 years relevant experience, OR a combination of college education and relevant experience equivalent to 3 years. (Mathematics, Statistics, Information Management, Computer Science, or related field.)

AND

• 3 or more years of experience in analytics, report writing, pivot tables, macros, working with various reporting tools such as Microsoft Excel/Access, Cognos, and/or Crystal Reports, which also includes 2 or more years of experience in data management, development projects and activities.

PREFERRED QUALIFICATIONS:

• Power BI/Power Apps
• 3 years experience in data management projects and activities.
• 4 years combined experience in developing data metrics, analytics, dashboards, complex queries
• Experience retrieving data from Microsoft SQL Server, DB2, Oracle or comparable relational databases.
• Experience in primary functional business area ( e.g., Insurance Operations, Finance, Human Resources, Vendor Management) as well as experience in a financial or insurance services organization.
• Experience with data management techniques for dealing with Personally Identifiable Information (PII).
• Experience with SQL queries and working in a cloud data environment.
• Ability to organize material, analyze a wide variety of facts and develop appropriate recommendations.
• Successful completion of formal training program related to the subject of data forensics
• Actuarial and/or investigative experience, Business Analyst experience as well as experience with Scorecard and Dashboard design and defining business metrics and providing analytics for strategic KPIs is preferred.

PHYSICAL REQUIREMENTS:

This position requires the ability to sit, hear, converse over the telephone and key frequently on a computer for long periods of time (4 or more hours per day). Position may require the ability to be mobile, operate a motor vehicle, climb roofs and inspect homes including attics and crawl spaces. This position may require occasional overnight travel during catastrophe response; and may be required to work for extended periods of time to include after standard business hours in addition to weekends and holidays during a catastrophe response, or as needed.

Citizens is Proud to Be an Equal Opportunity Employer

#LI-LE1 #LI-Onsite