Healthcare Management Administrators-posted about 2 months ago
$117,000 - $145,000/Yr
Full-time • Mid Level
Remote • Bellevue, WA
101-250 employees

HMA is the premier third-party health plan administrator across the PNW and beyond. We relentlessly deliver on our promise to provide medium to large-size employers with customized health plans. We offer various high-quality, affordable healthcare plan options supported with best-in-class customer service. We are proud to say that for three years, HMA has been chosen as a ‘Washington’s Best Workplaces’ by our Staff and PSBJ™. Our vision, ‘Proving What’s Possible in Healthcare™,’ and our values, People First!, Be Extraordinary, Work Courageously, Own It, and Win Together, shape our culture, influence our decisions, and drive our results. What we are looking for: We are always searching for unique people to add to our team. We only hire people that care deeply about others, thrive in evolving environments, gain satisfaction from being part of a team, are motivated by tackling complex challenges, are courageous enough to share ideas, action-oriented, resilient, and results-driven. What you can expect: You can expect an inclusive, flexible, and fun culture, comprehensive salary, pay transparency, benefits, and time off package with plenty of personal development and growth opportunities. If you are looking for meaningful work, a clear purpose, high standards, work/life balance, and the ability to contribute to something important, find out more about us at: https://www.accesshma.com/ How YOU will make a Difference: The Data Integrations Engineer plays a key role ensuring the smooth transmission and processing of data between internal and external systems. The ideal candidate will have experience in writing complex SQL queries, creating ETL’s, and understanding inbound and outbound EDI transactions and protocols. The incumbent will work closely with IT, business partners, and external vendors to implement new systems and update existing systems. Excellent communication skills are a must to ensure the continued smooth operation of the company.

  • 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.
  • 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.
  • 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
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service