We are currently seeking a Data Analyst for our Glendale, CA office. You will be an essential player in Reveleer's Data Management function who will support and coordinate the full lifecycle of data operations: data intake and extract operations, ad hoc reporting, and analysis for client data ingest processing. This team member will also act as a primary contact for data management research and data systems analysis for both internal and external customers.  The role will report to the Director of Data Management and will also include substantial interaction with Reveleer's Product and Engineering teams as well as Reveleer's technical client contacts.

WHAT YOU'LL DO:

• Take receipt of client proprietary healthcare member, provider, and clinical data and stage the data for up front data validations and review
• Create and implement procedures to validate, process, and refine Client project data sets
• Execute data conversion processes to enable data translations and integrations from third-party platforms into Reveleer specifications for loading
• Execute the data loading operations that will apply client data to the Reveleer production environment
• Act as a primary support contact for data loading questions and data validation operations
• Perform ad hoc analyses against data load validation databases as well as production databases
• Support client data extracts operations for all products and act as the primary contact for issue investigation providing baseline details for the development team in the event break/fix work is needed
• Interact directly with internal clients and with external technical contacts to work through and document requirements related to important deliveries.
• Support Clients' efforts to self-service their data efforts and needs

ABOUT YOU:

• Up to two years of experience working with SQL Server 2014 and higher including the use of the SQL Server Management Studio, SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS). 

• Must be able to utilize tools to import raw text and XML data receipts from clients into table structures to be used for building client load files for our main clinical coding platform.  Amongst these tools must be SSIS, SQL Server Import Export Wizard, bcp, or Powershell.

• Ability to write executable SQL using multiple table joins for the purposes of performing data analysis, researching issues, and delivering ad hoc reports.

• Experience supporting and executing processes developed on SQL Server including but not limited to researching tables and views, executing stored procedures, and utilizing user-defined functions within client specific data validation databases.

• Experience of at least one year in the healthcare industry is strongly preferred with background specific to quality measures (HEDIS), risk adjustment, and medical record review or audit.  Experience with healthcare claims or any type of insurance claim data (e.g. auto, property) will also be considered.

• All candidates will be required to exhibit basic SQL programming skills and demonstrate usage of a few Microsoft T-SQL specific language functions in a timed short written exam

• BS or BA in Computer Science, Engineering, Information Systems, or the Sciences is preferred.

WHAT YOU'LL RECEIVE:

• Competitive salary
• Medical, Dental and Vision benefits
• 401k
• Generous PTO plan
• Full stocked kitchen with drinks and snacks
• Dog friendly office
• No commute to the Westside!

Reveleer is an equal opportunity employer. We do not discriminate on the basis of race, religion, color, national origin, gender, gender identity, sexual orientation, age, marital status, veteran status, disability status or genetic information, in compliance with applicable federal, state and local law.