Senior Data Analyst - BI & SQL | Hybrid/Remote

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

Benefits offered by this job

Medical, dental, vision benefits

401K with employer matching

Paid time off

Flexible working options

Job summary

PANTHERx Rare Pharmacy in Pittsburgh, hybrid, is seeking a Data Analyst III to design and develop analytical and reporting solutions using SQL and Power BI to support decision-making.

You will collaborate with stakeholders to build data models, automate reporting, and ensure data quality. The role also includes mentoring other analysts and contributing to best practices in a fast-paced environment serving patients with rare diseases.

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.
• 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.

Skills

SQL

Power BI

Data aggregation

Data modeling

Education

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

Tools

Power BI

Job description

PANTHERx Rare Pharmacy in Pittsburgh, hybrid, is seeking a Data Analyst III to design and develop analytical and reporting solutions using SQL and Power BI to support decision-making.

You will collaborate with stakeholders to build data models, automate reporting, and ensure data quality. The role also includes mentoring other analysts and contributing to best practices in a fast-paced environment serving patients with rare diseases.