Sr. Data Engineer

Role: We're looking for a seasoned Data Engineer to join our Engineering organization and take ownership of the systems that power our data-driven decisions. You'll 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, we'd love to meet you. Key Responsibilities: - 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/versioning tools - Define and promote best practices for data access, security, compliance, and observability Requirements: - Bachelor's or Master's degree in Engineering, Computer Applications, or a related field What You'll Bring: - 8+ years of experience in database engineering or backend systems development - Deep expertise with MySQL, Amazon Redshift, and Snowflake, including schema design and performance optimization - Experience in designing, building, and maintaining scalable data pipelines and ETL processes tailored to client needs - Proven track record in maintaining data freshness SLAs and ensuring 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 - Strong background in relational data modeling and schema versioning in support of software development - Experience serving 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 and analytical skills - Experience transforming product requirements into workable solutions in collaboration with development and testing teams - Writing robust functions, procedures, and scripts using SQL - Involvement in day-to-day business operations, addressing 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 - Proactively foresee and address potential data issues before they impact operations. Skills: snowflake , Git, Mssql, Redshift, Sql Experience: 8.00-13.00 Years