Senior Data Warehouse Engineer - Power BI/Dimensional Modeling

Job Description : dimen- 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 Skill & Qualifications : - 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 visualisation. - 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. - 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