Senior Data Integration Engineer (SQL/SSIS)
Primary stack
Nice to have's
Job description
About the Position
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
© EPAM. This job description was sourced from the employer's public career page. TheJob is not the employer — we index the posting and route candidates to the source. All content rights and hiring decisions belong to the employer.
EPAM helps organizations innovate their business processes and rethink the way they manage their businesses so they can remain competitive in this new digital age.