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

Senior Data Integration Engineer/ DWH, MS SQL, T-SQL 🏢 EPAM Systems 📍 Remote · Armenia 🕐 Full Time About the role 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. What you’ll do 🗂 • 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 What we’re looking for 🔎 • 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 • 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 • Familiarity with Git or a similar version control system How to apply 🙋 Open on ITA Jobs and apply → More IT vacancies in Armenia, matched to your CV — jobs.ita.am/vacancies #SoftwareEngineering #Senior #Etl