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.
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 all solutions to ensure adherence to requirements and data accuracy.
Troubleshoots and resolves data-related issues.
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.

Bachelor’s degree in mathematics, IT, related fields, or equivalent experience.
Minimum 3 years of experience in business intelligence development, data warehousing, or related fields.
Strong SQL skills.
Experience with Power BI and other BI tools.
Strong analytical thinking, problem solving, and attention to detail.
Collaborative mindset with the ability to work cross-functionally.
Familiarity with specialty pharmacy or healthcare data.
Experience with Spark and/or Databricks.

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!

Data Analyst II

Key skills