Data Analyst
Locations: 3 days a week required on-site from any Sompo location
Preferred Location: Morristown, NJ
OTHER LOCATION(S): Boston, MA; Charlotte, NC; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Fargo, ND; Morristown, NJ; Garden City, NY; Houston, TX; Jacksonville, IL; Lenexa, KS; Los Angeles, CA; Lubbock, TX; Mt Juliet, TN; New York, NY; Purchase, NY; Topeka, KS
- Needs multiple, has approval for 1 but can hire 5 more.
- Sr Data Analyst - Writes the requirements for offshore team.
- P&C expert, work with source app teams to extract data, modify the warehouse as needed.
- Extract data from a source application in this system.
- Need experience with Policy / Claim admin systems (P&C insurance)
- Documentation
- BA's for Data - does not want a BA. Wants a Data Analyst.
- They define what needs to be done. Work output depends on the quality of a data analyst - they create BRD FRD and TRD - they document the work = Source to target mapping documents.
- Not informatica developers;
- Document data moving from system a (multiple sources) to b, and b is always a data warehouse.
- Data Warehouses is critical.
- NOT a BA role, working with Business to create DATA-BRD or DATA-TRD / use cases, instead This is handed to a data analyst who figures out how to get all the data needed to complete the task; ie how to extract from GW and put in DW; so that the reporting people has the proper data to create reports.
TECHNICAL QUALIFICATIONS
Proven 5+ years' experience of data analysis extraction of OLTP data within an enterprise data warehouse.
Possess 5+ years of Policy & Claims Insurance subject-matter expertise.
Candidate has advanced level SQL knowledge.
Possess optimal knowledge for concepts and frameworks for Data Warehousing, ETL, and BI Architectures.
Candidate is capable of creating and tuning Semantic layer Reporting Views.
Able to facilitate data discovery sessions, which will include an audience of business subject-matter experts.
Proven knowledge of RDBMS platforms (e.g., SQL Server, DB2), with experience in generating DDL.
Possess knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI & SAP FS-CD applications with their data is considered a plus.