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

EPAM Systems, Inc.; Turkey; On-site; TRY 600,000 - 1,100,000; Full time

Job summary

EPAM Systems, Inc. in Turkey is seeking a Senior Data Integration Engineer to design, build and support an enterprise data warehouse and related data marts. You will develop ETL/ELT pipelines and deliver data extracts and analytical reports used by business users and downstream systems.

You will optimize performance, manage data governance, document mappings, and mentor teammates while engaging with stakeholders across the organization to translate requirements into scalable data solutions.

Qualifications

• 5+ years of hands-on data warehouse/ETL development experience.
• Proficiency in MS SQL Server, including database engine and administration basics.
• Advanced T-SQL with complex queries, window functions, procedures and dynamic SQL.
• SSIS design, development, deployment, and troubleshooting.

Responsibilities

• Design, develop, and support the enterprise data warehouse and data marts.
• Build, schedule, and maintain ETL/ELT pipelines loading data from sources.
• Create data extracts for internal and external consumers.
• Develop analytical reports and datasets for users and downstream systems.
• Analyze and tune query and pipeline performance; optimize loads.
• Gather requirements with business users and translate to data models.
• Investigate and resolve data quality issues; perform reconciliation.
• Provide production support and monitor loads; maintain documentation.
• Mentor colleagues and contribute to architectural decisions.

Skills

MS SQL Server

T-SQL

SSIS

Data warehousing

Dimensional modelling

Git

Python/PySpark

CI/CD

Azure Databricks

Azure Data Factory

Tools

Power BI

SSAS

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.