data engineer for insurance data

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.