Job description

Role: Production Support Data Analyst

Location: Alpharetta, GA; Boston, MA; Charlotte, NC; Chicago, IL; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Florham Park, NJ; Jacksonville, IL; Lenexa, KS; Lubbock, TX; Mt Juliet, TN; New Hyde Park, NY; New York, NY; Purchase, NY; Topeka, KS

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.

Roles and 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

Qualification:

• 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
• 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

Required Education:

• BS in Computer Science, Information Management or Statistics

Job Type: Full-time

Schedule:

• 8 hour shift

Ability to commute/relocate:

• Alpharetta, GA 30009: Reliably commute or planning to relocate before starting work (Required)

Experience:

• P&C Insurance SME: 3 years (Preferred)
• Data warehouse: 2 years (Preferred)

Work Location: One location

gatheringourvoice.org is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, gatheringourvoice.org provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, gatheringourvoice.org is the ideal place to find your next job.