Posted 1mo ago

Data Warehouse Solution Architect

@ Sompo International
Morristown, New Jersey, United States
$168k-$170k/yrOnsiteFull Time
Responsibilities:designing databases, developing ETL, maintaining standards
Requirements Summary:Bachelor's in Computer Engineering or foreign equivalent; 5+ years ETL, T-SQL, data warehouse development with SQL Server and SSIS; design SSIS architecture and best practices.
Technical Tools Mentioned:SSIS, SQL Server, T-SQL, ETL, SQL
Save
Mark Applied
Hide Job
Report & Hide
Job Description

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