Data Engineering Property and Casualty Insurance Data Reporting
My name is Bill Stevens and I have a new six to twelve month plus Data Engineer opportunity available in Philadelphia, Pennsylvania that could be of interest to you, please review my specification below and I am available at any time to speak with you so please feel free to call me.
Please let me know if Philadelphia, Pennsylvania could be an option for you.
This position pays $80.00 per hour on a w-2 hourly basis.
The ideal Data Engineer for the firm's Global Data & Analytics group works under the direction of the Global Analytics Leads on the execution of several Analytics initiatives. Success requires a combination of strong data and analytical problem-solving skills, and in-depth knowledge of Property and Casualty insurance data and processes.
Responsibilities:
Identify, capture, profile & analyze data from multiple sources (internal and external) Identify data issues and develop remediation solutions document data capture requirements, source to target mappings, data flow diagrams, entity relationships and complex data models.
Translate business needs into systems requirements including, reports, dashboards and scorecards with minimal or no supervision.
Experience warranted:
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 including Big Data Platforms, Netezza, Oracle, SQL Server, DB2, XML, and Flat Files.
Knowledge of programming languages such as Python, Visual Basic, etc. along with Base SAS, SQL, RDBMS, Dimensional Modelling (snowflakes, star schema) and hands on experience of ETL tools like Informatica and SSIS is preferred.
Must have handson experience with data visualization and reporting tools such as QlikView/Sense, Power BI, Excel and Cognos.
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.
Global experience including leading off-shore and off-site teams.
Qualifications:
BS degree and equivalent work experience required. Certification(s) in Data, BI, P&C Underwriting, Claims Management or Actuarial Science is highly desirable, but not necessary In-depth knowledge of P&C insurance data and processes including understanding of risk data attributes and concepts such as Limits, Exposure, Coverages, Pricing, etc.
Five to ten years of experience of working as a hands-on Data analyst preferably within analytics or actuarial
Additional Skills and Competencies:
Soft skills: High degree of collaboration skills; clear and concise communication; ability to reduce ambiguity in requirements and communication; problem-solving skills; can-do attitude; ready to learn new technologies and tools Database Knowledge: Understanding of different Databases (Netezza & Oracle) preferred; advance SQL skills / Data profiling using complex SQLs; Data Modeling, Warehouse, and Unstructured Data Skills; Advance PL SQL and T SQL skills; experience working with multiple databases; data warehousing approaches and principles; advance understanding of RDBMS; knowledge of how to fine tune SQL for performance Data Analyst Knowledge:
Understanding data flow and business logic; understand business requirement and converting them to technical requirement and then writing pseudo codes and flow charts; experience with data profiling; experience working with Data quality enforcement and governance.
US citizens and those authorized to work in the US are encouraged to apply, sponsorship for this role is not available at this time.
The interview process will include an initial telephone screening.
******This is an onsite position and there is no working remotely.******
Please let me know your interest for this position, availability to interview and start for this position along with a copy of your recent resume or please feel free to call me at any time with any questions.
Regards
Bill Stevens
Director of Technical Recruiting
PRI Technology
Denville, New Jersey 07834
Direct Line: 1-973-732-5454 x21
Cell: 1-973-255-6468
Bill.Stevens@PRITechnology.com
http://bit.ly/2Bae7fF
LinkedIn:
http://bit.ly/2Tziwja
by via developer jobs - Stack Overflow