EMPLOYER: Health Management Systems, Inc.
JOB TITLE: Developer Analyst II
LOCATION: Irving, TX
o Develop, modify, implement, and support applications to meet complex business requirements for end user application with a minimum of managerial guidance;
o Develop and maintain ETL (Extraction Transformation and Load) processes to either output for client usage or the onboarding of client data using SSIS (SQL Server Integration Services);
o Implement complex business logic to meet end customer use cases by developing solutions using Microsoft T-SQL, SQL Server, and SSMS (SQL Server Management Studio);
o Design and build and understand complex database relationships (tables, constraints, indexes, triggers, functions, views, and procedures);
o Improve database performance using query tuning techniques, indexing and industry best practices to deliver the highest performing solutions;
o Involvement in the testing process by participating in test reviews and analysis, test witnessing, and certification of software, including designing test plans, scenarios, scripts, or validation procedures and writing complex SQL on large databases to validate testing;
o Interact with Business Systems Analysts to ensure programmed solution meets the defined requirements, assist in production task remediation, research existing code & data and solve processing issues with a quick turnaround time;
o Manage IT projects using ServiceNow and provide status reports as needed.
o Master's or foreign equivalent degree in Information Systems, Computer Science, Information Technology and Management, or a related field and 2 years of experience with database design, query development, performance analysis, tuning, and indexing; and ETL process using T-SQL, SQL Server, SSMS, and SSIS.
o Experience therein to include 1 year with source control configuration, versioning and promotion using SVN and GIT, .Net programming, ServiceNow, Citrix Workspace, and Windows Remote Server.
CONTACT: HMS Recruiting, Attn:
Justin Haesly, 5615 High Point Dr., Irving, TX 75038. Job # PCJ1-W.