Senior Data Integration Engineer (SQL/SSIS)
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
