Data Analyst
Chicago, IL, United States
Job Description Job Description Company Description
Upwork has partnered with global provider of property, casualty, and specialty insurance and reinsurance.
To continue making an impact, they are looking to partner with an experienced Data Analyst to focus on defining the data needs for the enterprise data warehouse. The selected resource for this project will work within IT to help create an industry-leading data warehouse architecture. Furthermore, this data warehouse architecture will measure performance in all aspects of the organization’s operations.
Job Description
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 source-to-target mapping documents from source systems into the enterprise data warehouse.
Collaborate with the ETL team to ensure the source-to-target 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.
Qualifications
Proven experience of data analysis – extraction of OLTP data within an enterprise data warehouse.
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.
Education in Computer Information Science, Information Management, or Statistics.
Additional Information
Onsite opportunity!
Long term engagement
Being part of a growing global company.
Opportunity to work with a diverse international team.
Potential for career development within the company.
#J-18808-Ljbffr