Employer: International Medical Group, Inc.
Title: Business Intelligence Senior Data Engineer
Location: 9200 Keystone Crossing, Suite 800, Indianapolis, IN 46240
Duties: Independently integrate complex data from multiple operational systems into an Enterprise Data Warehouse (EDW). Design, build, and support SSIS-based ETL pipelines, including performance tuning and troubleshooting, Perform detailed data mapping, analysis, and data migrations, Ensure adherence to Bl best practices, DevOps workflows, and IMG development standards. Design and develop robust reporting solutions with SSRS and Power Bl. Build reusable data models for analytics and operational reporting. Provide ad-hoc data extracts with a focus on transitioning to self-service. Evaluate, design, and implement Al/ML solutions including LLM-based agents, OCR, and automation tools. Build production-grade Al solutions using AWS Bedrock and Claude. Serve as technical owner for multi-agent LLM implementations supporting key business operations. Partner directly with senior business stakeholders to define requirements and solution approaches. Lead code reviews, enforce engineering standards, and mentor junior developers. Provide ongoing support for production Bl environments. Participate in change control processes, ensuring tested and accurate deployments. Position is based in Indianapolis, IN office; however, telecommuting from a home office is allowed. Hybrid work arrangement required for at least first 2 years of employment.
Requirements: Requires a Bachelor’s degree in Computer Science, Engineering, Management Information Systems (MIS), Mathematics, Business, or a related field plus ten (10) years of experience as a Data Scientist, Business Intelligence Engineer, or related occupation. Experience may be gained concurrently and must include:
Five (5) years in the following:
- Hands-on experience integrating multiple operational system data into an EDW.
Four (4) years in each of the following:
- Working with star schema or dimensional data modeling
- Developing reporting solutions for production environments using SSRS and Power Bl.
- End-to-end ETL development with SSIS, including experience optimizing and troubleshooting performance issues
- Implementing production Al solutions including ML (Python), LLMs, and OCR
- Working with travel medical claims systems such as LCS or Actisure
- Working with Travel Medical, Trip Cancellation, and Assistance Insurance data.
Two (2) years in each of the following:
- Experience with the full software development life cycle with separate Development, QA, and Production environments using Visual Studio
- Working with policy/certificate data as AdminSys
- Hands-on experience deploying solutions using AWS Bedrock and Claude
- Ownership of a large-scale LLM multi-agent implementation supporting real business processes (excluding POCs or prototypes)
- Experience with trip coverage claims (Actisure, Trident Travel, NIS or similar)
- Experience with assistance platforms Dynamo or NIS
- Working with document management systems such as OnBase or similar.
Multiple positions. Apply online -- https://www.imglobal.com/careers Job Code: PRJ-BISDE.
#LI-DNI
Skills Required
- Bachelor's degree in Computer Science, Engineering, Management Information Systems, Mathematics, Business, or a related field
- Ten years of experience as a Data Scientist, Business Intelligence Engineer, or in a related occupation
- Alternatively, a Master's degree and eight years of experience
- Five years integrating data from multiple operational systems into an enterprise data warehouse
- Four years working with star schema or dimensional data modeling
- Four years developing production reporting solutions using SSRS and Power BI
- Three years of end-to-end SSIS ETL development, including performance optimization and troubleshooting
- Three years implementing production AI solutions involving machine learning with Python, LLMs, and OCR
- Three years working with travel medical claims systems such as LCS or Actisure
- Three years working with travel medical, trip cancellation, and assistance insurance data
- Two years working across separate Development, QA, and Production environments using Visual Studio
- Two years working with policy or certificate data in AdminSys
- Two years deploying solutions using AWS Bedrock and Claude
- Two years owning a large-scale production LLM multi-agent implementation supporting real business processes
- Two years working with trip coverage claims systems such as Actisure, Trident Travel, NIS, or similar
- Two years working with assistance platforms such as Dynamo or NIS
- Two years working with document management systems such as OnBase or similar
What We Do
International Medical Group® (IMG®), an award-winning provider of global insurance benefits and assistance services for more than 25 years, enables its members to worry less and experience more by delivering the protection they need, backed by the support they deserve. IMG offers a full line of international medical insurance products, as well as trip cancellation programs, stop loss insurance, medical management services and 24/7 emergency medical and travel assistance — all designed to provide members Global Peace of Mind® while they’re away from home.
