Data Analyst

Asembia, LLC.; Livingston (NJ); On-site; USD 70,000 - 100,000; Full time

Job summary

Asembia, LLC. in Livingston, NJ seeks a Data Analyst to support data outreach, loading, and reporting per program requirements. The role emphasizes data quality, timely delivery, and cross-functional collaboration with pharmacies and internal teams.

You will perform SQL-based data analysis, develop ad hoc reports, and ensure data accuracy across master data functions. A strong pharmacy data background and experience with Tableau/Power BI are required.

Qualifications

• Bachelor's degree in Information Systems, Finance or Healthcare Administration or similar field preferred.
• 1-4+ years of experience in pharmacy operations, claims data analysis, or SQL/data visualization (Tableau, Power BI).
• Minimum 2 years of experience working with pharmaceutical data in a team-driven environment.
• Understanding of 340B program requirements, Medicare Part D regulations, and drug formulary management.
• Advanced Excel skills (Macros, pivots, formulas), SQL, and data visualization tools (Tableau, Power BI, PowerPoint).
• Proven track record with data investigations using SQL or other statistical analysis.
• Must have client-facing experience and clear verbal and written communication.
• Strong analytical, problem-solving, and communication skills; reliable attendance.

Responsibilities

• Reach out to member pharmacies to gather missing data, clarify inconsistencies, and offer technical assistance.
• Identify, investigate, and resolve data anomalies using SQL or other statistical analysis software.
• Ensure data reports meet program requirements and are delivered in a timely manner by updating data for accuracy.
• Process daily/monthly/quarterly master data functions as assigned.
• Provide ad hoc data analysis to internal and external parties as requested.
• Append pharmacy data reports to the Asembia database using data rules to ensure input quality.
• Communicate findings to internal and external stakeholders and manage expectations.

Skills

Analytical skills

Communication

Client-facing

Problem solving

Tableau

Education

Bachelor's degree

Tools

SQL

Tableau

Power BI

Excel

PowerPoint

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Data Analyst

Professional

Position: Data Analyst

Department: IT

Reports to: Senior Director, Data Informatics & Analytics

FLSA: Exempt

The Corporate office operating hours are Monday through Friday 8:30 am - 5:00 pm EST.

Primary Function:

The incumbent is responsible for the data outreach, data capture/loading, and data reporting per specific program requirements.

Job Scope and Major Responsibilities:

• Reach out to member pharmacies to gather missing data, clarify data inconsistencies, and offer technical assistance/expertise if necessary
• Identify, investigate, and resolve data anomalies using SQL or other statistical analysis software
• Ensure that Asembia's data reports meet program requirements and are delivered in a timely manner by making necessary changes to improve data accuracy
• Process daily/monthly/quarterly master data functions as assigned
• Provide ad hoc data analysis to internal and external parties as requested
• Append pharmacy data reports to the Asembia database using applicable data rules to ensure quality of input through various stages of the data-loading process.
• Communicate findings of data investigations and manage expectations for internal and external stakeholders
• The timely submission of accurate data to appropriate parties.
• Maintaining a high level of customer service for Asembia's customers - manufacturers and members' pharmacies.
• Successful collaboration with other Asembia team members to attain a common goal.
• Effectively perform in a high-volume call center hub requiring a blend of soft skills (patience, empathy/compassion, active listening, problem solving) and technical/process skills (mastery of tools, knowledge base, adherence to SOPs, efficient multitasking, problem-solving) to handle numerous calls quickly and accurately, use available resources like knowledge bases, and maintain quality through focused communication and efficient workflow, ensuring quick resolutions while balancing speed with customer satisfaction.
• Attendance and schedule adherence is critical.
• Adhering to company policies and procedures.
• Possess a professional demeanor, focused on respectful communication, a positive and reliable attitude, and responsible behavior. This includes dressing appropriately, being punctual, maintaining composure, and demonstrating accountability for your actions.
• Working outside of core business hours may be required.
• Other duties as assigned.
• Some travel may be required.
• Compliance with the provisions of the Health Insurance Portability and Accountability Act of 1996 and its implementing regulations, as amended (HIPAA).

Required Minimum Qualifications:

• Bachelor's degree in Information Systems, Finance or Healthcare Administration or similar field preferred.
• 1-4+ years of experience in pharmacy operations, claims data analysis, or SQL/data visualization (Tableau, Power BI)
• Minimum 2 years of experience working with pharmaceutical data in a team-driven environment
• Understanding of 340B program requirements, Medicare Part D regulations, and drug formulary management.
• Advanced Excel skills (building Macros, pivot tables & pivot charts, writing formulas, etc.), SQL, and data visualization tools (Tableau, Power BI, Powerpoint).
• Proven track record with taking ownership of data investigations and seeing them through to resolution, preferably using SQL or other statistical analysis.
• Must have client-facing experience and be able to articulate themselves clearly and concisely in their verbal and written communications.
• Strong analytical, problem-solving, and communication skills to present findings to management.
• Possess and maintain professional demeanor and courteous attitude.
• Reliable and consistent attendance and schedule adherence is required.

Asembia is committed to Equal Employment Opportunity (EEO) and to compliance with all Federal, State and local laws that prohibit employment discrimination on the basis of race, color, age, natural origin, ethnicity, religion, gender, pregnancy, marital status, sexual orientation, gender identity and expression, citizenship, genetic disposition, disability or veteran's status or any other classification protected by State/Federal laws