Virtuace on behalf of our client — American insurance company is looking for a Data Analyst (Data Warehouse) 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.
— Translates business requirements into usable enterprise information which may include an enterprise data model, common business vocabulary, taxonomies to be used to guide enterprise solution development, and achieve consistency of information assets across the application portfolio;
— Develops and implements strategies for data acquisitions, archive recovery, and implementation of a database;
— Develops and maintains a formal description of the data and data structures including the data models, data flow diagrams, data dictionaries and technical metadata;
— Creates source to target mapping documents to capture application data elements for loading into data warehouse;
— Collaborates with ETL team on data model, its maintenance and optimization as well as end-to-end data-driven integration strategy;
— Monitor and guide design of a semantically rich business model of the enterprise domain, independent of any technology solution;
— Work directly with all application development teams to ensure that data is aligned between systems.
— 5+ years of data warehouse experience;
— 5+ years of hands-on data modeling and data architecture experience;
— 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 metadata ingestion and translation.
— 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;
— Health insurance;
— English classes (online) and speaking-club with native speakers;
— Possibility of remote work;
— Competitive salary;
— Collaborative friendly team environment.