SQL Engineer

Industry: IT

Qualification: Any Degree

Required Skills: SQL Development, Amazon Redshift, Glue

Working Shift: 2 PM to 11 PM IST

City: Coimbatore, Chennai, Bangalore

Country: India

Name of the position: SQL Engineer

Location: Coimbatore/ Chennai/ Bengaluru

No. of resources needed : 01

Mode: Contract (12 Months)

Years of experience: 10+ Years

Shift : UK Shift

About the Role

We are seeking a highly skilled Database Engineer with deep expertise in Amazon Redshift, dimensional modeling, and SQL development to support our manufacturing, IoT device, and medical device data ecosystem. This role will design, optimize, and maintain the data structures that power operational analytics, connectivity insights, fleet performance dashboards, regulatory reporting, and enterprise business intelligence.

Your work directly impacts patient safety, device uptime, service response, manufacturing throughput, and supply-chain efficiency. This is a hands-on, high-ownership engineering role where data accuracy, reliability, and performance are critical.

Key Responsibilities

Data Modeling & Architecture

Design, optimize, and maintain dimensional models (star/snowflake) supporting manufacturing, IoT telemetry, device connectivity, quality, service, and regulatory use cases.

Build scalable warehouse structures in Amazon Redshift, including efficient distribution keys, sort keys, compression encodings, and metadata strategies.

Model complex entities such as device fleets, IoT events, sensor readings, battery health, shift-level utilization, production batches, quality defects, and MES/WMS/ERP entities.

SQL Engineering & ELT Development

Develop high-performance SQL, stored procedures, and ELT jobs that integrate data from:

ERP (Epicor, NetSuite, SAP)

MES/WMS systems

IoT device platforms and telemetry feeds

Quality, service, and regulatory systems

Optimize complex SQL workloads using query plan analysis, statistics, compression, and cluster tuning.

Implement SCD Type 1/2 structures, bridge tables, audit trails, and CDC-style processes.

Build reusable SQL patterns for fleet-level telemetry, battery analytics, connectivity uptime, and traceability.

Production Reliability & Data Governance

Own end-to-end Redshift performance, cost, and reliability for mission-critical tables and processes.

Implement durable auditability and row-level lineage for medical device data (supporting FDA and HIPAA standards).

Participate in on-call/incident response for critical production data issues.

Cross-Functional Collaboration

Work closely with manufacturing engineering, operations, quality, field service, regulatory, and product teams.

Translate business requirements and ambiguous real-world device behavior into precise, validated SQL logic.

Provide technical leadership on data modeling, performance tuning, and SQL coding standards.

Required Skills & Experience

5–10+ years of production-grade SQL development, including advanced windowing, CTEs, dynamic SQL, query plan interpretation, and stored procedures.

Expert-level experience with Amazon Redshift (or deep experience on equivalent MPP systems like Snowflake/BigQuery + strong willingness to operate in Redshift).

Mastery of dimensional modeling (Kimball), including SCDs, conformed dimensions, bridge tables, and history management.

Experience working with manufacturing, IoT, or medical device data—telemetry, event streams, MES/ERP/WMS integration, batch/lot traceability, or uptime analytics.

Strong ability to convert complex business rules into precise, scalable SQL logic.

Solid understanding of AWS ecosystem: Redshift, Step Functions, Lambda, Glue, S3, IAM.

Scripting proficiency in Python for orchestration, validation, AWS automation, and Glue/Airflow-like pipelines.

Familiarity with quality/regulatory expectations in healthcare or medical devices (e.g., audit trails, data retention, validation documentation).

Highly Valued (Nice-to-Have)

Experience with connected medical devices, IoT fleet analytics, or device telemetry pipelines.

Background in regulated environments (FDA, ISO 13485, 21 CFR Part 11).

Exposure to AWS Glue ETL, Step Functions workflows, and Lambda-driven orchestration.

Knowledge of dbt or SQL-based modeling frameworks.

Experience with data lineage or cataloging tools (e.g., Alation, Collibra, Monte Carlo).

You'll Thrive Here If You…

Treat performance, reliability, and data integrity as non-negotiable.

Enjoy reverse-engineering device behavior and manufacturing processes and expressing them in elegant SQL models.

Think like an engineer and like a business analyst—translating real operational workflows into accurate data structures.

Are passionate about making data usable, trusted, traceable, and production-ready.

Communicate clearly with technical and non-technical stakeholders alike.