Job position: Data Analyst / Enterprise Data Architect (Insurance Sector)
Location: Hybrid Work from Portugal (3 days per week 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
This is a hands-on position focused 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 that measures performance in all aspects of the organization's 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 aligns with STM requirements.
Perform data validation to ensure correct data movement into the enterprise data warehouse architecture.
Consult with reporting teams to develop a general understanding of the data warehouse model and optimal ways to use it.
Mandatory Skills
Proven 5+ years of experience in data analysis and extraction of OLTP data within an enterprise data warehouse.
Possess 5+ years of Policy & Claims Insurance subject-matter expertise.
Advanced level SQL knowledge.
Optimal knowledge of concepts and frameworks for Data Warehousing, ETL, and BI Architectures.
Capability to create and tune Semantic layer Reporting Views.
Able to facilitate data discovery sessions with business subject-matter experts.
Proven knowledge of RDBMS platforms (e.g., SQL Server, DB2), with experience in generating DDL.
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.
Complementary Skills
Strong interpersonal skills, including both written and verbal communication skills.
Ability to work as part of a team.
Strong organizational and analytical skills.
Education requirements
B.S. Degree in Computer Information Science, Information Management, or Statistics.
#J-18808-Ljbffr