Applications Systems Analyst/Programmer Senior
Company: University of Arkansas for Medical Sciences
Location: Little Rock
Posted on: January 14, 2019
Requisition ID 2018-46026 Category Info Technology Position Type Regular Full-Time Department ACHI Health Data Initiative Post End Date 1/23/2019 Overview Applications Systems Analyst/SQL Database Developer/Analyst Senior work as part of the Arkansas Center for Health Improvement (ACHI) Data Team primarily developing and maintaining ACHI analytic data warehouse solutions utilizing SQL Server. The University of Arkansas for Medical Sciences (UAMS) has a unique combination of education, research, and clinical programs that encourages and supports teamwork and diversity. We champion being a collaborative health care organization, focused on improving patient care and the lives of Arkansans. UAMS offers amazing benefits and perks: * Health: Medical, Dental and Vision plans available for staff and family * Holiday, Vacation and Sick Leave * Education discount for staff and dependents (undergraduate only) * Retirement: Up to 10% matched contribution from UAMS * Basic Life Insurance up to $50,000 * Career Training and Educational Opportunities * Merchant Discounts * Concierge prescription delivery on the main campus when using UAMS pharmacy Salary: Negotiable Responsibilities * Supports contributing data systems, file management, conducts analysis using statistical software and preparing tables and reports as needed. * Manages and maintains the GIS infrastructure using ArcGIS. * Involved with the maintenance, development, and deployment to Microsoft Azure. * Conducts extract, transform and load (ETL) analysis, designs ETL processes, maintains process and system documentation, conducts application unit testing, assists in application functional, integrated, and performance testing; resolves problems, and participates in 'on call' support for internal staff. * Build and maintain database systems * Extract, transform and load (ETL) processes * Conduct database design, installations, conversions * Conduct database backup and recovery procedures, access security and database integrity, physical data storage design and data storage management * Design, develop and implement reports in SSRS * Administer and maintain GIS environment * Complete definition of standards of data dictionaries * Perform performance tuning * Monitor database performance and space requirements * Schedule and monitor end of day data warehousing jobs * Assist in coordinating software releases * Communicate accurate and useful status updates * Maintain quality standards * Production environment Tools/Utilities * Author shell scripts to perform back up, restore, and monitoring tasks * Create and document project requirements to fit in established Agile work-flow * Anticipate and resolve issues specific to the team * Determine time estimates and schedule for own work and resolve issues in a timely manner. Identify and track issues, risks and action items * Provide status of work to project team lead and project manager. * Engage in ongoing process improvement. * Ability to work in a project team environment * Ability to execute all responsibilities with little direct supervision of Team Lead * Possess strong written and oral communication skills * Possess business systems analysis and design experience * Knowledgeable in logical data modeling techniques * Knowledgeable in data analysis and database management techniques * Knowledgeable in utilization of both physical systems and cloud based systems * Possess administration and scripting experience in relative platform * Customer Service: Interacts with and assists the public in a professional and friendly manner as needed. Demonstrates effective communication skills; communicates accurate and complete information; maintains strict confidentiality when necessary. Demonstrates positive working relationships with co-workers, management team, and ancillary departments; follows the Core Concepts of Patient and Family Centered Care and the Basic Code of Conduct Guidelines. Assist internal and external stakeholders as needed with Qualifications Minimum Qualifications: * Bachelor's Degree in Information Technology, Computer Science, Social Science or related field * Eight (8) years of experience to include Microsoft SQL Server query language, multi-source database integration solutions, Microsoft SSIS and SSRS, ******* solutions, GIS * Special Knowledge of below Applications: RDBMS - SQL SERVER SQL - Query Analyzer, Profiler, SQL MAIL, SQL Agent SQL Server Utility - SSIS, SSAS, SQL Server CLR, Redgate Warehouse/Reporting - SSRS, ETL Visualization - Tableau, Power BI, ArcGIS desktop Programming Languages - T-SQL,C#, Python, PHP Development Tools- BI Studio/Visual Studio 2013+, TFS Additional Skills is plus - XML, *******,******, Testing, Data Warehouse, DBA, SFTP, JAVA Data Model - Microsoft Visio Project Tracking - JIRA, TFS UAMS is an Affirmative Action and Equal Opportunity Employer of individuals with disabilities and protected veterans and is committed to excellence. This position is subject to a pre-employment criminal background check. A criminal conviction or arrest pending adjudication alone shall not disqualify an applicant. Any criminal history will be evaluated in relationship to job responsibilities and business necessity. The information obtained in these reports will be used in a confidential, non-discriminatory manner consistent with state and federal law. Physical Requirements Stand: Occasionally Sit: Frequently Walk: Occasionally Bend, crawl, crouch, kneel, stoop, or reach overhead: Occasionally Lift, push, pull, carry weight: 11 - 25 lbs Use hands to touch, handle, or feel: Continuously Talk: Frequently Hear: Continuously Taste or smell: Occasionally Read, concentrate, think analytically: Continuously Physical Environment: Inside Office Environment Noise Level: Quiet Visual Requirements: Color discrimination, Depth perception, Far visual acuity, Near visual acuity Hazards: None Options
Keywords: University of Arkansas for Medical Sciences, Little Rock , Applications Systems Analyst/Programmer Senior, IT / Software / Systems , Little Rock, Arkansas
Didn't find what you're looking for? Search again!