Description

You will lead developers in the design and execution of ETL processes, data pipelines, and data warehouse loads.

Responsibilities

• Lead and guide developers through the ETL development lifecycle and data pipeline construction.
• Design, develop, and optimize complex SQL queries, stored procedures, functions, and views.
• Build and maintain workflows for data ingestion, cleansing, transformation, and transfer using SSIS.
• Analyze technical problems and communicate with stakeholders to determine optimal data solutions.
• Collaborate with team members to identify and resolve technical issues.

Required Skills

• 5+ years of experience in ETL development and data warehousing.
• Expertise in Microsoft SQL Server 2019 and above, including database management.
• Advanced T-SQL skills for writing and troubleshooting stored procedures, views, and functions.
• Extensive experience with Microsoft SSIS for creating, deploying, and scripting packages.
• Strong SQL coding skills with a focus on query performance optimization.
• Practical knowledge of data models, including normalized, de-normalized, star, and snowflake schemas.
• Experience with Azure DevOps and CI/CD pipelines for deployments.
• Proficiency handling data structures such as JSON and XML.
• Degree in any graduate field.

Key Skills

Education

Any Graduate