Logo of Huzzle

Home

Matches

Explore

Manage

Data Analyst

image

Clever Talent

13d ago

  • Job
    Full-time
    Senior Level
  • IT & Cybersecurity
  • Quick Apply

AI generated summary

  • You need 5+ years in data analysis and insurance, advanced SQL skills, knowledge of Data Warehousing and ETL, experience with RDBMS, and familiarity with Guidewire and SAP FS applications.
  • You will analyze data issues, create source-to-target mapping documents, collaborate with the ETL team, validate data movement, and consult with reporting teams on data warehouse usage.

Requirements

  • 5+ years’ experience in data analysis – extraction of OLTP data within an enterprise data warehouse.
  • 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.
  • 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.
  • Knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI & SAP FS-CD applications with their data is considered a plus.

Responsibilities

  • 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 the 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 / optimal ways to use it.

FAQs

What is the main focus of the Data Analyst position?

The main focus of the Data Analyst position is to define the data needs for the enterprise data warehouse and support the creation of an industry-leading data warehouse architecture for our Insurance Client.

How many years of experience are required for this role?

A minimum of 5 years of experience in data analysis and Policy & Claims Insurance subject-matter expertise is required for this role.

Is there any specific knowledge required regarding data warehousing concepts?

Yes, optimal knowledge of concepts and frameworks for Data Warehousing, ETL, and BI Architectures is required.

What skills are necessary regarding SQL?

Advanced level SQL knowledge is necessary for this position.

Do candidates need to have experience with specific applications?

Knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI & SAP FS-CD applications is considered a plus.

What type of collaboration is this position based on?

This position is project-based and involves B2B collaboration.

Can candidates from outside Portugal apply for this job?

No, only Portugal-based candidates will be considered for this role.

What are the daily rates for this position?

The daily rates for this position range from 200 to 220 euros gross/day.

What kind of sessions will the Data Analyst be facilitating?

The Data Analyst will facilitate data discovery sessions with an audience of business subject-matter experts.

Is there any training provided for the required tools and technologies?

The job description does not specify training; however, it's expected that candidates will have proficient knowledge and experience with the required tools and technologies.

Clever Talent

Hire smarter, grow faster and fast-track your success.

Human Resources
Industry
11-50
Employees
2021
Founded Year

Mission & Purpose

Clever Talent is a recruitment and talent management firm that specialises in connecting skilled professionals with businesses in need of their expertise. They provide personalised staffing solutions, ensuring the right talent is matched with the right opportunities across various industries. Their ultimate mission is to bridge the gap between companies and top-tier talent, fostering long-term success for both parties. The purpose of Clever Talent is to empower businesses to thrive by ensuring they have access to the best talent while also supporting professionals in finding meaningful and rewarding career opportunities.