Database Architect Job at CAI, United States

  • CAI
  • United States

Job Description

Database Architect

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 is 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 application.accommodations@cai.io 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.

Job Tags

Full time, Apprenticeship, Work at office, Local area, Remote work

Similar Jobs

Green Mountain Electric Supply

Delivery Driver (non-CDL) - Londonderry, NH Job at Green Mountain Electric Supply

 ...Electric Supply, you are the face of our company and one of the most important links in the customer service chain! This position helps drive our business by creating customer loyalty through outstanding customer service and accurate, safe, and timely deliveries of customer... 

CarHop

Lot Assistant, 18.00, Monday-Friday, Full Benefits Package Job at CarHop

 ...we've made a difference by Helping People Drive and changing the lives of thousands of people. Benefits Starting pay is $18.00 per hour Company growth, now in 12states Monday Friday hours Medical/Dental/Vision insurance, Paid Holidays, PTO, 401k Savings... 

Horizon Air

Ramp & Customer Service Agent Job at Horizon Air

 ...evening (PM) shift. Effective split-shift hourly rate: $21.62 per hour (base wage + differential) Total Rewards: Alaska Airlines, Hawaiian Airlines and Horizon Air pay and benefits can vary by company, location, number of regularly scheduled hours worked, length... 

Comtech

Oracle Database Administrator with Linux Job at Comtech

 ...applications.QualificationsMinimum Requirements:Expert-level experience with Linux Operating System Administration using Intel-based servers.Hands-on experience with Administration of Oracle 11gDBMS in Oracle-base environment with high volume, heavy transactional environment.... 

Confidential

Media Coordinator Job at Confidential

 ...York, NY (1515 Broadway) Reports To: Director, Editorial Post Production Operations (EPPO) Media Operations Supports: U.S. and global...  ...Pictures, Nickelodeon, MTV, Comedy Central, BET, Paramount+, and Pluto TV, among others. Paramount delivers the largest share of the U.S....