data engineer for insurance data

HireHi; United States; Remote; USD 100,000 - 140,000; Full time

Job summary

The HireHi team is seeking an experienced Data Warehouse Engineer to design, develop, and support an enterprise data warehouse and data marts for a global insurance business. You will build, schedule, and maintain ETL/ELT pipelines, develop data extracts, and optimize performance across large datasets.

Responsibilities include gathering requirements, creating data models, and providing production support. Strong T-SQL, SSIS, and SQL Server expertise are essential; familiarity with cloud data

Qualifications

• 5+ years of hands-on data warehouse and ETL development experience.

Responsibilities

• Design, develop, and support the enterprise data warehouse and subject-oriented data marts.

Skills

Data warehousing

ETL development

Analytical mindset

Attention to detail

Communication

Self-sufficiency

Willingness to learn cloud platforms

Tools

MS SQL Server

SSIS

Git

Azure Data Factory

Azure Databricks

SSAS

Power BI

Informatica PowerCenter

Job description

Описание

The team develops and supports an enterprise data warehouse for a global insurance business.

Задачи

• Design, develop, and support the enterprise data warehouse and subject-oriented data marts;
• Build, schedule, and maintain ETL/ELT pipelines that load data from operational source systems;
• Develop data extracts for internal consumers and external systems according to business and technical specifications;
• Create and enhance analytical reports and the datasets behind them;
• Analyze and tune query and pipeline performance through indexing, execution plans, partitioning, and load optimization;
• Gather and clarify requirements with business users and analysts and translate them into data models and technical solutions;
• Investigate and resolve data quality issues and perform data reconciliation between sources and the warehouse;
• Provide production support by monitoring loads, troubleshooting incidents, and performing root cause analysis;
• Maintain technical documentation, including data mappings, data flow descriptions, and extract specifications;
• Participate in code reviews and follow version control and release procedures;
• Mentor colleagues and contribute to architectural decisions.

Требования

• 5+ Years of hands-on data warehouse and ETL development experience;
• Proficiency in MS SQL Server, including the database engine, database objects, and developer-relevant administration basics;
• Advanced T-SQL skills, including complex queries, window functions, CTEs, stored procedures, functions, dynamic SQL, and error handling;
• Experience with SSIS design, development, deployment, and troubleshooting, including configuration, logging, and scheduling;
• Competency in performance optimization, including execution plans, index strategy, statistics, query refactoring, and large data load optimization;
• Knowledge of data warehouse concepts, including dimensional modelling, Kimball, star and snowflake schemas, facts and dimensions, staging/ODS/DWH/data mart layers, and incremental loads;
• Understanding and practical implementation of all Slowly Changing Dimensions types;
• Ability to read and write technical specifications and source-to-target mappings;
• Familiarity with Git or a similar version control system;
• Analytical mindset, attention to detail, ability to work independently with requirements, and clear communication with technical colleagues and business stakeholders;
• Willingness to learn new technologies, including cloud data platforms;
• English at Upper-Intermediate (B2) level or higher, both written and spoken;
• Nice to have: Background in Informatica PowerCenter, familiarity with Microsoft Fabric, Azure Data Factory, and Azure Databricks (Spark, Delta Lake), knowledge of SSAS OLAP cubes and SSAS Tabular models, MDX/DAX, skills in Power BI or other BI/reporting tools, insurance domain experience including Guidewire products and their data models, proficiency in Python or PySpark, CI/CD for database and ETL projects.

Условия

Remote work is available in Georgia and 4 other locations.