Data Warehouse Solution Architect

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

Data Warehouse Solution Architect, Endurance Services Limited d/b/a Sompo, Morristown, NJ. Design strategies for enterprise databases, data warehouse systems, and multidimensional networks. Set standards for database operations, programming, query processes, and security. Model, design, and construct large relational databases or data warehouses. Develop new ETL processes, implement complex enhancements, and modify existing code using SSIS ETL. Independently design SSIS architecture and establish/maintain best practices and methodologies for SSIS ETL development team.

40 hrs/week, Mon-Fri, 8:30 a.m. - 5:30 p.m. Salary: $167,835/yr to $170,000/yr. Standard benefits apply, see https://www.sompo-intl.com/careers/life-at-sompo/ for more information.

MINIMUM REQUIREMENTS:

Bachelor's degree in Computer Engineering, or foreign equivalent degree, and five (5) years of progressively responsible work experience developing ETL applications, coding T-SQL, performing data warehouse development and using Microsoft SQL Server, dynamic SQL and SSIS/SQL best practices including the development of reconciliation and validation framework.

To apply, email resume and reference NJ0019 to [email protected], or apply at https://www.sompo-intl.com/careers/job-opportunities/.