Apply for this job now

Report Analyst Intermediate (Non-IT)

Jacksonville, Florida
Job Type
8 Sep 2022
Searching for a place to make your mark? Every great team depends on the individual contributions of its members the skills, talents and the passion that each team member brings. At Citizens, were building a workforce of top achievers committed to our companys mission and vision. Our company values the knowledge that comes from experienced and dedicated individuals with a variety of backgrounds, in or out of insurance.

Citizens Mission is to provide property insurance protection in Florida to those who are, in good faith, unable to obtain coverage through the private market while also providing the utmost in customer service. Our Values are public service, integrity, respect, responsiveness and sound judgment. We strive to not only provide affordable insurance products and services but also to provide sound financial responsibility to the citizens of Florida.

At Citizens, we are a team of dedicated, service-minded professionals committed to our policyholders. Come achieve and maximize your potential with us!

POSITION DESCRIPTION:The Data Analyst Intermediate isresponsible for the creation and maintenance of spreadsheets, databases, manuals, and system data calls used to support the business unit and/or enterprise. The Data Analyst Intermediate will compile data from multiple sources using Query tools to create dashboards, integrated views, and reports that can be used to drive decision making as well as identifying improvement opportunities.


  • Models ethical behavior and executes job responsibilities in accordance with Citizens core values, ethics, and information protection policies.
  • 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.
  • 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.
  • 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.
  • 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.
  • Excellent interpersonal and relationship building skills, including ability to work in a team environment.
  • Demonstrated ability to solve problems through analytical approaches.
  • Ability to manage multiple assignments and projects simultaneously with high level of attention to detail and accuracy.
  • Strong quantitative, data analysis, analytical, and report writing skills.
  • High School Diploma or Equivalent.
  • Bachelors Degree with a concentration in Mathematics, Statistics, Information Management, Computer Science, or related field OR 4 years relevant experience, OR a combination of college education and relevant experience equivalent to 4 years.
  • 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.
  • 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.

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

We offer unlimited career potential, excellent training and development opportunities, and a structured Career Development program to explore future roles of interest while growing and developing in your existing role.

Citizens offers a competitive compensation and benefits package that includes comprehensive medical/dental, Retirement Savings Plan, Vacation and Sick Time, EAP, Tuition Reimbursement, Community Service and much more!
  • Retirement savings plan with a generous company match
  • Medical, dental and vision coverage
  • Company Paid employee basic life insurance and short-term disability
  • Generous paid time off: vacation, sick and holiday leave
  • Employee Assistance and Wellness Programs
  • Tuition reimbursement
  • Professional and leadership development opportunities
  • Flexible work schedule and Alternative Work Arrangements
  • Company Paid Parking
  • Employee recognition programs
  • Relocation assistance (where applicable)
  • Community and volunteering opportunities
  • Casual dress
Citizens is Proud to Be an Equal Opportunity Employer

Visa Sponsorship is not available for this position.

LI-MT1 Job: ENT - Data Analyst

Organization: CPIC BU

Title: Report Analyst Intermediate (Non-IT)

Location: FL-Jacksonville

Requisition ID: C

Apply for this job now


  • Job Reference: 707238081-2
  • Date Posted: 8 September 2022
  • Recruiter: Citizens Property Insurance Corporation
  • Location: Jacksonville, Florida
  • Salary: On Application
  • Sector: Advert / Media / Entertainment
  • Job Type: Permanent