Description

You will design and build end-to-end data pipelines and data warehouse solutions using SQL Server and SSIS.

This role is on-site.

Responsibilities

• Develop batch ETL/ELT processes using SQL Server and SSIS, ensuring pipelines meet performance and quality standards.
• Design and implement data warehouse architectures, including star and snowflake schemas, for reporting and analytical applications.
• Write, optimize, and maintain complex SQL queries and stored procedures for data processing and analysis.
• Implement audit, balance, and control mechanisms to ensure data integrity within data solutions.
• Build and maintain CI/CD pipelines for data workflows using Azure DevOps.

Required Skills

• 3+ years of experience developing ETL processes with SQL Server Integration Services (SSIS).
• Strong proficiency in T-SQL, including query optimization and stored procedure development.
• Experience designing and building data warehouses, ODS, staging areas, and data marts.
• Hands-on experience with large-scale data processing and performance tuning.
• Familiarity with Azure DevOps for CI/CD pipeline implementation.
• Bachelor's degree in a relevant field or equivalent experience.

Preferred Skills

• Experience with Python for data processing tasks.

Key Skills

Education

Bachelor's degree