Description

Design and develop scalable ETL/ELT solutions using SQL Server Integration Services to support data warehouse and analytics initiatives.

You will own the full lifecycle of data pipeline development, from schema design to performance optimization and deployment.

Responsibilities

• Design and build robust ETL/ELT pipelines using SSIS for large-scale data processing.
• Develop and optimize complex SQL queries, stored procedures, and T-SQL scripts.
• Implement and maintain Data Warehouse and Data Mart architectures using Star and Snowflake schemas.
• Integrate audit, balance, and control mechanisms to ensure data quality and integrity.
• Manage deployments and version control using Azure DevOps.

Required Skills

• 8+ years of experience with SQL Server Integration Services (SSIS).
• Strong proficiency in T-SQL and complex SQL query optimization.
• Hands-on experience with ETL/ELT pipeline development and data warehousing concepts.
• Knowledge of Star and Snowflake schema design patterns.
• Experience with Python for data processing tasks.
• Familiarity with Azure DevOps for CI/CD and version control.
• Bachelor's degree in Computer Science or related field.

Preferred Skills

• Experience with ODS and Staging area architectures.
• Background in performance tuning for large-scale data environments.

Key Skills

Education

Bachelor's degree