Data Analyst/Programmer III

Below are the additional details for your reference:
Job Title: Technical – Data Analyst
Job Location: Remote
Job Duration: 03+ Months (Possibility of extension)
Shift: 8:00 AM PST to 5:00 PM PST

Job Description:
Will this role be fully remote? Yes.
Are there any specific locations the candidates should be in? Anywhere in United States (MUST LIVE WITHIN 15 APPROVED STATES-  AZ, FL, GA, ID, IA, KY, MI, NE, NM, NY (outside greater-NYC), OH, TX, UT, WA (outside greater-Seattle), WI.
What is the expected schedule (include dates/time) 8:00 AM PST to 5:00 PM PST
What are the day to day job duties?
Job duties -
Using azure databricks to perform analytics around Risk Adjustment Data Validation project and HEDIS.
Generate flat file from databricks to transfer files to chart copy vendors.
We are looking for some who has experience with databrick, PowerBI, and MS Azure environment.
Required Skills:
SQL, azure databricks, python, PowerBI, Report analytics.

Required Education:
BS Computer Science or Equivalent experience

Required Years of Experience: 4 – 7 years of Experience

Is there potential for this to extend past 3 months? Yes, depending on the audits conducted by CMS

Summary:
Access and integrate data from the various *** systems (QNXT, Medlnsight, (pharmacy,etc.), create actionable management reports that can be used to analyze costs and quality, analyze results and identify opportunities to manage costs and improve quality. Report observations to manager, pointing out areas of concern inaccuracy, cost trends, and efficiency.

Essential Functions: Extract and upload information including large data sets from various systems to support team needs.
This resource is utilized for ad hoc requests for pharmacy, medical expenses, and enrollment data by other members of the team.
Assist in preparation of reports produced regularly to support executive decision-making. Research and analyze report results identifying opportunities and trends.
Develop efficient reporting methods.
Support team members when additional analytics are required for medical costs.

Knowledge/Skills/Abilities:
Ability to be a self-starter, motivated, energetic worker with an interest in learning the healthcare system or other BI software.
Knowledge of healthcare and prescription drug claims data Proficiency with Microsoft Office, Including Excel, Word and PowerPoint Ability to use data cubes to extract data and reports from Medlnsight. Basic level of programming is desired. Good verbal and written communication skills Good interpersonal and problem solving skills. Ability to abide by Clients policies Maintain regular attendance based on agreed-upon schedule Maintain confidentiality and comply with Health Insurance Portability and Accountability Act (HIPAA) Ability to establish and maintain positive and effective work relationships with coworkers, clients, members, providers and customers

Required Education:
BA or BS in Biostatistics, Public Health, Statistics, Mathematics, or Health Care or related field required.

Required Experience:
5-7 years of relevant work experience.
Experience with MS Office applications required, especially strong Excel skill. Skill with SQL or SAS. Alternate programming experience may substitute.
Experience with data management and analysis preferred.
Must have strong quantitative and analytical skills. Some experience in health care industry or pharmacy claims desired.
We are looking for some who has experience with databrick, PowerBI, and MS Azure environment.