Sr Data Analyst

 Responsiblties:

• Works with business stakeholders and IT application 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.

 Qualification:

• 5 years P&C Insurance subject matter experience.
• 10 years of data analysis experience extracting OLTP data specifically for a data warehouse.
• 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 with experience in generating DDL.

Key Skills:

• Statistics and mathematics.
• Data management and infrastructure.
• Critical thinking.
• Verbal and written communication.
• Problem solving.
• Programming and coding.