Tech Lead TECHM-JOB-25951
ROLE TITLE
Production Support Data Analyst
ROLE LOCATION(S)
Onsite - Alpharetta, GA; Conshohocken, Pa; Florham Park, NJ, Purchase NY
Skill: Data Warehouse Basics
(The selected candidate is required to work in one of the indicated SI offices at the time of onboarding. If the candidate is not already local, they must complete their relocation within a few weeks after onboarding. We will not consider remote candidates for this role.)
ROLE SUMMARY
The Production Support Data Analyst is a hands-on position focused on supporting the data accuracy and completeness of the enterprise data warehouse. The position will work within IT to help Sompo International in the maintenance of the company's data warehouse that measures performance of all aspects of the company's operations.
ROLE RESPONSIBILITIES
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 applications
TECHNICAL QUALIFICATIONS
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
GENERAL QUALIFICATIONS
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
EDUCATION REQUIREMENTS
BS in Computer Science, Information Management or Statistics