Data Integrations Engineer II

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. Candidates with experience in the health care and health insurance industry will be preferred, but not a requirement for the position. 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.
• 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.

Knowledge, Experience, and Key Attributes needed for Success:

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

Compensation:
The base salary range for this position in the greater Seattle area is $110,000 - $131,000 and varies dependent on geography, skills, experience, education, and other job or market-related factors. Performance-based incentive bonus(es) is available.
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.
In addition, HMA provides a generous total rewards package for full-time employees that includes:

• 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

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 www.accesshma.com .