Sr Data Warehouse Engineer

Exp 7+ yrs

Location - Remote (Initially the person has to come down at our Vadodara office for 5 days - Travel and hotel stay provided) and then its remote.

CTC upto 23 LPA

Shift - 3PM to 12 (midnight)

Key Responsibilities

Data Warehouse Development

Dimensional Modeling

Data Integration

Data Transformation

Performance Optimization

Requirement Analysis

Documentation

Team Collaboration

Must have

• Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field.
• 7+ years of experience with Microsoft

  SQL Server

  .
• Expertise in building

  Data Warehouse

  using SQL Server.
• Hands-on experience

  Dimensional Modeling

  using Facts and Dimensions.
• Expertise in

  SSIS

  and

  Python

  for ETL development.
• Strong experience in

  Power BI

  for reporting and data visualization.
• Strong understanding of relational database design, indexing, and performance tuning.
• Ability to write complex SQL scripts, stored procedures and views.
• Experience with

  Git

  and

  JIRA

  .
• Problem-solving mindset and analytical skills.
• Excellent communication and documentation abilities.

Nice to Have

o Experience with cloud-based SQL databases (e.g., Azure SQL, Azure Synapse).

o Experience with cloud-based ETL solutions (Azure Data Factory, Azure Databricks).

o Familiarity with CI/CD for database deployments and automation tools.

o Knowledge of big data technologies like Snowflake