Production Support Data Analyst
Sompo International
Full Time Conshohocken, Pennsylvania, United States Posted 2 months ago
About Position
Production Support Data Analyst (Full Time)
$0.00 / Hourly
Conshohocken, Pennsylvania, United States
Production Support Data Analyst
Full Time Conshohocken, Pennsylvania, United States Posted 2 months ago
Skills
• Works with business stakeholders and IT teams to analyze and resolve data issues for the enterprise data warehouse • When necessary will creates source to target mapping documents to capture additional 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 and that ETL code operates in line with STM requirements • Performs data validation to confirm data is moved into the data warehouse correctly • Works with reporting teams to assist them in understanding any reported variances between the data warehouse and source system applicationsDescription
The Production Support Data Analyst is a hands-on position with a focus on supporting the data accuracy and completeness within the enterprise data warehouse. The position will work within IT to help Sompo International maintain the enterprise data warehouse architecture. Furthermore, the data warehouse architecture will measure performance in all aspects of the organization’s operations.
Responsibilities
- • 3+ years of data analysis experience for a data warehouse
- • 2 years P&C Insurance subject matter experience (Policy and Claims)
- • 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
Educational Requirements
- • Knowledge of Guidewire Policy Center or Guidewire Claims Center, applications and their data is required
- • Strong interpersonal skills and ability to work as part of a team
By applying to a job using PingJob.com you are agreeing to comply with and be subject to the PingJob.com Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.
