Job Overview
We are seeking an experienced SSIS SQL Engineer to design, develop, optimize, and maintain data integration solutions within an Agile software development environment. The ideal candidate will have strong expertise in SQL Server, SSIS, ETL development, and database optimization, along with the ability to collaborate with cross-functional teams, mentor engineers, and promote best practices. This role requires a hands-on engineer who can build scalable data solutions, troubleshoot complex data issues, and contribute to continuous improvements in development processes.
Roles and Responsibilities
- Design, develop, and maintain SSIS packages and ETL workflows to support data integration and analytics initiatives.
- Develop and optimize complex SQL queries, stored procedures, views, and database objects.
- Perform data extraction, transformation, and loading (ETL) from multiple source systems.
- Analyze and improve SQL performance through query tuning, indexing strategies, and optimization techniques.
- Troubleshoot data integration issues and ensure data accuracy, quality, and consistency.
- Participate in Agile ceremonies including sprint planning, stand-ups, and code reviews.
- Collaborate with developers, analysts, and business stakeholders to deliver reliable data solutions.
- Mentor team members on SQL development, SSIS best practices, and coding standards.
- Lead and contribute to technical discussions around data engineering practices and process improvements.
- Ensure adherence to development standards, documentation practices, and quality guidelines.
Required Qualifications
- Strong experience with SQL Server development and SSIS (SQL Server Integration Services).
- Hands-on experience designing and implementing ETL solutions.
- Advanced knowledge of:
- T-SQL
- Stored procedures
- Query optimization
- Database performance tuning
- Data modeling concepts
- Experience working in an Agile software development environment.
- Strong debugging, analytical, and problem-solving skills.
- Ability to collaborate effectively with technical teams and mentor junior engineers.
Preferred Qualifications
- Experience working with large-scale data platforms and analytics environments.
- Experience in healthcare analytics or other data-intensive industries.
- Familiarity with data quality, governance, and validation practices.
- Experience with modern software development practices, CI/CD processes, and source control tools.
- Strong communication skills with the ability to lead technical discussions and code reviews.