Lisboa, Lisbon, Portugal, Portugal
September 29, 2024
Apply NowJob description
Job position: Data Analyst / Enterprise Data Architect (Insurance Sector)
Location: Hybrid Work from Portugal (3dpw in office in Lisbon)
PTC Group is recruiting for a digital consultancy and technology services provider that offers edge-to-core solutions to help organizations achieve the full potential of AI-driven digital transformation. Utilizing a technology-unified operating model for cloud, data, and IoT, this company delivers end-to-end value creation for clients through innovation in digital engineering, implementation services, products, and solutions.
Responsibilities and Tasks of the Job
Is a hands-on position with a focus on defining the data needs for the enterprise data warehouse. The position 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 organizations operations.
Location: Hybrid Work from Portugal (3dpw in office in Lisbon)
PTC Group is recruiting for a digital consultancy and technology services provider that offers edge-to-core solutions to help organizations achieve the full potential of AI-driven digital transformation. Utilizing a technology-unified operating model for cloud, data, and IoT, this company delivers end-to-end value creation for clients through innovation in digital engineering, implementation services, products, and solutions.
Responsibilities and Tasks of the Job
Is a hands-on position with a focus on defining the data needs for the enterprise data warehouse. The position 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 organizations operations.
- 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.
- 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.
- Fluency in English is mandatory.
- 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.
- B.S. Degree in Computer Information Science, Information Management, or Statistics.
