Senior Data & Integration Engineer
Simplify AlphaTM · Hyderabad, Telangana, India · Full Time · Hybrid
Posted
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/Py Spark) to ingest, transform, andload data across AWS-based data platforms (S3, Redshift, Athena, Glue Data Catalog) Develop, publish, and maintaininteractive Power BI dashboards and reports, including data modeling, DA Xmeasures, 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 andexternal 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 andplatform 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 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 Py Spark 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 App Connect 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-facing collaboration AI Knowledge & AI-Assisted Development (Required) Daily, practical use of AI coding/assistant tools (e.g., Claude Code, Git Hub 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