Job Description
Insight Global is seeking a Senior Developer – Exchange Encounters & Risk Adjustment (SQL / EDM) for a top healthcare client. This role is highly hands-on with SQL Server and SSIS, focused on building and managing ETL pipelines that move SQL-based healthcare data into submission-ready formats using EDM tools. The ideal candidate has strong experience writing stored procedures, developing SSIS workflows, and using C# within SSIS for custom logic. They should understand healthcare data structures—particularly Medicare/Medicaid encounters—and be comfortable ensuring accurate data mapping, validation, and end-to-end flow across systems.
This is a highly visible role centered on transitioning encounter data processing in-house from a third-party vendor and delivering a proof-of-concept in one exchange market, with plans to scale across additional markets. It is more focused on data integration and submission workflows than cloud data warehousing, requiring close collaboration with product, business, and technical teams.
Day-to-Day:
Build and manage encounter submission files using EDM tools
Perform ETL processes to move data from SQL systems to required file formats
Collaborate with business analysts and product teams to gather and refine requirements
Work closely with architects and QA to ensure data accuracy and integrity
Participate in code versioning and deployment processes using GitLab and Jenkins
Support transition from vendor-managed to in-house solutions
Ensure proper data mapping and flow across healthcare systems
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
Strong hands-on experience with SQL Server (writing queries, building tables)
Experience with ETL development (especially straightforward data movement from SQL to flat files)
Experience using C# inside SSIS
SSIS (SQL Server Integration Services) experience
Familiarity with healthcare data models, particularly encounters (Medicare/Medicaid submissions)
Experience working with EDM tools (or similar data integration platforms)
Understanding of version control systems (GitLab preferred)
Ability to understand end-to-end data flow and consequences of data changes
Strong collaboration skills across Product Managers, BAs, Developers, Architects, and QA
Nice to Have Skills & Experience
Experience with Facets platform
Exposure to Azure Databricks / Data Lakes (future state work)
Healthcare Exchange market experience
Familiarity with CI/CD pipelines (Jenkins)
Prior experience replacing vendor-managed solutions (e.g., Inovalon)
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.