Healthcare Management Administrators · 2 months ago
EDI Data Integrations Engineer II
Healthcare Management Administrators (HMA) is a premier third-party health plan administrator dedicated to providing customized health plans. The EDI Data Integrations Engineer II will ensure the smooth transmission and processing of data between systems, utilizing skills in SQL and ETL processes while collaborating closely with IT and business partners.
Health CareInsurance
Responsibilities
Design, code, test, deploy, maintain, monitor and execute production ETL processes
Investigate production ETL issues / problems
Work with business users to gather requirements and design, create, and implement database systems & applications
Lead troubleshooting episodes and communicate solutions/resolutions to the team
Translate concepts to requirements and technical design
Complete projects and development activities timely and accurately while following the System Development Life Cycle (SDLC)
Develop, implement, and optimize stored procedures and functions using T-SQL
Analyze existing SQL queries for performance improvements
Create and update EDI document mappings
Take ownership of SQL development for future products and enhancements of existing products
Must possess analytical and complex problem-solving skills
Performance tuning of database assets and writing queries used for front-end applications (websites, desktop applications, or cloud apps)
Evaluating new tools, new technologies to help modernize existing applications
Designing Architecture for ETL/SSIS packages and Designing SSIS packages with different data sources (SQL, Flat files and XMLs etc.) and loaded the data into target source by performing different kinds of transformations
Qualification
Required
BA Degree in computer science or related field preferred
3-5+ years of experience in MSSQL T-SQL development
3-5+ years of experience in MSSQL SSIS development
3-5+ years of experience with Data Warehouse - (ETL) Extract, Transform, and Load
Skilled at building and optimizing complicated SQL queries and stored procedures
Proficiency in programming languages (C# / Python), scripting, and data analysis tools
Bachelor's degree in IT or equivalent experience
Excellent communication skills
Benefits
Seventeen (IC) days paid time off (individual contributors)
Eleven paid holidays
Two paid personal and one paid volunteer day
Company-subsidized medical, dental, vision, and prescription insurance
Company-paid disability, life, and AD&D insurances
Voluntary insurances
HSA and FSA pre-tax programs
401(k)-retirement plan with company match
Annual $500 wellness incentive and a $600 wellness reimbursement
Remote work and continuing education reimbursements
Discount program
Parental leave
Up to $1,000 annual charitable giving match
Company
Healthcare Management Administrators
HMA is Proving What's Possible in Healthcare®.
H1B Sponsorship
Healthcare Management Administrators has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (3)
2024 (2)
2023 (1)
2022 (1)
Funding
Current Stage
Growth StageRecent News
2025-09-30
Company data provided by crunchbase