If you’re the “data plumbing” person who makes sure files flow cleanly, ETLs don’t break, and the business stops panicking, HMA wants you. This role is about building and maintaining the ETL and EDI pipelines that keep internal and external systems talking, with a heavy emphasis on SQL, SSIS, and production support.
About Healthcare Management Administrators (HMA)
HMA is a third-party health plan administrator serving the Pacific Northwest and beyond, building customized health plans for medium to large employers. They’re known for strong customer service, a mission-driven culture (“Proving What’s Possible in Healthcare™”), and they’ve been recognized as one of Washington’s Best Workplaces for three years.
Schedule
- Full-time
- Remote (US-based)
- Hires across the US with exclusions: Hawaii and the cities of Los Angeles and San Francisco
- Flexible schedules supporting multiple US time zones
What You’ll Do
⦁ Design, build, test, deploy, monitor, and run production ETL processes
⦁ Troubleshoot ETL issues in production and lead resolution efforts with clear communication back to the team
⦁ Partner with business users, IT, and vendors to gather requirements and implement or improve database applications and integrations
⦁ Translate business concepts into technical requirements and design (SDLC-driven work)
⦁ Develop, implement, and optimize stored procedures and functions in T-SQL
⦁ Analyze and tune SQL queries for performance (including queries used by front-end apps)
⦁ Create and maintain EDI document mappings for inbound/outbound transactions
⦁ Own SQL development for new products and enhancements to existing systems
⦁ Design ETL/SSIS architecture and build SSIS packages pulling from multiple sources (SQL, flat files, XML) with transformations into target systems
⦁ Evaluate new tools/technologies to modernize existing applications and workflows
What You Need
⦁ 3–5+ years of MSSQL T-SQL development experience
⦁ 3–5+ years of MSSQL SSIS development experience
⦁ 3–5+ years of Data Warehouse / ETL (Extract, Transform, Load) experience
⦁ Strong ability building and optimizing complex SQL queries and stored procedures
⦁ Understanding of inbound/outbound EDI transactions and protocols (and mapping)
⦁ Proficiency in a programming language like C# and/or Python, plus scripting and data analysis comfort
⦁ Strong communication skills (this role touches business users and vendors)
⦁ Bachelor’s in IT/CS preferred (or equivalent experience)
Benefits
⦁ Base salary range (greater Seattle area): $117,000–$145,000 (varies by geography, skills, experience, and market factors)
⦁ Performance-based incentive bonus eligibility
⦁ 17 days PTO (individual contributors)
⦁ 11 paid holidays
⦁ 2 paid personal days and 1 paid volunteer day
⦁ Company-subsidized medical, dental, vision, and prescription insurance
⦁ Company-paid disability, life, and AD&D insurance
⦁ Voluntary insurance options
⦁ HSA and FSA pre-tax programs
⦁ 401(k) with company match
⦁ Annual $500 wellness incentive and $600 wellness reimbursement
⦁ Remote work and continuing education reimbursements
⦁ Parental leave
⦁ Up to $1,000 annual charitable giving match
⦁ Discount program
Real talk: this is a strong fit only if you’ve actually lived in MSSQL/SSIS land and you’re not scared of production fires. If that’s you, this is a clean remote gig with solid pay and benefits.
Happy Hunting,
~Two Chicks…