Overview

We are searching for a detail-oriented Senior Data Integration Engineer with demonstrated expertise in SQL and SSIS to join our team.

In this role, you will play a critical part in designing, optimizing, and maintaining our data integration and ETL workflows, ensuring reliability and performance across our data infrastructure. You will collaborate with cross-functional teams and apply best practices to support our growing business needs.

Responsibilities

  • Analyze, optimize, and tune SQL Server stored procedures, queries, and overall database performance
  • Collaborate with stakeholders to identify performance bottlenecks and implement efficient solutions
  • Fine-tune large, complex SQL queries to improve efficiency and reduce execution time
  • Ensure the data warehouse architecture supports scalability, reliability, and maintainability
  • Design, develop, and modify SSIS packages to meet business requirements and improve ETL processes
  • Perform debugging, testing, and troubleshooting of database issues and SSIS workflows
  • Implement best practices in database design, indexing, and query optimization
  • Monitor databases and ETL workflows to ensure consistent and reliable performance
  • Document technical processes, workflows, and design specifications
  • Develop and maintain automated solutions for data validation, cleansing, and integration processes
  • Assist in designing and maintaining data warehouse models, including star and snowflake schemas
  • Participate in code reviews to ensure high-quality database solutions and adherence to best practices

Requirements

  • 3+ years of experience in data integration roles
  • Residence in Ukraine (remote work eligible only for candidates based in Ukraine)
  • Proven experience with SQL Server (2019 or later preferred), including advanced performance tuning and optimization skills
  • Proficiency in SSIS (SQL Server Integration Services) for ETL development and maintenance
  • Strong understanding of relational database concepts and RDBMS architecture
  • Familiarity with data warehouse design concepts such as star schema and snowflake schema
  • Knowledge of indexing strategies, query execution plans, and optimization techniques
  • Strong analytical and problem-solving skills with attention to detail
  • Excellent communication and collaboration skills to work with cross-functional teams

Nice to have

  • Experience working in the insurance domain

Ukraine

With us you can:

  • Work on a flexible schedule remotely or from any of our comfortable offices or coworking spaces in Ukraine
  • Receive the necessary equipment to perform your work tasks
  • Change projects and technology stacks within EPAM
  • Gain experience in various business domains (Insurance, E-commerce, Healthcare, Finance, Travelling, Media, Artificial Intelligence, and more)
  • Relocation opportunities may be available for eligible candidates, depending on the role and openings at other EPAM locations
  • Participate in volunteer, charity programs and communities (both technical and interest-based)

We focus on your professional growth:

  • You can plan your individual career path together with your manager
  • Receive regular feedback from colleagues
  • Improve your English for free with certified teachers (Speaking Clubs, client interview preparation courses, etc.)
  • Get the opportunity to undergo free training and certification in AWS, GCP, or Azure Clouds
  • Use the internal E-learn training program (18,200+ specialized training and mentoring programs)
  • Access corporate accounts on LinkedIn Learning, Get Abstract and other partner resources
  • Study at EPAM Solution Architecture School with the instructors who are practicing architects
  • Develop as a leader, join Delivery Management, Resource Management, Leadership Essentials school and more
  • Participate in internal communities (500+ meetups, technical discussions, brainstorming sessions, online events and conferences annually)

What we offer:

  • Vacation and sick leave (including a sick leave without a medical certificate)
  • A wide range of Voluntary Medical Insurance programs providing both medical treatment and various preventive options (including sports activities)
  • Medical insurance for family members at corporate rates
  • Company support during significant life events (childbirth or adoption, marriage, etc.)
  • Support for psychological comfort: discounts on services from mental health specialists or coaches, thematic training
  • E-kids program - a free programming language training program for EPAMers' children

[epamgdo] Ukraine (benefits may differ)

Kindly be advised that the set of benefits, including learning, certification, and other opportunities, may vary depending on the role you apply for. Our recruiter will be able to share more details about the specific opportunity during your general interview.

[epamgdo] Ukraine (About EPAM)

EPAM strives to provide its global team of over 62,350 professionals in more than 55 countries with opportunities for professional growth from day one of collaboration. Our colleagues are the source of EPAM's success, so we value cooperation, strive to always understand our clients' business and aim for the highest quality standards. No matter where you are, you will join a dedicated, diverse community that will help you realize your potential to the fullest.