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. You will collaborate with cross-functional teams to design, develop, and optimize data pipelines and database systems, ensuring high performance, reliability, and scalability. Key responsibilities include designing robust database schemas, developing and optimizing SQL components, building and maintaining data pipelines using technologies like Apache Spark and Azure Databricks, operationalizing machine learning models, and ensuring data quality and performance.

Must Have

• 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.
• Build and maintain highly optimized, reliable, and secure data pipelines for real-time and batch processing.
• 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).
• Work closely with Product Managers, Scrum Managers, Dev Teams, Test Leads, and other stakeholders.
• 5+ years of experience in database development and data engineering for large enterprise applications.
• Expert in SQL Server (2012 and above), T-SQL, PL/SQL, database tuning, and performance optimization.
• Strong experience with Azure SQL, SQL MI, and cloud-based data solutions.
• Proficiency in big data technologies (PySpark, Hadoop, Kafka, EventHub, Stream Analytics).
• Experience with ETL tools (SSIS, Azure Data Factory) and BI/reporting tools (Power BI, SSRS).
• Solid understanding of relational and dimensional data modeling, data warehousing concepts, and database normalization.
• Experience in implementing data security and monitoring solutions.
• Strong problem-solving, analysis, design, and estimation skills.
• Excellent communication and collaboration abilities.
• Experience working in Agile/Scrum environments and familiarity with DevOps practices.
• Experience with CI/CD pipelines and version control systems (e.g., Git).

Good to Have

• Bachelor’s degree in Computer Science, Engineering, or equivalent practical experience.
• 8+ years overall experience in data engineering or related fields.
• Azure Data Engineer Certification or equivalent is a strong advantage.
• Experience in the tax and accounting domain is a plus.

Perks & Benefits

• Well-being benefits
• Tools, programs, and resources to help employees feel healthy, happy, safe, and prosperous

About the Role:

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. You will collaborate with cross-functional teams to design, develop, and optimize data pipelines and database systems, ensuring high performance, reliability, and scalability.

Key Responsibilities:

Database Design & Development

• 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.

Data Engineering

• 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.

Performance & Monitoring

• 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.

Collaboration & Leadership

• Work closely with Product Managers, Scrum Managers, Dev Teams, Test Leads, and other stakeholders.
• 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.

Modernization & Transformation

• 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.

Required Skills & Experience

Technical Skills

• 5+ years of experience in database development and data engineering for large enterprise applications.
• Expert in SQL Server (2012 and above), T-SQL, PL/SQL, database tuning, and performance optimization.
• Strong experience with Azure SQL, SQL MI, and cloud-based data solutions.
• Proficiency in big data technologies (PySpark, Hadoop, Kafka, EventHub, Stream Analytics).
• Experience with ETL tools (SSIS, Azure Data Factory) and BI/reporting tools (Power BI, SSRS).
• Solid understanding of relational and dimensional data modeling, data warehousing concepts, and database normalization.
• Experience in implementing data security and monitoring solutions.

Other Skills

• Strong problem-solving, analysis, design, and estimation skills.
• Excellent communication and collaboration abilities.
• Experience working in Agile/Scrum environments and familiarity with DevOps practices.
• Experience with CI/CD pipelines and version control systems (e.g., Git).

Preferred Qualifications

• Bachelor’s degree in Computer Science, Engineering, or equivalent practical experience.
• 8+ years overall experience in data engineering or related fields.
• Azure Data Engineer Certification or equivalent is a strong advantage.
• Experience in the tax and accounting domain is a plus.