Overview
On Site
Full Time
Part Time
Accepts corp to corp applications
Contract - W2
Contract - Independent
Skills
ETK
Job Details
Role: SQL Server with SSIS
Location: New York city, NY
Key Responsibilities
- Design, develop, and maintain ETL workflows using SQL Server Integration Services (SSIS)
- Build and optimize stored procedures, views, and functions for data transformation and reporting
- Collaborate with cross-functional teams to gather requirements and translate them into scalable data solutions
- Ensure data integrity, performance tuning, and error handling across ETL pipelines
- Monitor and troubleshoot SSIS packages in production environments
- Document data flows, mappings, and technical specifications for transparency and maintainability
Required Skills
- Strong proficiency in T-SQL, SSIS, and SQL Server (2016+)
- Experience with data warehousing concepts, star/snowflake schemas, and dimensional modeling
- Familiarity with version control systems (e.g., Git) and CI/CD pipelines for ETL deployments
- Knowledge of SSRS or Power BI for reporting is a plus
- Ability to optimize queries and troubleshoot performance bottlenecks
Qualifications
- Bachelor's degree in Computer Science, Information Systems, or related field
- 3+ years of hands-on experience in SQL Server and SSIS development
- Microsoft certifications (e.g., MCSA, MCSD) are advantageous
Preferred Experience
- Working with large-scale enterprise data systems
- Exposure to cloud-based data platforms (Azure Data Factory, AWS Glue)
- Understanding of data governance and compliance standards
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.