Описание
Команда разрабатывает и поддерживает корпоративное хранилище данных (enterprise data warehouse) для глобального страхового бизнеса.
Задачи
•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.
