Data Analyst III

PANTHERx Rare Pharmacy; Pittsburgh (Allegheny County); Hybrid; USD 80,000 - 110,000; Full time

Benefits offered by this job

Medical, dental, vision benefits

401K with employer matching

Generous paid time off

Job summary

PANTHERx Rare Pharmacy is seeking a Data Analyst III to design and develop analytical and reporting solutions that support business decision-making. You will be a subject matter expert in SQL, data aggregation, Power BI, and managing data requests for internal and external clients.

The role requires five years in BI development or related fields, strong SQL and DAX skills, and experience with data modeling. Located in Pittsburgh with hybrid work options and a comprehensive benefits package.

Qualifications

• Bachelor’s degree in mathematics, IT, related fields, or equivalent experience.
• Minimum five (5) years of experience in business intelligence development, data warehousing, or related fields.
• Experience with Power BI and other BI tools.
• Strong SQL skills and experience with data aggregation and data modeling.

Responsibilities

• Designs, develops, and maintains analytical and reporting solutions that support business intelligence requirements.
• Collaborates with stakeholders to understand their data needs and develop the appropriate solutions.
• Performs data analysis and develops data models that support data-driven decision-making.
• Implements the solutions via reports, data extracts, and analyses using SQL, PowerBI, and other data reporting and analytical tools.
• Applies diagnostic storytelling techniques to illustrate clear, actionable insights via complex data patterns.
• Writes measures and calculated columns using the DAX language.
• Automates report delivery via PowerBI and proprietary delivery tools.
• Ensures data accuracy, integrity, and consistency by implementing appropriate data quality measures.
• Tests and validates the solutions to ensure adherence to requirements and data accuracy.
• Troubleshoots and resolves data-related issues.
• Collaborates with other team members to develop best practices and ensure consistent standards are maintained.
• Manages requests for data from internal and external clients, ensuring timely delivery of high-quality results.
• Understands the business, goals, and data capabilities to deliver the solutions that go beyond what the requirements to provide increased value.
• Documents requests, requirements, and the solutions using the appropriate tools as defined by the team manager.
• Assists with training and mentoring other Data Analysts.

Skills

SQL

Power BI

Data modeling

DAX

Analytical thinking

Education

Bachelor’s degree in mathematics, IT, related fields, or equivalent experience

Tools

Power BI

Job description

7,000 Diseases - 500 Treatments - 1 Rare Pharmacy

PANTHERx is the nation’s largest rare disease pharmacy, and we put the patient experience at the top of everything that we do. If you are looking for a career in the healthcare field that embraces authentic dedication to patient care, you don’t need to look beyond PANTHERx. In every line of service, in every position and area of expertise, PANTHERx associates are driven to provide the highest quality outcomes for our patients. We Are Seeking Team Members Who Are inspired and compassionate problem solvers; Produce high quality work; Thrive in the excitement of the ever-challenging environment of modern medicine; and Are committed to achieving superior health outcomes for people living with rare and devastating diseases. At PANTHERx, we know our employees are the driving force in what we do. We cultivate talent and encourage growth within PANTHERx so that our associates can continue to explore their interests and expand their careers. Guided by our mission to provide uncompromising quality every day, we continue our strategic growth to further reach those affected by rare diseases.

Join the PANTHERx team, and define your own RxARE future in healthcare!

Location: Pittsburgh, PA (Hybrid)

Classification: Exempt

Status: Full-Time

Reports to: Manager, Reporting and Analytics

Purpose

The Data Analyst III designs and develops analytical and reporting solutions that support business decision-making processes. This role is a subject matter expert in SQL, data aggregation, Power BI (or similar Business Intelligence tool), and managing requests for both internal and external clients.

Responsibilities

• Designs, develops, and maintains analytical and reporting solutions that support business intelligence requirements.
• Collaborates with stakeholders to understand their data needs and develop the appropriate solutions.
• Performs data analysis and develops data models that support data-driven decision-making.
• Implements the solutions via reports, data extracts, and analyses using SQL, PowerBI, and other data reporting and analytical tools.
• Apply diagnostic storytelling techniques to illustrate clear, actionable insights via complex data patterns.
• Writes measures and calculated columns using the DAX language.
• Automates report delivery via PowerBI and proprietary delivery tools.
• Ensures data accuracy, integrity, and consistency by implementing appropriate data quality measures.
• Tests and validates the solutions to ensure adherence to requirements and data accuracy.
• Troubleshoots and resolves data-related issues.
• Collaborates with other team members to develop best practices and ensure consistent standards are maintained.
• Manages requests for data from internal and external clients, ensuring timely delivery of high-quality results.
• Understands the business, goals, and data capabilities to deliver the solutions that go beyond what the requirements to provide increased value.
• Documents requests, requirements, and the solutions using the appropriate tools as defined by the team manager.
• Assists with training and mentoring other Data Analysts.

Required Qualifications

• Bachelor’s degree in mathematics, IT, related fields, or equivalent experience.
• Minimum five (5) years of experience in business intelligence development, data warehousing, or related fields.
• Experience with Power BI and other BI tools.
• Strong SQL skills and experience with data aggregation and data modeling.

Work Environment

This job operates in a professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines.

Physical Demands

While performing the duties of this job, the employee is regularly required to talk or hear. The employee frequently is required to stand; walk; use hands and fingers, handle or feel; and reach with hands and arms.

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential function of the job.

Benefits

Hybrid, remote and flexible on-site work schedules are available, based on the position. PANTHERx Rare Pharmacy also affords an excellent benefit package, including but not limited to medical, dental, vision, health savings and flexible spending accounts, 401K with employer matching, employer-paid life insurance and short/long term disability coverage, and an Employee Assistance Program! Generous paid time off is also available to all full-time employees, as well as limited paid time off for part-time employees. Of course we offer paid holidays too!

Equal Opportunity

PANTHERx Rare Pharmacy is an equal opportunity employer, and does not discriminate in recruiting, hiring, promotions or any term or condition of employment based on race, age, religion, gender, ethnicity, sexual orientation, gender identity, disability, protected veteran's status, or any other characteristic protected by federal, state or local laws.