Job Description: The Developer will support the National Patient Information Reporting System (NPIRS) and the National Data Warehouse (NDW) initiative of the Office of Information Technology (OIT), Indian Health Service (IHS). The position is located in Albuquerque, NM. All work performed at the client’s site, however, telework may be available on a case-by-case basis. The primary platform is IBM with Intel serving as a secondary platform. Developer will maintain a close relationship with NDW analysts and DBAs and become knowledgeable about the business side processes while becoming an expert on the application and operational data and processes that support the business. Duties require a broad knowledge of data sources, data flow, system interactions and strong structured query language (SQL) within a relational DB2 and SQL Server database systems to ensure the following:
Responsible for the development implementation and maintenance of mission critical applications in SQL and object oriented programming.
Provide support for Unix and Windows based ETL using in-house tools.
Provide troubleshooting for application issues.
Provide technical support for application related activities.
Assist in the development of specifications and requirements.
Further refine the physical design of applications and processes to meet requirements.
Install and testing new versions of various COTS packages and ensure they meet security requirements, SOP’s and practices.
Maintain data standards, including adherence to the Data Protection Act and HIPPA.
Develop and install new applications to requirements.
Participate in design reviews.
Provide assistance in incident response.
Perform potential tool or COTS software evaluation for incorporation in the system.
Provide sound, quantifiable recommendations for systemic changes or updates.
Continuously improve knowledge base by internally generated research and development initiatives.
Develop and maintain application architecture, standards, conventions, naming standards, and data dictionary.
Work with technical writers to update technical guides and other system documentation including identifying and documenting conceptual design for processes.
Utilize and maintain development and QA environments.
Create data flows and conceptual models defining the informational needs of projects.
Maintain and update Java code with embedded SQL.
Identify and recommend process and application improvements
Qualifications: Bachelor’s degree preferred and/or 8 years related experience in a software/systems environment. At least 5 years of SQL and/or object programming experience. Strong Analytical and problem solving skills. Specification and requirements gathering/documenting. Strong and effective communication skills. Well-developed organizational skills; experience working in a team environment; relational database knowledge; strong SQL language and MS office. Preferred skills include knowledge of healthcare related data; past experience working with DB2, SQL Server and other RDBMS; UNIX shell scripting, KSH, AWK and/or PERL; Rational tools, JAVA and Syncsort (e.g DMX) products.
Telecommuting is allowed.
Additional Salary Information: A comprehensive compensation package that includes paid annual leave and holidays, health and dental insurance and a corporate 401(k) program, and educational assistance programs.