EDI Data Integrations Engineer II jobs in United States
cer-icon
Apply on Employer Site
company-logo

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
check
H1B Sponsor Likelynote

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

MSSQL T-SQL developmentMSSQL SSIS developmentData Warehouse (ETL)SQL query optimizationC# / Python programmingAnalytical skillsCommunication skillsProblem-solving skills

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

twittertwittertwitter
company-logo
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 Stage

Leadership Team

leader-logo
Lindsay Harris
Board Member
linkedin
Company data provided by crunchbase