Data Analyst

Overview

On Site
Depends on Experience
Full Time
Accepts corp to corp applications

Skills

Healthcare Data
Data Quality Analyst
Data Analyst
SQL
Power BI
Excel
pharmacy data
data aggregator
pilotfish

Job Details

Data Quality Analyst

Location: Florham Park, NJ, 07932-Onsite

5 days onsite at Florham Park, NJ , In-person interview

 

Job Summary:

 

Job Duties:

  • Develop and maintain complex SSIS packages integrating structured and unstructured data from various sources
  • Weekly ETL of raw data received in various formats from over 500 pharmacies containing PHI data into SQL
  • Conduct data cleansing by performing data validation and testing to ensure consistency, quality, and readiness
  • Develop and execute complex SQL queries and scripts, utilizing joins, subqueries, and aggregates to extract and analyze data to showcase pharmaceutical sales, drug pick-up statuses, and inventory for over 20 weekly reports
  • Create interactive and seamless Power BI dashboards and reports to convey complex healthcare insights, improving data accessibility for sales teams and pharmaceutical drug manufacturers for over 20 different programs
  • Create extensive reports in Power BI to uncover trends, correlations, and anomalies decreasing errors by

 

Skills: SQL Server Integration Services (SSIS) • MySQL • Microsoft Power BI • Extract, Transform, Load (ETL) • Tableau

 

Requirements:

  • We are looking for Data quality assurance person who has worked with pharmacy data and has experience with a data aggregator
  • Key skills – SQL, Power BI, Excel
  • Graduate from tech school
  • If anyone has experience using application like pilotfish, that would be helpful

The rates range are heavily dependent on skills, experience, location and industry.
CyberThink is an Equal Opportunity Employer

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.