Job position: Production Support Data Analyst for Insurance Sector
Location: Remote Work from Portugal (priority to candidates that can be in Lisbon clients office 3dpw)
PTC Group is recruiting for a digital consultancy and technology services provider that offers edgetocore solutions to help organizations achieve the full potential of AIdriven digital transformation. Utilizing a technologyunified operating model for cloud data and IoT this company delivers endtoend value creation for clients through innovation in digital engineering implementation services products and solutions.
Responsibilities and Tasks of the Job
The Production Support Data Analyst is a handson position with a focus on supporting the data accuracy and completeness within the enterprise data warehouse. The position will work within IT to help Sompo International maintain the enterprise data warehouse architecture. Furthermore the data warehouse architecture will measure performance in all aspects of the organizations operations.
- Work with business stakeholders and IT teams to analyze and resolve data issues for the enterprise data warehouse.
- Create sourcetotarget 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 any identified variances between the enterprise data warehouse and source system applications.
Mandatory Skills
- Proven 3 years experience of data analysis within an enterprise data warehouse.
- Possess 2 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.
- Fluency in English is mandatory.
Complementary Skills
- 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.
Education requirements
- B.S. Degree in Computer Information Science Information Management or Statistics.
Remote Work :
No