Data Analyst
Data Analyst
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Boston MA; Charlotte NC; Colorado Springs CO; Conshohocken PA; Dallas TX; Fargo ND; Florham Park 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
- Work with business stakeholders and IT teams to analyze and resolve data issues for the enterprise data warehouse.
- Create source (OLTP applications) to target (DWH) mapping documents to capture additional application data elements.
- Load the sourcetotarget mapping documents from source systems into the enterprise data warehouse.
- Collaborate with the ETL team to ensure the sourcetotarget mapping documents are in correct ETL code.
- Ensure the ETL code align with STM requirements.
- Perform data validation to insure correct data movement into the enterprise data warehouse architecture.
- Consult with reporting teams to develop a general understanding for the data warehouse model / optimal ways to use it.
- Proven 5 years experience of data analysis extraction of OLTP data within an enterprise data warehouse.
- Possess 5 years of Policy & Claims Insurance subjectmatter 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 subjectmatter 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 FSRI & SAP FSCD applications with their data is considered a plus.
- Work with business stakeholders and IT teams to analyze and resolve data issues for the enterprise data warehouse.
- Create source (OLTP applications) to target (DWH) mapping documents to capture additional application data elements.
- Load the sourcetotarget mapping documents from source systems into the enterprise data warehouse.
- Collaborate with the ETL team to ensure the sourcetotarget mapping documents are in correct ETL code.
- Ensure the ETL code align with STM requirements.
- Perform data validation to insure correct data movement into the enterprise data warehouse architecture.
- Consult with reporting teams to develop a general understanding for the data warehouse model / optimal ways to use it.
- Candidate has strong interpersonal skills including both written and verbal communication skills.
- Possess the ability to work as part of a team.
- Candidate has strong organizational skills and analysis skills.
Employment Type
Full Time
