[Close] 

Database Analyst (100% Virtual)

Our client provides a wide range of strategy development, business and advisory services, program management, and training services to government and commercial clients.
They are seeking a Database Analyst (100% virtual position).
JOB DESCRIPTION
The individual who fills this position is expected to work in a team environment and have expertise using SAS and SQL to create, modify and test code, forms, and script for Microsoft Access databases. This individual will be responsible for working with users to develop specifications and implement same, delivering quality products to Centers for Medicare & Medicaid Services (CMS) clients.
The individual must have knowledge of and experience in databases such as Medicare or other claims-based data, as well as qualitative data analysis. Experience with Medicare Part D, formulary files, PDE data and NDC codes preferred. Candidates must have above average knowledge on environments using an MS Access front end with an MS SQL Server.
ESSENTIAL FUNCTIONS:
The positions include writing specifications; extensive analysis of data and research for anomalies, exceptions and potential errors; implementation of specifications via SAS, SQL, and other languages; and testing and suggesting code improvements and optimizations. SAS programming skills are required and would preferably include data step, merges, Proc SQL, macros, and other procedures. Candidates should have good communications skills and the ability to work with a strong team to self-organize, juggle tasks, and collaborate actively on solutions.
Serve as an active team participant to provide analytic SAS programming support.
Create, manage and analyze very large and complex data files using SAS.
Design, modify, improve and debug Microsoft Access software components including VBA code, forms, and reports.
Prepares formulary files and utilization management criteria to conduct reviews
Setup and maintain databases using Microsoft Access per the given instructions and modify them to accommodate the system/user requirements.
Identify and understand the requirements of the users with respect to the system that needs to be developed.
Test the system at each stage of the development phase and identify bugs which could result in negative user experience and ensure good performance of the database system.
Maintain functionality and stability.
Document changes and updates regarding the system so that everybody is acquainted with the changes and modifications to the system.
Provide support to end users after the system has been delivered.
Make necessary modifications to the system based on user feedback and improve the overall usability of the system by providing regular system updates.
Use a ticketing system to manage ongoing work throughout all phases of development (support, troubleshooting, testing, and deployment).
Ability to write necessary technical documentation and instructions and provide system training/support to new and existing users.
Thoroughly test all changes to ensure smooth deployments.
Assist with the development, documentation, and implementation of appropriate data flow diagrams, and documents all process flows.
REQUIRED SKILLS AND EXPERIENCE
Education: B.S. in Computer Science, mathematics, statistics, or similar discipline.
Experience Level: Minimum 1 - 3 + years
Preferred: Over 4 years of related experience or equivalent combination of formal education/training and experience in programming and analysis. SAS certification.
Strong experience with MS Access and Excel
Proficient programming skills in SAS including creating, merging data.
Knowledge of relational database management systems (e.g. MySQL).
Good understanding of SQL and relational databases. SQL Server experience a plus.
Ability to work on multiple projects simultaneously.
Demonstrated accuracy and attention to detail.
String skill in documentation and process descriptions
Excellent problem-solving and analytical skills; advanced mathematical abilities.
Excellent oral and written communication, presentation and interpersonal skills.
Preferred experience in Medicare Part D, pharmaceutical data or related healthcare industry
Uses subject matter and technical expertise to identify and define data elements and integrates them into research design.
Leads the development and formulates best practices and protocols on data collection, data quality, warehousing, analysis, and reporting including developing special forms and/or formats for analyzing and presenting data.
The individual must have knowledge of and experience in databases such as Medicare or other claims-based data, as well as qualitative data analysis.
Experience with Medicare Part D, formulary files, Prescription Drug Event (PDE) data and National Drug Code (NDC) codes preferred.
Candidates must have above average knowledge on environments using an MS Access front end with an MS SQL Server.
EOE M/F/Disability/Vet
Our Client will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information.
Are you a returning applicant?Previous Applicants:Email:Password:
If you do not remember your password click here.

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.