We are looking for an experienced Senior Data Analyst to join a team developing new project and who is ready to become a part of C.T.Co  where more than 650 specialists are working already.   

Professional skills and qualification:

 General Qualification

• Knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI & SAP FS-CD applications and their data is a huge plus;
• Strong background in Property and Casualty (P&C) insurance from a policy as well as claim perspective;
• Strong interpersonal skills and ability to work as part of a team;
• Strong SQL skills;
• Strong experience and understanding on Data Warehouse concepts;
• Fluent written and spoken English;
• Good understanding of Latvian and Russian.   

Technical Qualification

• 10 + years of data analysis experience extracting OLTP data specifically for a data warehouse;
• 5 + years P&C Insurance subject matter experience (Policy and Claims);
• Strong and advanced SQL knowledge working with extracting data from OLTP applications;
• Extensive knowledge of Data Warehousing, ETL and BI Architectures, concepts and frameworks;
• Capable of creating and tuning Semantic layer Reporting Views;
• Capable of facilitating data discovery sessions involving business subject matter experts;
• Knowledge of RDBMS platforms (e.g. SQL Server, DB2) with experience in generating DDL;
• Familiar with ETL tools- Informatica AND SSIS;

Responsibilities:

•  Works with business stakeholders and IT application teams to define data needs for the enterprise data warehouse;
• Creates source (OLTP applications) to target (DWH) mapping documents to capture application data elements for loading from source systems into the enterprise data warehouse;
• Collaborates with ETL team to ensure that source to target mappings are correctly translated into ETL code;
• Performs data validation to confirm data is moved into the data warehouse correctly;
• Works with reporting teams to assist them in understanding the data warehouse model and optimal ways to use it
• Reconciliation processes of data from source to final EDW warehouse;
• Provide Data Analysis and find the root cause of any new or prevailing issues in the current Warehouse;
• Ad hoc analysis of source system data to support architectural design decisions (identification of essential target table keys, target table source codes, and grain of data);
• Maintenance and conformance of reference data from multiple source systems to be leveraged by the data warehouse;  
• Revision of source to target SQL logic, Source to Target documents to address missing data elements to the existing data warehouse (Source to target mapping, table navigation and data transformation rules).

Benefits:

• Advantage of working in a large, stable and reliable company, which managed to keep a dynamic and friendly work environment;
• Experience in international projects for first-rate global companies;
• Attractive salary and compensation package (advanced health insurance, flexible cell phone compensation, etc.);
• Company sponsored professional trainings, certifications and conferences;
• Career growth and opportunities for development;
• Regular company and team building events;
• Opportunity to work remotely.

Remuneration: Monthly salary (gross): 4000.00 to 5000.00 EUR *

*The above-mentioned remuneration is valid within the term of this job advertisement only and may vary depending on the potential candidate’s skills, qualification and experience.

Please send your CV, references and above-mentioned documents (preferably in English) to: jobs@ctco.lv

Follow us on Facebook: http://www.facebook.com/ctcoltd?ref=hl

Follow us on LinkedIn : https://www.linkedin.com/company/ctco/