Data Engineer
Summary
Role involves writing and tuning advanced SQL code, managing relational databases like MySQL or AWS Redshift, and supporting healthcare risk modelling platforms. Requires deep analytical skills and experience with query performance optimization.
Data Engineer/Software Development Engineer
Experience: 8+ years
Location: Kolkata (work from office)
Immediate joiners only(0-30 Days)
Required Skills:
- DBMS: Deep familiarity with standard relational databases like MySQL or enterprise analytical data warehouses like AWS Redshift.
- Writing and Tuning Code: Mastery of advanced DDL/DML, analytical window functions, Common Table Expressions (CTEs), and complex set-based logic.
- Knowledge/experience of DataBricks architecture will be a huge bonus. Experience in the AWS ecosystem will also be a bonus.
- Programming & Automation: Standard scripting capabilities. Deep knowledge in Python will be a huge plus; knowledge in Shell scripting will also be a plus.
- Query Performance Tuning: Expertise reading execution plans, rewriting problematic queries, eliminating cursor-based loops, and mitigating concurrency issues like deadlocks.
- Apply strong analytical and problem-solving skills to debug data anomalies and support healthcare risk modelling platforms.
- Act as a technical anchor for the team, establishing engineering best practices and mentoring mid-level engineers.
- Collaborate closely with US stakeholders to ensure high availability and seamless execution of the Risk & Analytics module.