Description

You will build and maintain data pipelines and ETL processes.

Responsibilities

• Develop Batch ETL/ELT processes using SQL Server and SSIS, ensuring high-performance data pipelines.
• Write and optimize SQL queries and stored procedures for data processing and analysis.
• Design and build complete data pipelines to move and transform data for ODS, Staging, Data Warehousing, and Data Marts.
• Implement Data Warehouse solutions using Star Schema or Snowflake schema for reporting.
• Implement audit, balance, and control mechanisms within data solutions.

Required Skills

• 3+ years experience developing Batch ETL/ELT processes with SQL Server and SSIS.
• 3+ years experience writing and optimizing SQL queries and stored Procedures using TSQL.
• 3 years experience designing and building data pipelines for Data Warehousing.
• 3+ years experience implementing Data Warehouse solutions (Star Schema, Snowflake schema).
• 2+ years experience implementing audit, balance, and control mechanisms in data solutions.
• Strong understanding of DW concepts, including 3NF and Dimensional data models.
• Experience with Snowflake, Sql Server, Ssis, Etl, Warehousing, and Data Analysis.

Key Skills

Education

Bachelor's degree