Job Description

Salary: $96,000 - 96,000 per year Requirements:

• Proven experience in leading and mentoring a team focused on ETL development, data pipelines, and managing data warehouse loads.
• Proficient in designing, developing, and refining complex SQL queries, stored procedures, functions, and views.
• Skilled in constructing and sustaining workflows for data ingestion, cleansing, transformation, and transfer using SQL Server Integration Services (SSIS) and SQL.
• Solid background with Microsoft SQL Server 2019 or later, including database management.
• Significant experience in utilizing Microsoft SSIS to create and deploy ETL packages.
• Expertise in writing and troubleshooting T-SQL statements, as well as creating stored procedures, views, and SQL functions.
• Familiar with various data models such as normalized, denormalized, star, and snowflake schemas.
• Strong SQL coding skills with a focus on performance optimization for data queries.
• Ability to handle multiple tasks effectively in a dynamic and fast-paced environment.
• Collaborative mindset to work with team members to troubleshoot and resolve technical challenges promptly.
• Analytical thinker with the ability to communicate effectively with stakeholders to assess needs and find optimal solutions.
• In-depth knowledge of data warehousing principles.
• Experience with Azure DevOps and CI/CD processes for efficient deployments.
• Strong familiarity with data structures and formats including JSON and XML, along with SSIS scripting capabilities.

• Lead and mentor team members engaged in ETL development, data pipeline construction, and data warehouse management.
• Design, develop, and optimize complex SQL queries and database objects including stored procedures and views.
• Create and maintain workflows for data ingestion, cleansing, transformation, and transfer utilizing SSIS and SQL.
• Manage and administer Microsoft SQL Server databases effectively.
• Develop and deploy SSIS packages for extracting, transforming, and loading data.
• Write and troubleshoot T-SQL statements to ensure data integrity and performance.
• Evaluate and apply different data modeling techniques to support data architecture needs.
• Optimize SQL queries for performance improvement.
• Navigate and thrive in a rapidly changing, high-pressure environment while managing multiple priorities.
• Collaborate with team members to identify technical issues and drive timely resolutions.
• Analyze and communicate effectively with stakeholders to clarify requirements and deliver optimal solutions.
• Apply deep knowledge of data warehousing concepts to enhance data management processes.
• Utilize Azure DevOps and CI/CD pipelines to facilitate seamless deployments.
• Implement awareness of data formats such as JSON and XML in scripting within SSIS.

• Azure
• CI/CD
• Data Warehouse
• DevOps
• ETL
• Support
• JSON
• SQL
• Snowflake
• SSIS
• XML
• Cloud

More:

We are a forward-thinking technology firm located in Warren, NJ, seeking a SQL Server & SSIS ETL Developer to join our dynamic team for a long-term engagement lasting over 12 months. Our work environment is collaborative, fast-paced, and driven by innovation. We offer competitive compensation and the opportunity to work on challenging projects that leverage cutting-edge technologies. We pride ourselves on being an equal opportunity employer and celebrate diversity, ensuring that all employment decisions are made based on merit and aligned with business needs.

last updated 2 week of 2026

Job Tags

Similar Jobs