The Data Integrations Engineer II ensures data transmission between systems, develops ETL processes, optimizes SQL queries, and collaborates with stakeholders.
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:
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:
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 .
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.
- 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 .
Top Skills
C#
Edi
Python
SQL
Ssis
T-Sql
Similar Jobs at Healthcare Management Administrators (HMA)
Healthtech • Insurance
The Care Management Coordinator assesses healthcare needs, coordinates care with providers, creates denial letters, and ensures positive member experiences.
Top Skills:
MS Office
Healthtech • Insurance
The Chief People Officer develops and executes HR strategy, oversees talent acquisition, employee experience, and organizational development while fostering a high-performance culture and ensuring compliance with employment laws.
Healthtech • Insurance
The SDET II is responsible for developing and executing automated test scripts, collaborating with developers, and ensuring quality software through testing and documentation.
Top Skills:
Azure DevopsBambooCi/CdGithub ActionsJenkinsPerlPlaywrightRestSeleniumSoap
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.