Associate - SQL

MDD Forensic Accountants LLP; Pune District; On-site; INR 800,000 - 1,000,000; Full time

Job summary

MDD Forensic Accountants LLP in Pune seeks an Associate - SQL to maintain SQL Server databases, develop reports, and manage data warehouse activities. You will collaborate with internal teams to improve reporting, automate manual processes, and ensure data integrity for timely insights.

The role requires hands-on expertise in T-SQL, SSRS, SSIS, and data analysis, with responsibilities spanning data migration, reporting, and integration to support operational excellence and strategic initiatives.

Qualifications

• BS/MS degree in Computer Science or a related field.
• Minimum of three years of experience as an SQL Developer or similar role.
• Minimum of three years of experience writing reports in SSRS.
• Minimum of one year of .NET programming experience.
• Excellent understanding and working knowledge of T-SQL and MS SQL Server.
• Proficient in MS Office suite (Word, Excel, PowerPoint).
• Fluent in English (written and spoken).
• Power BI, Azure Data Factory, Microsoft Fabric, and Power Apps experience preferred.
• Insurance industry experience is a plus.

Responsibilities

• Database development, maintenance & optimization of SQL Server databases.
• Develop, maintain, and optimize stored procedures and functions using T-SQL.
• Manage data warehouse activities and data migrations.
• Create, modify, and design SSRS reports and SSIS packages.
• Support data integration and automate data gathering, analysis, and reporting processes.
• Assist in change management and communication of database changes.

Skills

SQL Developer

SSRS

.NET programming

T-SQL

Power BI

Azure Data Factory

Education

BS/MS in Computer Science or related

Tools

Microsoft SQL Server

SSRS

Power BI

Power Apps

Azure Data Factory

Job description

Job Description:

Associate - SQL

Department: IT

Employment Type: Permanent - Full Time

Location: Pune

Description

Responsible for the maintenance of existing SQL Server databases, including creating and maintaining SQL reports. This role manages data warehouse activities, supports data analysis, resolves software issues, maintains web and/or desktop applications, and supports integration of data across systems. The position also partners with internal teams to improve reporting, automate manual processes, maintain data integrity, and support business decisions through accurate and timely data insights.

Key Responsibilities

Database Development, Maintenance & Optimization

• Develop high-quality database solutions that support operational and business needs.
• Develop, implement, maintain, and optimize stored procedures and functions using T-SQL.
• Maintain existing SQL Server databases and manage data warehouse-related activities.
• Analyze, audit, modify, and amend data in systems as requested by team members and business stakeholders.
• Respond to critical database incidents while ensuring the integrity of systems and data.

Reporting, Data Migration & Integration

• Create, modify, and design SQL Server Reporting Services reports, data exports and imports, and SQL Server Integration Services packages.
• Develop procedures and scripts for data migration.
• Maintain file transfers and support external data exchange processes.
• Assist with development efforts to define and automate data gathering, analysis, and reporting processes.
• Investigate exceptions related to asset movements.

Applications, Systems Support & Change Management

• Resolve software issues and maintain existing web and/or desktop applications.
• Learn, maintain, and upgrade existing company systems as needed.
• Develop new applications as requested to improve organizational productivity and processes, participating in the database development process from inception through delivery.
• Maintain standards consistent with current IT protocols and procedures and implement action plans as needed for change management.
• Communicate database changes to affected parties and support change management activities.

Data Analysis, Compliance & Business Support

• Analyze and comprehend state requirements and rules, including COBC and EDI, to maintain and update existing SQL code as needed.
• Comprehend workers’ compensation, liability claims, and medical data to correctly interpret trends that support customer service and business decisions.
• Provide process improvements by automating manual processes.
• Train employees in the proper use of databases.
• Work effectively with project management, support, and other internal departments

Skills, Knowledge and Expertise

• BS/MS degree in Computer Science, Engineering, or a related subject; or equivalent experience. Minimum of three years of experience as an SQL Developer or similar role.
• Minimum of three years of experience writing reports in SSRS.
• Minimum of one year of .NET programming experience.
• Excellent understanding and working knowledge of T-SQL programming and Microsoft SQL Server. Expert-level SQL analytical skills and ability to work with large amounts of data, review facts and figures, and analyze information to identify conclusions.
• Proficient knowledge of Microsoft Office suite, including Word, Excel, and PowerPoint.
• Ability to read, write, speak, and communicate fluently in English.
• Power BI, Azure Data Factory, Microsoft Fabric, and Power Apps experience preferred.
• Insurance industry experience is a plus.

Requirements: