Senior Data Integration Engineer/ DWH, MS SQL, T-SQL İş İlanı

We are looking for a Senior Data Integration Engineer to join a team that develops and supports an enterprise data warehouse for a global insurance business. In this role, you will design and maintain the data warehouse and data marts, build ETL pipelines, and deliver data extracts and analytical reports that business users and downstream systems rely on every day. Responsibilities 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: indexing, execution plans, partitioning, load optimization Gather and clarify requirements with business users and analysts; translate them into data models and technical solutions Investigate and resolve data quality issues, perform data reconciliation between sources and the warehouse Provide production support: monitor loads, troubleshoot incidents, perform root cause analysis Maintain up-to-date technical documentation: data mappings, data flow descriptions, extract specifications Participate in code reviews and follow version control and release procedures Mentor colleagues and contribute to architectural decisions Requirements 5+ years of hands-on data warehouse/ETL development experience Proficiency in MS SQL Server, including database engine, database objects, and administration basics relevant for a developer Expertise in T-SQL at advanced level: complex queries, window functions, CTEs, stored procedures, functions, dynamic SQL, and error handling Skills in SSIS: design, development, deployment, and troubleshooting of packages, including configuration, logging, and scheduling Competency in performance optimization: reading execution plans, index strategy, statistics, query refactoring, optimization of large data loads Knowledge of data warehouse concepts: dimensional modelling (Kimball), star and snowflake schemas, facts and dimensions, staging/ODS/DWH/data mart layers, incremental loads Understanding of Slowly Changing Dimensions and practical implementation of all SCD types Capability 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 both 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, for communication with an international team and business users Nice to have Background in Informatica PowerCenter Familiarity with Microsoft Fabric, Azure Data Factory, Azure Databricks (Spark, Delta Lake) Knowledge of SSAS OLAP (Multidimensional) cubes, SSAS Tabular models, MDX/DAX Skills in Power BI or other BI/reporting tools Experience in the insurance domain (policy, claims, billing, premium and loss data), including Guidewire products (PolicyCenter, ClaimCenter, BillingCenter) and their data models Proficiency in Python or PySpark for data processing, and CI/CD for database and ETL projects We offer CONTINUOUS UPSKILLING, LEARNING & DEVELOPMENT Diversity of tasks and projects Assessment center for objective review of competency level Personal development plan Mentoring programs and leadership development Certification and professional development support Access to learning platforms including more than 2,500 internal courses English courses taught by certified teachers CORPORATE BENEFITS Extra leave days Referral bonuses COMPENSATION PACKAGE Competitive compensation paid in USD Regular salary and performance reviews MEDICAL & HEALTHCARE Private health insurance Well-being events WORKING ENVIRONMENT Recreation areas and kitchens Tea, coffee and snacks Sports equipment and game consoles IT Equipment Microsoft’s Software Assurance Home Use Program (HUP) Please note that our Talent Attraction Team reviews applications and CVs submitted in English. EPAM is global leader in AI transformation engineering and integrated consulting, serving Forbes Global 2000 companies and ambitious startups. With over thirty years of expertise in custom software, product and platform engineering, we empower our clients to become AI-Native enterprises, driving measurable value from innovation and digital investments.