Description

You will build and maintain the data warehouse by ingesting and aggregating data from internal and external sources.

This role is on-site.

Responsibilities

• Ingest and aggregate data from various internal and external sources to build the data warehouse.
• Design conceptual, logical, and physical data models, including ODS, Enterprise Data Warehouses, and Data Marts.
• Develop and maintain ETL processes using SSIS and stored procedures.
• Mentor and guide junior developers on database design and SQL programming.
• Apply business intelligence and data warehousing design principles to solve complex data problems.

Required Skills

• 5+ years of experience in Data Warehousing and Business Intelligence.
• 3+ years of BI development using Microsoft SQL Server.
• Expert-level proficiency in T-SQL.
• 5+ years of experience with SSIS and stored procedures.
• 2+ years of experience with Power BI.
• Deep understanding of relational database design and SQL programming.
• Strong knowledge of data modeling (conceptual, logical, and physical).
• Bachelor's degree, preferably in computer science, information sciences, or business/commerce.

Preferred Skills

• 1-2 years of experience with Azure Data Warehouse (Synapse).
• 1-2 years of experience with Azure Data Factory, SQL VMs, and building/maintaining ETL and Data Lakes.

Key Skills

Education

Any Graduate