Contract Data Integrations Engineer I

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:


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.

What YOU will do:

• 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.

Requirements

Knowledge, Experience and Attributes:

• BA Degree in computer science or related field preferred
• 1-3+ years of experience in MSSQL T-SQL development
• 1-3+ years of experience in MSSQL SSIS development
• 1-3+ years of experience with Data Warehouse - (ETL) Extract, Transform, and Load
• Proficiency in programming languages (C# / Python), scripting, and data analysis tools.
• Bachelor's degree in IT or equivalent experience
• Excellent communication skills.

Benefits

Application Note:

When applying, please include the phrase " What stood out to me about this role is... " somewhere in your application.

Compensation:

Compensation for this contract role ranges from $45-$60 per hour, and varies dependent on geography, skills, experience, education, and other job or market-related factors. You'll be onboarded through one of our trusted staffing partners, which allows you to access a suite of employee-style perks-including PTO and benefits-if you choose to opt in. This setup gives you the flexibility of contract work with the option to enjoy additional support and coverage.

Disclaimer: The salary, other compensation, and benefits information are accurate as of this posting date. HMA reserves the right to modify this information at any time, subject to applicable law.

How we Support your Work, Life, and Wellness Goals

At HMA, we believe in recognizing and celebrating the achievements of our dedicated staff. We offer flexibility to work schedules that support people in all time zones across the US, ensuring a healthy work-life balance. Employees have the option to work remotely or enjoy the amenities of our renovated office located just outside Seattle with free parking, gym, and a multitude of refreshments. Our performance management program is designed to elevate career growth opportunities, fostering a collaborative work culture where every team member can thrive. We also prioritize having fun together by hosting in person events throughout the year including an annual all hands, summer picnic, trivia night, and a holiday party.

We hire people from across the US (excluding the state of Hawaii and the cities of Los Angeles and San Francisco.)


HMA requires a background screen prior to employment.

Protected Health Information (PHI) Access Healthcare Management Administrators (HMA); employees may encounter protected health information (PHI) in the regular course of their work. All PHI shall be used and disclosed on a need-to-know-basis and according to HMA's standard policies and procedures.

HMA is an Equal Opportunity Employer.

For more information about HMA, visit