Senior Data Engineer - Snowflake DB

Description : About The Role :

Were looking for a seasoned Data Engineer to join our Engineering organization and take ownership of the systems that power our data-driven decisions.

Youll architect and maintain high-performance data pipelines and databases across platforms like MSSQL, Redshift, and Snowflake - ensuring data is reliable, accessible, and optimized for scale.

If you thrive on solving complex problems, love optimizing systems for performance, and want to be the go-to expert in a collaborative, high-impact environment, wed love to meet You Will Do :

• Design and maintain scalable, efficient, and well-partitioned schemas in MSSQL, Redshift, and Snowflake.
• Architect and optimize complex queries, stored procedures, indexing strategies, and partitioning for large datasets.
• Build, monitor, and maintain data pipelines that ensure timely and accurate delivery of data to internal and external consumers.
• Own and enforce data refresh SLAs, ensuring availability, consistency, and reliability across production and reporting environments.
• Collaborate with software engineers, analysts, and DevOps teams to ensure data models and queries align with product and reporting requirements.
• Proactively identify and remediate performance bottlenecks, slow queries, and data inconsistencies.
• Implement and manage database change workflows using schema migration and versioning tools.
• Define and promote best practices for data access, security, compliance, and You Will Bring :
• 8+ years of experience in database engineering or backend systems development.
• At least 4 years of experience with MySQL, Amazon Redshift, and Snowflake, including schema design and performance optimization.
• Experience designing, building, and maintaining scalable data pipelines and ETL processes tailored to client needs.
• Proven track record maintaining data freshness SLAs and data quality across production pipelines.
• Hands-on experience with T-SQL, LinkSQL, query optimization, and indexing strategies.
• Experience with query optimization, mapping tables to blocks and partitions, sub-table structure, and keying / indexing for efficiency.
• Experience in relational data modeling and schema versioning in support of software development.
• Experience as the sole or lead database expert on a development team.
• Familiarity with source control systems (e.g., Git / Bitbucket) and CI / CD integration.
• Strong problem-solving skills.
• Ability to translate product requirements into workable solutions, collaborating with development and testing teams.
• Writing robust functions, procedures, and scripts using SQL.
• Experience handling day-to-day support and performance issues.
• Diagnose and troubleshoot data-related issues, providing quick and effective resolutions.
• Analyze data workflows and identify areas for improvement, recommending and implementing solutions to optimize performance.
• Utilize a proactive approach to foresee potential problems and address them before they impact operations.

(ref : hirist.tech)