Description

You will design, build, and maintain ETL pipelines using SSIS and SQL Server to support data warehousing initiatives.

This role is remote.

Responsibilities

• Develop and optimize SSIS packages for complex data integration workflows.
• Write and tune T-SQL, including stored procedures, triggers, views, and functions.
• Implement data warehousing concepts such as star schema and dimensional modeling.
• Manage SQL Server Agent job scheduling and automation.
• Debug and troubleshoot data integration issues using SSMS and source control tools.

Required Skills

• 5+ years of experience in SSIS development and SQL Server environments.
• Strong proficiency in T-SQL and query optimization.
• Experience with SQL Server Integration Services (SSIS) and SQL Server Management Studio (SSMS).
• Knowledge of ETL/ELT methodologies and data integration best practices.
• Familiarity with source control tools such as Git, Azure DevOps, or TFS.
• Understanding of data warehousing concepts, specifically star schema and dimensional modeling.
• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.

Preferred Skills

• Relevant Microsoft certifications.
• Experience with SQL Server performance tuning.

Key Skills

Education

Bachelor's degree