Senior Software Product Data Engineer

We are seeking a highly skilled Senior Data Engineer & SQL Developer to join our team in Pune. This role blends advanced database development expertise with modern data engineering skills, supporting enterprise-scale applications and driving data-driven solutions.

Requirements

• Design, define, and create robust database schemas for large-scale enterprise applications.
• Develop and optimize stored procedures, functions, complex queries, and indexing strategies for SQL Server and Azure SQL.
• Analyze and extend existing database applications, focusing on normalization, performance optimization, and improvement.
• Implement data security measures and maintain database objects.
• Build and maintain highly optimized, reliable, and secure data pipelines for real-time and batch processing using technologies such as Apache Spark, Azure Databricks, and Azure Data Factory.
• Operationalize machine learning models in partnership with data scientists and business stakeholders.
• Champion data governance, metadata management, and operational excellence across data platforms.
• Ensure data quality and integrity through validation frameworks and monitoring mechanisms.
• Continuously identify opportunities to improve performance of production systems (OS, IO, SQL config, indexing, and SQL optimization).
• Partner with QA and application architects to identify and rectify performance bottlenecks pre-release.
• Establish proactive database-level monitoring of all production systems.
• Mentor junior engineers and contribute to knowledge sharing across the team.
• Assist in analysis and reporting of aggregate application data to provide insights into operational and business trends.
• Support technology transformation initiatives, including migration to modern platforms and Azure.
• Leverage ETL tools (SSIS, ADF) and BI tools (Power BI, SSRS, SSIS) for data integration and reporting.

Benefits

• Health insurance
• Retirement plan
• Paid time off
• 401(k) matching