Associate - SQL

Department: IT

Employment Type: Permanent - Full Time

Location: Pune

Description

Key Responsibilities

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

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

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

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