Job Title: SQL Developer with SSIS
Experience Level: Mid-Level
Job Summary:
We are seeking a skilled SQL Developer with expertise in SSIS (SQL Server Integration Services) to join our data engineering team. The ideal candidate will be responsible for developing maintaining and optimizing SQL queries stored procedures and SSIS packages to support data integration transformation and reporting needs.
Key Responsibilities:
- Design develop and maintain complex SQL queries stored procedures functions and views.
- Develop deploy and manage SSIS packages for ETL (Extract Transform Load) processes.
- Analyze existing SSIS packages and SQL code for performance improvements and optimization.
- Collaborate with business analysts data architects and stakeholders to understand data requirements.
- Monitor and troubleshoot SSIS jobs and SQL Server Agent jobs.
- Ensure data integrity and consistency across multiple systems and platforms.
- Document technical specifications data flow diagrams and process flows.
- Participate in code reviews and adhere to best practices in database development.
Required Skills and Qualifications:
- Bachelors degree in Computer Science Information Systems or related field.
- 3 years of experience in SQL development and SSIS package design.
- Strong proficiency in T-SQL and SQL Server (2016 or later).
- Hands-on experience with SSIS including data flow tasks control flow and error handling.
- Experience with performance tuning and query optimization.
- Familiarity with version control systems (e.g. Git).
- Strong analytical and problem-solving skills.
- Excellent communication and documentation skills.
Preferred Qualifications:
- Experience with other ETL tools or data integration platforms.
- Knowledge of data warehousing concepts and dimensional modeling.
- Familiarity with Power BI or other reporting tools.
- Experience with Azure Data Factory or cloud-based data services.
Qualifications :
Bachelors degree in Computer Science Information Systems or related field.
Additional Information :
Bachelors or Masters degree in Business Computer Science Engineering or a related field.
Remote Work :
No
Employment Type :
Full-time