Database Architect

Database Architect Req number: R1509 Employment type: Full time Worksite flexibility: Remote Job Summary We are looking for a motivated Database Architect ready to take us to the next level! If you have R scripting and AWS skills, and are looking for your next career move, apply now. Job Description We are looking for a Database Architect to conduct data cleansing activities for both incoming data and data at rest in the client’s system. This position will be full-time and remote. What You’ll Do A key responsibility of this role This role also responsible in writing automation scripts to achieve the cleanup activities. Eliminate manual intervention in updating huge volume of data in the application. Assist with the automation of the school assessments in the template for the PDF ‘s using R scripting. Assist VFC Assessments Coverage Data on how to include or finding more efficient ways to post to the AWS with links. And include ways of scoring coverage rates on provider demographic data. Training the analysts on Replica or converting queries for data pulls using R or another software tools. Assist with automation SOPS to improve processes and troubleshoot ways of preventing data discrepancies. Work on helping identify more targeted areas of low coverage rates down by zip codes. This role also supports manual IIS record deduplication, i.e., the process of identifying and resolving duplicate patient demographic and/or vaccination records created when information from multiple sources doesn’t match (e.g., misspelled name or nickname, new address), or too little identifying information is submitted for the same patient and the IIS is unable to automatically match and merge the records. Physical Demands Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state, and local standards Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc. Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor Reasonable Accommodation Statement If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to or (888) 824 – 8111. Equal Employment Opportunity Policy Statement It is the policy of CAI not to discriminate against any employee or applicant due to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran. It is also the policy of CAI to take affirmative action to employ and to advance in employment, all persons regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran, and to base all employment decisions only on valid job requirements. This policy shall apply to all employment actions, including but not limited to recruitment, hiring, upgrading, promotion, transfer, demotion, layoff, recall, termination, rates of pay or other forms of compensation and selection for training, including apprenticeship, at all levels of employment. Employees and applicants of CAI will not be subject to harassment due to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran. Additionally, retaliation, including intimidation, threats, or coercion, because an employee or applicant has objected to discrimination, engaged or may engage in filing a complaint, assisted in a review, investigation, or hearing or have otherwise sought to obtain their legal rights under any Federal, State, or local EEO law is prohibited.