Senior Data Warehouse Engineer

Job Description : 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. 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 : Maintain comprehensive technical documentation for data warehouse processes, data integration, and configurations. Team Collaboration : Mentor and guide junior team members, fostering a collaborative environment. Must have : - Bachelors or Masters 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 : - Experience with cloud-based SQL databases (e.g., Azure SQL, Azure Synapse). - Experience with cloud-based ETL solutions (Azure Data Factory, Azure Databricks). - Familiarity with CI/CD for database deployments and automation tools. - Knowledge of big data technologies like Snowflake (ref:hirist.tech)

Location: in, IN

Posted Date: 5/1/2025