Data Quality Analyst

Data Quality Analyst

Location: Florham Park, NJ, 07932

Full Time Position

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 analyse 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