Reporting Data Analyst with P&C Insurance

Reporting Data Analyst with P&C Insurance

Cerebra Consulting

Chicago, IL • On-site

$60/hr

Other

This job posting has expired and is no longer accepting applications. Check out similar jobs


Job description

Reporting Data Analyst With P&C Insurance

Locations: Alpharetta, GA; Charlotte, NC; Chicago, IL; Conshohocken, PA; Dallas, TX; Garden City, NY; Houston, TX; Morristown, NJ; Mt. Juliet, TN; New York, NY; Purchase, NY – Hybrid 03 days per week onsite from day 1

Duration: Long Term

Visa: Any

Experience: 08+ Years

Pay rate: $60/Hr on C2C inclusive all

Responsibilities:

  • Act as a data and domain analyst for P&C insurance subject areas (e.g., policy, claims, financials).
  • Collaborate with business stakeholders to gather, clarify, and validate reporting and extract requirements.
  • Translate insurance business concepts into accurate data logic, metrics, and dimensional definitions.
  • Leverage knowledge of source applications (e.g., Guidewire, Genius, SAP) to ensure correct data interpretation and lineage.
  • Ensure reports and extracts align with approved business definitions, regulatory needs, and data governance standards.
  • Create and validate SQL queries, views, or semantic-layer objects against the enterprise data warehouse.
  • Review and certify reports for accuracy, reconciliation, and consistency across systems.
  • Document data definitions, business rules, and reporting assumptions.
  • Support UAT and investigate data discrepancies between source systems and the data warehouse.
  • Educate business users on proper interpretation and usage of insurance data.

Technical Skills:

  • 8+ years as a hands-on IT reporting data analyst.
  • 4+ years of experience in reporting or data analysis within the Property & Casualty insurance industry; reinsurance experience is preferred but not required.
  • 3+ years hands-on experience with Strategy (formerly MicroStrategy), Microsoft Power BI or similar product.
  • Working knowledge of insurance source systems such as Guidewire (Policy, Billing, Claims), Genius, and SAP.
  • Strong SQL skills and experience querying enterprise data warehouses.
  • Understanding of dimensional modelling and enterprise reporting concepts.



Frequently asked questions

Q: What skills or qualities help someone succeed as a Data Analyst?

A: To succeed as a Data Analyst, key technical skills include proficiency in programming languages such as Python or R, expertise in data visualization tools like Tableau or Power BI, and knowledge of statistical analysis and machine learning concepts. Additionally, strong soft skills like effective communication, problem-solving, and collaboration are crucial for presenting insights to stakeholders and working with cross-functional teams. By combining these technical and soft skills, Data Analysts can drive business decisions, identify areas for improvement, and contribute to the growth and success of their organization.

Q: What is the career path for a Data Analyst?

A: A Data Analyst's typical career progression involves starting as an Entry-Level Data Analyst, where they collect, analyze, and interpret data to inform business decisions. As they gain experience, they can move into Mid-Level roles such as Senior Data Analyst or Business Analyst, where they take on more complex projects and lead smaller teams. Ultimately, they can advance to Senior Leadership positions like Data Scientist, Data Manager, or even Director of Analytics, where they oversee large-scale data initiatives and drive strategic business growth.\n\nKey opportunities for skill development and professional growth in this role include learning programming languages like Python or R, mastering data visualization tools like Tableau or Power BI, and staying up-to-date with emerging trends in machine learning and artificial intelligence. Additionally, Data Analysts can develop soft skills like communication, project management, and leadership to excel in their roles.\n\nLong-term career prospects for Data Analysts are diverse, with potential directions including transitioning into related fields like Business Intelligence, Data Engineering, or even becoming a Product Manager, or pursuing advanced degrees in Data Science or related fields to further specialize in areas like machine learning or data engineering.