Responsible for the development, implementation, maintenance and support of databases and registries managed by Research Analytics. Responsible to gather requirements, design, model, develop, test, document, train and support data warehouse and business intelligence programs. Also responsible for production support and maintenance of the Research Analytics databases, and works with the team on system performance optimization and interoperability issues.
Analyzes either business application information needs or clinical activities and formulates practical requirements for improvements whether automated or manual. This may include software recommendation, process improvements, system design enhancements, training and support.
Proactively evaluates the effectiveness of programs and systems to effectively propose new development options. Evaluations are based on a thorough understanding of newly developed applications or enhancements to address the changing needs of the users.
Translates user requirements into conceptual design specifications and reviews with the user to insure accuracy. Performs comprehensive testing and debugging to ensure error-free production software. Functions within department and technical standards for programming, systems design and analysis.
Writes new computer programs to conform to analyst and user specifications and revises existing computer programs to conform to new requirements and computer configurations and meets timeframes.
Codes extracts and summarization routines. Prepares warehouse processes for production and trains operational staff.
Designs and implements automated warehouse processes. Designs report and batch processing programs.
Analyzes technical problems relating to applications, hardware, software, and operating system failures and takes corrective action to minimize current and future impact on the user community.
Builds new applications interfacing with other systems and/or users incorporating industry trend development strategies and technologies having user-friendly designs using Oracle application and warehouse tools and/or Microsoft Office client server application development tools.
Assists with the support of various 3rd party vendor applications ranging from vendor liaison, system administration, data interfaces, and supplemental application development.
Continuously maintains a knowledge base of design techniques, software, and hardware and language capabilities through formal education, reading, networking and daily activities.
Bachelor's degree in Computer Science or other related field.
Requires 3 years of experience in data warehouses in data management and integration, design and development, application management, report writing, requirements gathering, testing, and data manipulation.
Knowledge, Skills and Abilities Required:
Technical experience with data reporting and/or data warehousing.
Knowledge and experience with various operating systems and databases such as Unix/AIX, Linux, Microsoft SQL Server, Oracle, Microsoft Access.
Knowledge and experience with programming languages: SQL, PL/SQL (Procedural Language/Structured Query Language), Oracle Developer Suite, Microsoft Office Suite, Microsoft Application Basic Client query and report writing tools: Oracle Discoverer, Oracle Reports, MSACCESS.
Knowledge and experience with warehouse entry and presentation tools: Oracle Forms, Oracle Portal, and various data warehouse/data marts.
Knowledge and experience with Microsoft Office Development Suites.
Ability to work independently or as part of a group and balance multiple priorities while consistently completing complex tasks in a rigorous goal-oriented manner.
Demonstrated strong analytical and logical thinking, creativity, self-reliance, communication skills and ability to effectively
integrate varied components of a system.
Team player with a positive attitude, strong commitment to customer service and a desire to learn healthcare related systems and business processes.
This position is open due to a military leave:
Discover the Benefits:
Imagine a work environment where you are valued for finding better ways of caring for our patients and are offered flexibility, mobility and growth through a wide range of career options. With Aurora you'll find a diverse and comprehensive blend of benefits designed to make your life better both inside and outside of the workplace.
Aurora Health Care is a not-for-profit Wisconsin health care provider and a nationally recognized leader in efforts to improve the quality...