Mandatory skills:
Strong SQL / Claims and NDW/VBP Experience preferred
SQL Developer II
The SQL Developer role will support several internal applications and participate in the modernization of HMA’s internal systems.
This position will be responsible for the application of engineering to the design, development, implementation, testing and maintenance of software in a systematic method.
The roles in this function will cover all primary development activity across all technology functions that ensure we deliver code with high quality for our applications, products, and services and to understand customer needs.
Primary Responsibilities:
Working with business users to gather requirements and design, create, and implement database systems / applications.
•Develop, design, and implement stored procedures, functions, and views using T-SQL.
•Provide technical support and guidance to testing teams.
•Evaluating new tools, new technologies to help modernize existing applications.
•Must possess critical analytical and complex problem-solving skills.
Required Qualifications:
•Strong proficiency with SQL (T-SQL preferred).
•Skilled at building and optimizing large, complicated SQL queries.
•Experience in analyzing and resolving performance issues with queries including query and database schema / index optimization.
•Knowledge of best practices when dealing with relational databases
•Capable of troubleshooting common database issues
•Bachelor's degree in IT or equivalent experience
•Excellent written and verbal communication skills
Preferred Qualifications:
•Experience working in an agile environment with DevOps tools including Azure DevOps, Azure pipelines.
•Proven ability to work independently with less structured, more complex tasks
•EDI experience
•Knowledge / experience working in a Health Care / Health insurance environment.
•Experience integrating systems with external parties including Blue Cross and National Data Warehouse
Bachelor’s Degree