Actuarial Data Analyst

Job Title: Actuarial Data Analyst
Contract Type: Contract
Location: Philadelphia, Pennsylvania
Salary: US$85 - US$95 per hour
Job list.duration: 6 months
REF: RM 2818_1505918589
Contact Name: Rashid Morad
Contact Email:
Job Published: 12 months ago

Job Description

Job Description:

The position is for an actuarial data analyst.

  1. Minimum five years' experience of working as a hands-on data analyst in Insurance Data space preferably BI or Actuarial area. In-depth knowledge of P&C Insurance Data. Certification(s) in Data, BI, P&C Underwriting, Claims Management or Actuarial Science is highly desirable, but not necessary.
  2. Understanding of P&C insurance processes, risk data attributes and concepts such as Limits, Exposure bases, Coverages, Packaged, Rating Factors, etc. Experienced in identifying, capturing, profiling & analyzing data from multiple sources (internal and external).
  3. Skilled in identifying remediation solutions for addressing data issues. Experience in documenting data capture requirements, source to target mappings, data flow diagrams, entity relationships and complex data models. Experienced in translating business needs into systems requirements including rating systems, reports, dashboards and scorecards with minimal supervision.
  4. Experience in creating complex data extracts, writing analytical functions and complex SQL queries. Should be able to create data-sets in SAS or other tools, pulling from multiple sources like Netezza, Oracle, SQL Server, DB2, XML, and Flat Files.
  5. Knowledge of Base SAS, SQL, RDBMS, Dimensional Modelling (snowflakes, star schema) and hands on experience of ETL tools like Informatica and SSIS is preferred. Must have hands-on experience with data visualization and reporting tools such as QlikView/Sense, Power BI, Excel and Cognos.
  6. Experience in coordinating and leading data improvement projects, including data quality assessments, data fix and standardization to support portfolio segmentation and profitability analysis. Skilled in identifying work breakdowns, detail tasks vs. milestones, developing estimates, and reporting progress. Experience of working in an internal consultant capacity to identify leading and trailing business indicators for advanced reporting and developing action oriented dashboards.

Additional Skills:

  1. In-depth understanding of Architecture of different Databases (Netezza & Oracle) preferred.
  2. Advance SQL skills
  3. Data profiling using complex SQLs
  4. Data Modeling, Warehouse, and Unstructured Data Skills
  5. Advance PL SQL and T SQL skills.
  6. Years of hands on Experience working with multiple databases.
  7. Advance knowledge of data warehousing approaches and principles.
  8. Advance understanding of RDBMS.
  9. Understanding data flow and business logic.
  10. Ensuring SQL is fine tuned for performance.
  11. Understand business requirement and converting them to technical requirement and then writing pseudo codes and flow charts.
  12. In-Depth knowledge or Data warehousing concepts.
  13. Experience with data profiling.
  14. Clear and concise communication.
  15. Ability to reduce ambiguity in requirements and communication.
  16. Collaboration Skills
  17. P&C Domain knowledge
  18. Problem-solving skills
  19. Can-do attitude
  20. Experience working with Data quality enforcement and suspensions
  21. Advance knowledge of Data warehousing and Business Intelligence.
  22. Advance development and design skills using various reporting tools; like Cognos and Qlikview
  23. Skill with publishing and automatic refresh of reports.
  24. Ready to learn new technologies and tools
  25. Knowledge of Big-Data and Python