Senior Data & Integration Engineer

Simplify Alpha™; Hyderabad; Hybrid; INR 1,800,000 - 2,400,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

Simplify Alpha™ is seeking a Senior Data & Integration Engineer in Hyderabad to design, build, and support data pipelines, BI reporting, and enterprise integration flows. The role blends hands-on data engineering with AWS Glue, Power BI analytics, and IBM ACE/ACE ESQ integration, plus emphasis on AI-assisted engineering practices.

You will collaborate with onshore architects and stakeholders in a hybrid work model, driving performance, governance, and scalable solutions across health plan

Qualifications

• 8–12 years of experience across data engineering, BI development, and/or systems integration
• Hands-on experience with AWS Glue for ETL/ELT development using Python and/or PySpark
• Experience with AWS data services: S3, Redshift, Athena, Glue Data Catalog
• Strong SQL skills across relational databases and cloud data warehouses
• Knowledge of dimensional modeling (star schema) for BI/reporting
• Experience with IBM Message Broker/ACE and IBM MQ
• Excellent written and verbal communication for cross-functional collaboration

Responsibilities

• Design, build, and maintain ETL/ELT pipelines using AWS Glue (Python/PySpark)
• Develop and publish interactive Power BI dashboards and reports
• Design, build, and support integration flows with IBM ACE and IBM MQ
• Optimize pipelines for performance, reliability, and cost
• Translate requirements into technical solutions with business and platform teams
• Enforce data quality, governance, and lineage across pipelines
• Troubleshoot production issues with root-cause analysis and fixes
• Document data flows and BI semantic models for knowledge sharing
• Mentor junior/mid engineers in data engineering and BI
• Collaborate on evolution of data and integration architecture

Skills

Data engineering

BI development

Integration

AWS Glue

Power BI

IBM ACE/ACE ESQ

SQL

ETL/ELT patterns

AI-assisted development

Communication

Education

Bachelor's degree in Computer Science, Engineering, Information Systems, or related field

Tools

Python

PySpark

S3

Redshift

Glue Data Catalog

DAX/Power Query (M)

IBM MQ

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 maintain ETL/ELT pipelines using AWS Glue (Python/PySpark) to ingest, transform, and load data across AWS-based data platforms (S3, Redshift, Athena, Glue Data Catalog)
• Develop, publish, and maintain interactive Power BI dashboards and reports, including data modeling, DAX measures, and Power Query (M) transformations
• Design, build, and support integration 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, BI datasets, and integration flows for performance, reliability, and cost-efficiency
• Partner with business, data, and platform teams to translate reporting, analytics, and integration requirements into technical solutions
• Establish and enforce data quality, governance, and lineage practices across ETL and integration pipelines
• Troubleshoot and resolve production 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 knowledge sharing
• Mentor junior and mid-level engineers 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 Computer Science, Engineering, Information Systems, or a related field
• 8-12 years of experience across data engineering, BI development, and/or systems integration, with hands-on delivery experience in at least two of these areas
• Strong, hands-on experience with AWS Glue for ETL/ELT development using Python and/or PySpark
• Working experience with supporting AWS data services: S3, Redshift, Athena, and Glue Data Catalog
• Strong experience building and administering Power BI dashboards and reports, including data modeling, DAX, Power Query (M), workspaces, gateways, and scheduled refresh
• Hands-on experience developing and supporting message/integration flows on IBM Message Broker or IBM AppConnect Enterprise (ACE), including ESQL and integration node/server 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 data modeling (star schema) for BI and reporting use cases
• Strong grasp of ETL/ELT design patterns, data quality checks, and data governance practices
• Strong debugging, performance-tuning, production-support skills across data pipelines and integration systems
• Excellent written and verbal communication skills for cross-functional and client-facing 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