Data Warehouse Solution Architect

Sompo International • Morristown, NJ

14d

About The Position

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/. We are Sompo, a global provider of commercial and consumer property, casualty, and specialty insurance and reinsurance. Building on the 130 years of innovation of our parent company, Sompo Holdings, Inc., Sompo employs approximately 9,500 people around the world who use their in-depth knowledge and expertise to help simplify and resolve your complex challenges. Because when you choose Sompo, you choose The Ease of ExpertiseTM. “Sompo” refers to the brand under which Sompo International Holdings Ltd., a Bermuda-based holding company, together with its consolidated subsidiaries, operates its global property and casualty (re)insurance businesses. Sompo International Holdings Ltd. is an indirect wholly-owned subsidiary of Sompo Holdings, Inc., one of the leading property and casualty groups in the world with excellent financial strength as evidenced by ratings of A+ (Superior) from A.M. Best (XV size category) and A+ (Strong) from Standard & Poor’s. Shares of Sompo Holdings, Inc. are listed on the Tokyo Stock Exchange. To learn more please follow us on LinkedIn or visit sompo-intl.com.

Requirements

• Bachelor's degree in Computer Engineering, or foreign equivalent degree
• 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.

Responsibilities

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level