Job
Description
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: Bachelor s 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. Bachelor s degree in Computer Science, Information Systems, or related field.
