Description

You will design, build, and maintain batch ETL/ELT data pipelines using SQL Server and SSIS. You own the end-to-end data flow from source to warehouse, ensuring data integrity and performance.

This role is hybrid.

Responsibilities

• Develop and optimize batch ETL/ELT processes using SQL Server and SSIS to meet high-performance standards.
• Write, tune, and maintain complex SQL queries, stored procedures, and T-SQL for data processing and analysis.
• Design and implement data warehouse solutions, including Star and Snowflake schemas, for reporting and analytical applications.
• Build complete data pipelines moving and transforming data into ODS, Staging, Data Warehousing, and Data Marts.
• Implement audit, balance, and control mechanisms to ensure data accuracy and reliability.

Required Skills

• 3+ years of experience with SQL Server and SSIS for data integration.
• 3+ years of experience writing and optimizing T-SQL and stored procedures.
• 3+ years of experience designing and building data pipelines for Data Warehousing.
• 3+ years of experience with large-scale data processing and query optimization.
• 2+ years of experience implementing data audit and control mechanisms.
• Strong understanding of Star and Snowflake schema design.
• Experience with Data Analysis and Data Warehousing concepts.

Preferred Skills

• Experience building CI/CD pipelines for data pipelines using Azure DevOps.

Key Skills

Education

Bachelor's degree