Data Warehouse Administrator Associate

Closing Date:

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 (available for benefits eligible positions only):

• Health: Medical, Dental and Vision plans available for qualifying 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

Below you will find the details for the position including any supplementary documentation and questions you should review before applying for the opening. To apply for the position, please click the Apply link/button.

Persons must have proof of legal authority to work in the United States on the first day of employment.

All application information is subject to public disclosure under the Arkansas Freedom of Information Act.

For general application assistance or if you have questions about a job posting, please contact Human Resources at askrecruitment@uams.edu.

Department's Website:

Minimum Qualifications:

• Bachelor's degree in Computer Science, Management Information Systems or related field.
• HS plus 4 years of customer support experience and/or account management.
• Proficient computer skills in programs including Microsoft Word, Excel and Visio.
• Must have relational database experience in at least one of the following: Microsoft Access, MySQL, Microsoft SQL Server, Oracle, Sybase, or Informix.

Preferred Qualifications:

• Master's degree in Business Administration, Computer Science, Management Information Systems or related field.
• 6+ years of customer service support experience and/or account management including data analytics and reporting.
• Broad understanding of the trends in health care and health data analytics, use and disclosure.

Additional Information:

Responsibilities:

• Coordinate and manage execution plans for each APCD database build, including the selection of input data, managing data corrections and new build processes, and managing the audit and validation of each build step utilization existing audit queries and developing new queries as needed.
• Communicate with data submitters on a daily basis through voice and written communication to address data submitter questions and ensure accurate data submissions and data file quality.
• Provide advanced data science and analytics to support data submission and data fulfillment issue resolution.
• Design and manage automation of data validation processes for solution builds, ensuring automated processes are current and functional.
• Write programming queries for data quality validation processes to support file delivery and auditing processes.
• Manage all process set-up and onboarding steps required for new data submitters including establishing secure file transmission routes, data encryption, required layout mapping consultation, testing.
• Monitor multiple daily file submissions through receipt, validation and load to ensure accuracy and viability.
• Provide technical support for data submitters, ensuring timely and accurate review of data sources.
• Manage data request fulfillment processes after data request approval, including developing and validating functional requirements with the data requestor, overseeing the creation of datasets, auditing data, and packaging and delivering data through secure channels.
• Utilize advanced SQL queries and custom web-based tools to fulfill data requests.
• Organize solution and/or data request requirements into meaningful and executable functional requirements, user manuals, and instructions.
• Translate complex and detailed requirements into simplified descriptions for research, policy, and data team project stakeholders.
• Design test cases for new and existing requirements and processes.
• Design and execute auditing for new and existing requirements and processes.
• Support the dissemination of requirement changes and communication with research, policy, and data team project stakeholders.
• Work with technical writer to ensure project documentation is relevant and accurate.

• Perform intermediate data processing and analysis to identify issues, test new and existing processes, and build data quality reports summarizing information and trends.
• Other duties as assigned

Functions include but are not limited to:

• Managing up to 60 external partners/data submitters (internal and external) about data submission and data fulfillment status and/or issues in a timely manner to ensure compliance with the requirements of Act 1233 of 2015.
• Managing the receipt of submitted data files from multiple data submitters, including but not limited to monitoring ftp file delivery, verifying encryption, managing data loads and validation, analyzing and assessing data quality issues and working with data submitters to solve problems.

• Identifying/understanding data relationships across data submitters to support data quality and provide consultative data-knowledge support to internal and external users.
• Managing the development and extraction of data to fulfill data requests, ensuring timely and accurate file delivery.

Salary Information:

Required Documents to Apply:

Please contact askrecruitment@uams.edufor any recruiting relatedquestions.

All application materials must be uploaded to the University of Arkansas System Career Sitehttps://uasys.wd5.myworkdayjobs.com/UASYS

Please do not send to listed recruitment contact.

This position is subject to pre-employment screening (criminal background, drug testing, and/or education verification). A criminal conviction or arrest pending adjudication alone shall not disqualify an applicant except as provided by law. 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.