— 5+ years of data warehouse experience;
— Advanced SQL knowledge;
— 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.
— Works with business stakeholders and IT teams to define data needs for the enterprise data warehouse;
— Creates source to target 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;
— Knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI & SAP FS-CD applications and their data is a huge plus;
— Strong interpersonal skills and ability to work as part of a team.
— To work with a company which is financially stable and reliable, company has ambitious plans for development. Our main customers are American insurance companies, it allows us to feel safe and protected on the financial side;
— English classes (online) and speaking-club with native speakers;
— Possibility of remote work;
— Competitive salary;
— Collaborative friendly team environment.
Virtuace on behalf of our client — American insurance company is looking for a Data Analyst to join our team. Client is a global specialty provider of property and casualty insurance and reinsurance that has more than $110 billion USD in total assets along with $17 billion USD in net assets.