Senior Data & Integration Engineer

Simplify Alpha; Hyderabad; Hybrid; INR 3,500,000 - 7,000,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

Simplify Alpha in Hyderabad is seeking a Senior Data & Integration Engineer to design, build, and support data pipelines, BI reporting, and enterprise integration flows across our health plan technology platform. The role blends hands-on data engineering with AWS Glue, Power BI, and ACE-based integration, in a hybrid work model with onshore collaboration.

You'll optimize ETL/ELT pipelines, enforce data quality and governance, mentor junior engineers, and work with architects to evolve our data

Qualifications

• 8–12 years experience across data engineering, BI development, and/or systems integration.
• Hands-on delivery in at least two of these areas.
• Strong, hands-on experience with AWS Glue for ETL/ELT (Python and/or PySpark).
• Experience with supporting AWS data services: S3, Redshift, Athena, Glue Data Catalog.
• Strong Power BI dashboards development, including data modeling, DAX, Power Query (M).
• Hands-on experience with IBM Message Broker/ACE (ESQL) and IBM App Connect Enterprise administration.
• Working knowledge of IBM MQ for queue and messaging management.
• Strong SQL skills across relational databases and cloud data warehouses.
• Solid understanding of dimensional modeling (star schema) for BI/use cases.
• Strong data quality, governance, and ETL/ELT design pattern knowledge.
• Excellent written and verbal communication for cross-functional collaboration.

Responsibilities

• Design, build, and maintain ETL/ELT pipelines using AWS Glue to ingest, transform, and load data across AWS platforms.
• Develop, publish, and maintain interactive Power BI dashboards and reports with data modeling and DAX measures.
• Design and support integration and message flows using IBM ACE/ACE and IBM MQ for real-time and batch data exchange.
• Optimize data pipelines and BI datasets for performance, reliability, and cost-efficiency.
• Collaborate with business, data, and platform teams to translate requirements into technical solutions.
• Establish data quality, governance, and lineage practices across pipelines and integration flows.
• Troubleshoot production issues with root-cause analysis and permanent fixes.
• Document data flows, integration patterns, and BI semantic models for knowledge sharing.
• Mentor junior/mid-level engineers on data engineering, BI, and integration best practices.
• Collaborate with architects on the evolution of data and integration architecture.

Skills

AWS Glue

Power BI

Python

PySpark

SQL

ETL/ELT

Data modeling

AI-assisted dev

Mentoring

Communication

Education

Bachelor's degree in CS/Engineering/IS

Tools

ACE/IBM App Connect Enterprise

IBM MQ

AWS Glue

S3

Redshift

Job description

We are looking for a Senior Data & Integration Engineer to design, build, and support data pipelines, BI reporting, and enterprise integration flows across our health plan technology platform. This role combines hands-on data engineering with AWS Glue, reporting and analytics with Power BI, and integration development with IBM Message Broker / App Connect Enterprise (ACE), and carries a strong expectation of AI-Assisted engineering practice. You will be based in Hyderabad in a hybrid work model, partnering closely with onshore architects, business stakeholders, and other engineering teams.

Key Responsibilities

• Design, build, and maintainETL/ELT pipelines using AWS Glue (Python/PySpark) to ingest, transform, and load data across AWS-based data platforms (S3, Redshift, Athena, Glue DataCatalog)
• Develop, publish, and maintaininteractive Power BI dashboards and reports, including data modeling, DAXmeasures, and Power Query (M) transformations
• Design, build, and supportintegration and message flows using IBM Message Broker / App Connect Enterprise(ACE) and IBM MQ for real-time and batch data exchange between internal and external systems
• Optimize data pipelines, BIdatasets, and integration flows for performance, reliability, and costefficiency
• Partner with business, data, and platform teams to translate reporting, analytics, and integrationrequirements into technical solutions
• Establish and enforce dataquality, governance, and lineage practices across ETL and integration pipelines
• Troubleshoot and resolveproduction issues across data pipelines, BI datasets, and integration flows, including root-cause analysis and permanent fixes
• Document data flows, integration patterns, and BI semantic models to support internal knowledgesharing
• Mentor junior and mid-levelengineers on data engineering, BI development, and integration best practices
• Collaborate with architects and platform leads on the evolution of the data and integration architecture

Required Qualifications

• Bachelor's degree in ComputerScience, Engineering, Information Systems, or a related field
• 8-12 years of experience acrossdata engineering, BI development, and/or systems integration, with hands-ondelivery experience in at least two of these areas
• Strong, hands-on experiencewith AWS Glue for ETL/ELT development using Python and/or PySpark
• Working experience withsupporting AWS data services: S3, Redshift, Athena, and Glue Data Catalog
• Strong experience building andadministering Power BI dashboards and reports, including data modeling, DAX, Power Query (M), workspaces, gateways, and scheduled refresh
• Hands-on experience developingand supporting message/integration flows on IBM Message Broker or IBM AppConnect Enterprise (ACE), including ESQL and integration node/serveradministration
• Working knowledge of IBM MQ forqueue and messaging management
• Strong SQL skills acrossrelational databases and cloud data warehouses
• Solid understanding ofdimensional data modeling (star schema) for BI and reporting use cases
• Strong grasp of ETL/ELT designpatterns, data quality checks, and data governance practices
• Strong debugging,performance-tuning, and production-support skills across data pipelines andintegration systems
• Excellent written and verbalcommunication skills for cross-functional and client-façing collaboration

AI Knowledge & AI-Assisted Development (Required)

• Daily, practical use of AI coding/assistant tools (e.g., Claude Code, GitHub Copilot, Cursor, or similar) to accelerate development of Glue ETL scripts, Power BI DAX/Power Query logic, and ACE message flows/ESQL
• Able to critically review and validate AI-generated code, transformations, and queries for correctness, performance, and data integrity before deployment
• Practical use of AI tools to assist with data profiling, anomaly detection, dashboard narrative/summary generation, and technical documentation
• Understanding of secure and compliant AI tool usage, including never entering PHI, member data, or other sensitive health plan data into prompts or external AI tools
• Able to identify where AI-driven automation can improve pipeline development, testing, or reporting efficiency, and champion adoption within the team

Preferred Qualifications

• Experience in the US health insurance or payer domain: claims, eligibility, enrollment, provider, or member data, with HIPAA-aware data handling practices
• Exposure to healthcare data standards (X12 EDI, HL7, FHIR)
• Experience with additional AWS data services: Lambda, Step Functions, EMR, Kinesis, or DMS
• Experience with Kafka or other event-streaming platforms for real-time integration
• Experience with Power BI Premium/Fabric or Power Automate for extended BI automation
• Relevant certifications such as AWS Certified Data Engineer/Analytics Specialty, Microsoft Power BI certifications, or IBM integration certifications

You can always press Enter to continue