Job Description

About The Company:ARA\'s client is a fully owned subsidiary of a rapidly growing Healthcare Analytics company revolutionizing the healthcare analytics space with integrated insights, automation, and scale powered by AI/ML Advanced analytics, Technology, and deep domain expertise in Pharma & Biotech. They are a rapidly growing data and analytics provider of the most up-to-date, comprehensive, and integrated information on hospitals, physicians, and other healthcare providers. Recently honoured by the Boston Business Journal as one of the 10 fastest-growing private companies in Massachusetts and named THE BEST large company to work for on Business Journal\xe2\x80\x99s Best Places to Work list published in June 2019, they are on an incredibly exciting trajectory. The company has more than doubled in size in the past 2 years. Their motivated and high-energy workforce is collaborative, kind, and engaged, which has led to exceptional retention rates.The Role:This role requires troubleshooting, optimization, and performance tuning for continuous data extracts. The candidates have to create and maintain both manual and automated test cases, conducting post implementation reviews. Also, it requires work on developing database scripts.Key Responsibilities:

• Perform troubleshooting, optimization, and performance tuning for recurring data extracts and ad-hoc reporting.
• Validate results of deliverables against project scope, using knowledge of the healthcare industry, market, and standard operating procedures.
• Develop database scripts to enhance data management processes.
• Monitor and resolve daily failure alerts.
• Create and maintain both manual and automated test cases that will put deliverables through rigorous end-to-end QC.
• Partner with the PS and SC teams to provide feedback and suggestions for improvement of requirements and Analysts to ensure the delivery of high-quality reports.
• Conduct project post implementation reviews to identify key enhancements and lessons learned to drive continuous improvement and optimize project outcomes.
• Assist and advise on best practices for quality assurance and make recommendations to improve efficiency and performance.
• Escalate any issues in a timely manner and provide input for resolution.

Skills Required:

• 5+ years of experience in SQL coding practices and methodologies, inclusive of working knowledge of SQL cursors, coding automation
• 3+ years of experience with technical capabilities in advanced SQL coding, Notebook tools such as Databricks, process automation solutions, or test automation or any other functional automation tools.
• Experience implementing stored procedures and triggers for automation tasks.
• Strong written and oral communication skills, along with the ability to interact professionally with a diverse range of technical and non-technical team members.
• Fastidious attention to detail and a desire to deliver high quality products and solutions.
• Experienced systems thinker; desire to develop subject matter expertise and understand the ways our teams leverage our data assets.

Qualifications & Experience:

• Bachelor\xe2\x80\x99s/Master\xe2\x80\x99s
• Exp- At least 4+ years of relevant experience

Required Skills SQL coding, Databricks, SQL QueriesEducational Qualification Bachelor\'s/Master\'sMay 15, 2024Pay Rate1500000 - 2000000 INR Per Annum3 - 9 Years Exp.2 Vacancies

ARA Resources