Sompo International
Data Warehouse Production Support Analyst
This job is now closed
Job Description
- Req#: R1282
Work with business stakeholders to gather information required for root cause analysis of reported issues
Coordinates with all necessary IT teams to analyze and resolve data issues for the enterprise data warehouse
When necessary, 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 application
4 + 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 plus
Strong interpersonal skills and ability to work as part of a team
BS in Computer Science, Information Management or Statistics or equivalent
As a leading provider of insurance and reinsurance with worldwide operations and employees in Bermuda, U.S., U.K., Continental Europe and Asia, we recognize that our success is derived directly from those who matter the most: our people. At Sompo International, our values of integrity, collaboration, agility, execution and excellence underpin our culture and our commitment to providing an employee experience that attracts and engages the best talent in the industry. As we continue to grow, we strive to find diverse, innovative and driven professionals to join our teams and offer a broad range of career and development opportunities at all levels, in multiple business areas, in each of our locations throughout the world. Our compensation and benefits programs are market driven and competitive, with excellent family friendly policies and flexible working provisions.
Job Description
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
TECHNICAL QUALIFICATIONS
GENERAL QUALIFICATIONS
EDUCATION REQUIREMENTS
Salary Range : $75000 - $100,000 Actual compensation for this role will depend on several factors including the cost of living associated with your work location, your qualifications, skills, competencies, and relevant experience.
At Sompo International, we recognize that the talent, skills, and commitment of our employees drive our success. This is why we offer competitive, high-quality compensation and benefit programs to eligible employees.
Our compensation program is built on a foundation that promotes a pay-for-performance culture, resulting in higher incentive awards, on average, when the Company does well and lower incentive awards when the Company underperforms. The total compensation opportunity for all regular, full-time employees is a combination of base salary and incentives that gets adjusted upfront based on overall Company performance with final awards based on individual performance.
We continuously evaluate and update our benefit programs to ensure that our plans remain competitive and meet the needs of our employees and their dependents. Below is a summary of our current comprehensive U.S. benefit programs:
Two medical plans to choose from, including a Traditional PPO & a Consumer Driven Health Plan with a Health Savings account providing a competitive employer contribution.
Pharmacy benefits with mail order options.
Dental benefits including orthodontia benefits for adults and children.
Vision benefits.
Health Care & Dependent Care Flexible Spending Accounts.
Company-paid Life & AD&D benefits, including the option to purchase Supplemental life coverage for employee, spouse & children.
Company-paid Disability benefits with very competitive salary continuation payments.
401(k) Retirement Savings Plan with competitive employer contributions.
Competitive paid-time-off programs, including company-paid holidays.
Competitive Parental Leave Benefits & Adoption Assistance program
Employee Assistance Program
Tax-Free Commuter Benefit
Tuition Reimbursement & Professional Qualification benefits
Sompo International is an equal opportunity employer committed to a diverse workforce. M/F/D/V
Visit our website at www.sompo-intl.com
About the company
Sompo International is a leading global specialty provider of property and casualty insurance and reinsurance.
Notice
Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.
Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at accessibility@talentify.io or 407-000-0000.
Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.
An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report. NYC applicants may request an alternative process or accommodation at aedt@talentify.io or 407-000-0000.