Not Authorized
You are currently not authorized to access this section.
Please contact your Administrator to change your authorization settings.
Please contact your Administrator to change your authorization settings.
Production Support Data Analyst SR-590500
Purchase, NY
Job Description
ROLE TITLE Production Support Data Analyst
ROLE LOCATION(S) Boston, MA; Charlotte, NC; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Fargo, ND; Florham Park, NJ; Garden City, NY; Houston, TX; Jacksonville, IL; Lenexa, KS; Los Angeles, CA; Lubbock, TX; Mt Juliet, TN; New York, NY; Purchase, NY; Topeka, KS
ROLE SUMMARY
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.
ROLE RESPONSIBILITIES
Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identify, national origin, age, protected veterans or individuals with disabilities.
ROLE LOCATION(S) Boston, MA; Charlotte, NC; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Fargo, ND; Florham Park, NJ; Garden City, NY; Houston, TX; Jacksonville, IL; Lenexa, KS; Los Angeles, CA; Lubbock, TX; Mt Juliet, TN; New York, NY; Purchase, NY; Topeka, KS
ROLE SUMMARY
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.
ROLE RESPONSIBILITIES
- Work with business stakeholders and IT teams to analyze and resolve data issues for the enterprise data warehouse.
- Create source-to-target mapping documents to capture additional application data elements.
- Load the source-to-target mapping documents from source systems into the enterprise data warehouse.
- Collaborate with the ETL team to ensure the source-to-target mapping documents are in correct ETL code.
- Ensure the ETL code align with STM requirements.
- Perform data validation, to insure correct data movement into the enterprise data warehouse architecture.
- Consult with reporting teams to develop a general understanding for any identified variances between the enterprise data warehouse and source system applications.
- Proven 3+ years experience of data analysis within an enterprise data warehouse.
- Possess 2 years of Policy & Claims Insurance subject-matter expertise.
- Candidate has advanced level SQL knowledge.
- Possess optimal knowledge for concepts and frameworks for Data Warehousing, ETL, and BI Architectures.
- Candidate is capable of creating and tuning Semantic layer Reporting Views.
- Able to facilitate data discovery sessions, which will include an audience of business subject-matter experts.
- Proven knowledge of RDBMS platforms (e.g., SQL Server, DB2), with experience in generating DDL.
- Possess knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI & SAP FS-CD applications with their data is considered a plus.
- Candidate has strong interpersonal skills, including both written and verbal communication skills.
- Possess the ability to work as part of a team.
- Candidate has strong organizational skills and analysis skills.
- B.S. Degree in Computer Information Science, Information Management, or Statistics.
Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identify, national origin, age, protected veterans or individuals with disabilities.
Job Summary
Company
Start Date
As soon as possible
Employment Term and Type
Regular, Full Time
Required Education
Bachelor's Degree
Required Experience
3+ years
Email this Job to Yourself or a Friend