— 5+ years of data analysis experience for a data warehouse
— P&C Insurance subject matter experience (Policy and Claims)-desired to have
— 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 DD
— 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 the 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
— To work with a company that is financially stable and reliable, the company has ambitious plans for development. Our main customers are American insurance companies, which 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.
The Senior Data Analyst is a hands-on position focused on defining the data needs for the enterprise data warehouse.
The position will work within IT to help our client to create an industry-leading data warehouse that measures the performance of all aspects of the company’s operations.