Junior Data Analyst

Location: Oakland, CA

Description:

Kforce has a client that is seeking a Junior Data Analyst in Oakland, CA. This is a great position for someone who’s interested in learning reporting, analytics, and healthcare. Down the line there is potential to learn and take on other things like BI reporting via Tableau/Power BI, and data science. Overview: The group is in charge of quarterly submissions to the government every 1st of the month of each quarter – January, April, July and October. The 1st of month each quarter their systems generate files they will likely send to the government (i.e., files related to if a person has Medicare, doesn’t have Medicare, etc.). Their job is to look at this list, perform various tests (ex. See if this person is really Medicare eligible or not – called the shake down process). The Junior Data Analyst will perform various tests in Excel and systems, looking at members info like Medicare effective date/end date, etc. to verify that everything is looking good. The remaining months they will be testing current systems with various defects they notice and mailing outreach to their groups to give them any status updates on their statistics (Ex. Reaching out via mail how many of their workers that have the company’s insurance are eligible for Medicare. Reports are generated in Excel, and they will have to go over line by line and group by group to analyze data (need to have keen eye for data analysis). Everything they do is mandatory, and compliance related. If there are any issues, the company could be fined. Everything is a manual process right now. Down the line, they would like to automate as much as they can so they can transition reporting to offshore teams so they can do it and this team can just validate the work. Once that happens, this will allow this person to work on other things like analytics, reporting, etc.

Requirements

• Bachelor’s degree with 1 – 2 years of experience
• Data Analyst experience
• Good communication skills (oral and written) – will be documenting processes
• Organization skills
• Intermediate/Expert level in MS Excel – Must know Pivot Tables and VLOOKUPS
• Always curious and wanting to learn
• Ability to work in ambiguity
• Fast learner
• Good cultural fit for their team – team player, works in groups, not a lone wolf, very collaborative, extraverted group mostly

Preferred Experience:

• Experience with documentation
• Beginner level in Alteryx or some exposure
• Recent Data Bootcamp graduate