Senior Data Integration Engineer/ DWH, MS SQL, T-SQL

EPAM Systems, Inc.; Turkey; On-site; TRY 3,931,000 - 5,405,000; Full time

Benefits offered by this job

Extra leave days

Referral bonuses

Private health insurance

Job summary

EPAM Systems, Inc. seeks a Senior Data Integration Engineer to design and support an enterprise data warehouse and data marts for a global insurance business. You will build ETL/ELT pipelines, create data extracts, and deliver analytical reports used by business users daily.

The role emphasizes data quality, performance tuning, and collaboration with analysts to translate requirements into robust data models. Strong SQL Server, SSIS, and Dimensional modelling experience are required.

Qualifications

• 5+ years of hands-on data warehouse/ETL development experience.
• Proficiency in MS SQL Server including database engine, objects, and administration basics relevant for a developer.
• Advanced T-SQL: complex queries, window functions, CTEs, stored procedures, dynamic SQL, error handling.
• SSIS: design, development, deployment, and troubleshooting of packages with configuration, logging, scheduling.
• Performance optimization: reading execution plans, index strategy, statistics, query refactoring, large data loads.
• Knowledge of data warehouse concepts: dimensional modelling (Kimball), star/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.
• Ability to read/write technical specifications and source-to-target mappings.
• Familiarity with Git or similar version control system.

Responsibilities

• Develop, extend, and support enterprise data warehouse and data marts.
• Build, schedule, and maintain ETL/ELT pipelines loading data from operational sources.
• Create data extracts for internal/external consumers per specs.
• Produce analytical reports and datasets for business users and downstream systems.
• Analyze and tune query and pipeline performance; optimize loads.
• Gather requirements from users and analysts and translate into data models.
• Investigate and resolve data quality issues; perform data reconciliation.
• Provide production support and maintain documentation; participate in code reviews and version control.
• Mentor colleagues and contribute to architectural decisions.

Skills

Data warehouse

ETL/ELT

T-SQL

Query optimization

Dimensional modelling (Kimball)

SSIS

Python / PySpark

Git

Azure Databricks

Power BI

Tools

SSIS

Git

Azure Databricks

Python / PySpark

SQL Server

Job description

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.ResponsibilitiesDesign, develop, and support the enterprise data warehouse and subject-oriented data martsBuild, schedule, and maintain ETL/ELT pipelines that load data from operational source systemsDevelop data extracts for internal consumers and external systems according to business and technical specificationsCreate and enhance analytical reports and the datasets behind themAnalyze and tune query and pipeline performance: indexing, execution plans, partitioning, load optimizationGather and clarify requirements with business users and analysts; translate them into data models and technical solutionsInvestigate and resolve data quality issues, perform data reconciliation between sources and the warehouseProvide production support: monitor loads, troubleshoot incidents, perform root cause analysisMaintain up-to-date technical documentation: data mappings, data flow descriptions, extract specificationsParticipate in code reviews and follow version control and release proceduresMentor colleagues and contribute to architectural decisionsRequirements5+ years of hands-on data warehouse/ETL development experienceProficiency in MS SQL Server, including database engine, database objects, and administration basics relevant for a developerExpertise in T-SQL at advanced level: complex queries, window functions, CTEs, stored procedures, functions, dynamic SQL, and error handlingSkills in SSIS: design, development, deployment, and troubleshooting of packages, including configuration, logging, and schedulingCompetency in performance optimization: reading execution plans, index strategy, statistics, query refactoring, optimization of large data loadsKnowledge of data warehouse concepts: dimensional modelling (Kimball), star and snowflake schemas, facts and dimensions, staging/ODS/DWH/data mart layers, incremental loadsUnderstanding of Slowly Changing Dimensions and practical implementation of all SCD typesCapability to read and write technical specifications and source-to-target mappingsFamiliarity with Git or a similar version control systemAnalytical mindset, attention to detail, ability to work independently with requirements, and clear communication with both technical colleagues and business stakeholdersWillingness to learn new technologies, including cloud data platformsEnglish at Upper-Intermediate (B2) level or higher, both written and spoken, for communication with an international team and business usersNice to haveBackground in Informatica PowerCenterFamiliarity with Microsoft Fabric, Azure Data Factory, Azure Databricks (Spark, Delta Lake)Knowledge of SSAS OLAP (Multidimensional) cubes, SSAS Tabular models, MDX/DAXSkills in Power BI or other BI/reporting toolsExperience in the insurance domain (policy, claims, billing, premium and loss data), including Guidewire products (PolicyCenter, ClaimCenter, BillingCenter) and their data modelsProficiency in Python or PySpark for data processing, and CI/CD for database and ETL projectsWe offerCONTINUOUS UPSKILLING, LEARNING & DEVELOPMENTDiversity of tasks and projectsAssessment center for objective review of competency levelPersonal development planMentoring programs and leadership developmentCertification and professional development supportAccess to learning platforms including more than 2,500 internal coursesEnglish courses taught by certified teachersCORPORATE BENEFITSExtra leave daysReferral bonusesCOMPENSATION PACKAGECompetitive compensation paid in USDRegular salary and performance reviewsMEDICAL & HEALTHCAREPrivate health insuranceWell-being eventsWORKING ENVIRONMENTRecreation areas and kitchensTea, coffee and snacksSports equipment and game consolesIT EquipmentMicrosoft’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.