Job Description

Senior Analyst – SD (Backend)

Expires on	:	20230421
Job Code	:	5756

USA

Experience	:	8-15 Years
Location	:	USA

• Looking for Senior Analyst - SD (Backend)

Responsibilities

• DQ is looking for a heavy back end developer with good experience on SSIS, Stored Procedures using TSQL • Strong experience with TSQL Server and writing/optimizing SQL queries and stored procedures Experience on EDI 83X formats (EDI 834 is required) • Should have the knowledge and hands-on experience of SSIS and SSRS (would be a great plus) Good understanding of Software Development Life Cycle - Agile Proven track record in delivering high-quality Database backend projects within tight deadlines • Excellent Analytical skills and resourcefulness • Excellent communication skills Must be able to work independently and in a team-oriented, collaborative environment Hands-on experience in Database finetuning, and resolution of performance bottlenecks (using Profilers and similar tool suite) Working experience with data migration/integration (within the healthcare field, particularly dental health benefits administration is a plus). • Ability to work in a fast-paced environment and deliver results with quick turnaround times HIPAA, PHI, PII and Information security awareness • Working experience on US Healthcare medical insurance segment, Medicaid dental/vision benefits piece Experience with process automation • Experience in scripting with PowerShell preferredOptimizing the stored procedures, indexing and performance to enhance the database performance Investigating Database bottlenecks: dead-lock resolution, data serialization issues – delayed writes, locks, columnar updates, etc. • Work closely with business users to identify, report and correct data-centric issues. Deployment of enhancements and modifications/releases environments (Dev, QA, Prod)

Requirements

DQ is looking for a heavy back end developer with good experience on SSIS, Stored Procedures using TSQL • Strong experience with TSQL Server and writing/optimizing SQL queries and stored procedures • Experience on EDI 83X formats (EDI 834 is required) Should have the knowledge and hands-on experience of SSIS and SSRS (would be a great plus) • Good understanding of Software Development Life Cycle - Agile Proven track record in delivering high-quality Database backend projects within tight deadlines • Excellent Analytical skills and resourcefulness • Excellent communication skills Must be able to work independently and in a team-oriented, collaborative environment • Hands-on experience in Database finetuning, and resolution of performance bottlenecks (using Profilers and similar tool suite) • Working experience with data migration/integration (within the healthcare field, particularly dental health benefits administration is a plus). • Ability to work in a fast-paced environment and deliver results with quick turnaround times HIPAA, PHI, PII and Information security awareness • Working experience on US Healthcare medical insurance segment, Medicaid dental/vision benefits piece • Experience with process automation Experience in scripting with PowerShell preferred • Optimizing the stored procedures, indexing and performance to enhance the database performance Investigating Database bottlenecks: dead-lock resolution, data serialization issues – delayed writes, locks, columnar updates, etc. Work closely with business users to identify, report and correct data-centric issues. Deployment of enhancements and modifications/releases environments (Dev, QA, Prod)

Apply