Software Engineer III SQL Developer
Job Description
Hawaii Mainland Administrators, LLC is a privately held, national Healthcare company which provides a broad range of development, management and information services. Full time employment has career growth opportunities, life insurance, paid Holidays, PTO and many more great benefits.
Hawaii Mainland Administrators, LLC ( HMA, LLC ) is seeking a full time SOFTWARE ENGINEER 5 SQL DEVELOPER for our Tempe, AZ location. The prospective candidate will need excellent oral and written communications. They should have the ability to maintain a courteous and professional demeanor while working under pressure self-starter with the ability to work independently and as part of a team, detail oriented, strong analytical ability.
Salaried position with 401(k), paid Holidays and excellent company paid benefits. EOE Submit resume and wage requirements to [employment@hmatpa.com] or fax to 866-293-9670.
SUMMARY: The Software Engineer IV works within the Application Development & Support team to provide software programming for new software, production support and maintenance for existing software, as well as ad-hoc support of key departmental business areas, databases, applications, and tools which drive business functions. The Software Engineer IV works under general supervision and instruction from management or lead software engineers.
ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned
· Gains a thorough understanding of functional requirements for new software requests
· Develops software and performs testing of software applications to meet functional requirements
· Practices good software development techniques and standards to reduce coding errors and ensures robustness and efficiency of work products
· Partners with software teams in the development of the software engineering processes
· Works to identify and resolves technical or product problems
· Participates in software project meetings and provides status reports
· Translates technical designs into working software
· Maintains existing applications by enhancing software and troubleshooting issues
· Collaborates with team members and partner with others as needed to ensure successful completion of assigned software development tasks
· Participates in code reviews and incorporates recommendations
· Applies Object Oriented Design principles and design patterns in creating System level solution designs
· Creates and maintains software design specifications document
· Assumes full responsibility for assigned tasks and end-to-end accountability for end-product delivery
· Makes recommendations to IT management for the adoption of (1) new technology (2) industry’s best practices, and (3) streamlining processes
· Communicates and presents designs in group settings to technical and non-technical audiences
· Partners with team members and technical project lead to ensure component design fits in with the overall solution
· Adopts new techniques and technologies
· Initiates attendance at job related training to keep skills current. Maintains current understanding of the industry’s best practices
· Mentors/trains and may assign workflow to less-experienced IT staff members
CLIENT RESPONSIBILITIES
This is an internal (and external to IT) client facing position that requires excellent customer service skills and interpersonal communication skills (listening/verbal/written). One must be able to; manage difficult or emotional client situations; Respond promptly to client needs; Solicit client feedback to improve service; Respond to requests for service and assistance from clients; Meet commitments to clients.
QUALIFICATIONS
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
EDUCATION AND/OR EXPERIENCE
Bachelor’s degree (or equivalent) and 12+ years’ related experience.
COMPUTER SKILLS
· SQL development in Microsoft SQL, IBM DB2, Oracle or MySQL
· Database knowledge to create/edit tables, views, and stored procedures
· EDI tool understanding or knowledge of exporting SQL result to file
· EDI format and protocol, HIPAA and X12 EDI standards
· Reporting platform, JasperReports, Microsoft SSRS, Microsoft Power BI, or another tool
OTHER SKILLS AND ABILITIES
· Demonstrated ability to work collaboratively on project teams and/or matrix-managed teams.
· Ability to appropriately schedule and prioritize multiple projects to ensure timely and effective delivery of IT solutions.
· Excellent written and verbal communications skills with emphasis on translating technical concepts to non-technical audiences.
· Prefer familiarity with PBM business model (plans, programs, and practices) as well as pharmaceutical practices (nomenclature, medications).
Company Description
Full time employment has career growth opportunities, life insurance, paid Holidays, PTO and many more great benefits.