Senior Data Integration Engineer - DWH/ETL & MS 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

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.