Job Description
Insight Global is seeking a Senior Developer – Exchange Encounters & Risk Adjustment (SQL / EDM) for a top healthcare client. This candidate will play a critical role in bringing encounter data processing in-house, transitioning away from a third-party vendor. They will work on building and managing ETL pipelines that transform SQL-based healthcare data into submission-ready formats using EDM tools. The ideal candidate brings strong SQL and SSIS experience, understands healthcare data structures (especially Medicare/Medicaid encounters), and thrives in a collaborative, cross-functional environment. This is a highly visible role focused on delivering a proof-of-concept implementation in one exchange market, with expansion planned across additional markets.
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)
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.