Senior Data Warehouse Engineer

POSITION REPORTS TO : Senior Manager Application Development

DEPARTMENT : Information Technology

POSITION LOCATION : INDIA (REMOTE)

COMPANY BUDGET : 18,00,000 - 23,00,000

Job Summary

We are seeking a highly skilled Senior Data Warehouse Engineer to manage a single version of the truth of

data, convert business entities into facts and dimensions, and integrate data from various sources. The role

involves developing ETL processes, optimizing performance, and collaborating with cross-functional teams to

support business analysis and decision-making.

Key Responsibilities

Data Warehouse Development : Responsible for managing a single version of the truth and turning data

into critical information and knowledge that can be used to make sound business decisions.

Dimensional Modeling : Convert business entities into facts and dimensions to provide a structured and

efficient data model that supports accurate and insightful business analysis.

Data Integration : Collaborate with cross-functional teams to integrate data from various source systems

such as Oracle NetSuite, Salesforce, Ragic, SQL Server, MySQL, and Excel files.

Data Transformation : Develop and maintain ETL processes using Microsoft SSIS, Python or similar ETL tools

to load data into the data warehouse.

Performance Optimization : Optimize queries, indexes, and database structures to improve efficiency.

Requirement Analysis : Work closely with key users and business stakeholders to define requirements.

Documentation : Maintain comprehensive technical documentation for data warehouse processes, data

integration, and configurations.

Team Collaboration : Mentor and guide junior team members, fostering a collaborative environment.

Required Skills & Qualifications

Must have

o Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field.

o 7+ years of experience with Microsoft SQL Server.

o Expertise in building Data Warehouse using SQL Server.

o Hands-on experience Dimensional Modeling using Facts and Dimensions.

o Expertise in SSIS and Python for ETL development.

o Strong experience in Power BI for reporting and data visualization.

o Strong understanding of relational database design, indexing, and performance tuning.

o Ability to write complex SQL scripts, stored procedures and views.

o Experience with Git and JIRA.

o Problem-solving mindset and analytical skills.

o 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