Senior Data Warehouse Engineer - Python / ETL / SQL

About the job : 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.

Shift - 3PM to 12 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 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 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)