Business Intelligence Developer

Pantherx Specialty - Pittsburgh, PA

Full-time - Mid Level

Pittsburgh, PA

Health and Personal Care Retailers

About the position

The Business Intelligence Developer at PANTHERx Specialty LLC plays a crucial role in designing and developing data solutions that enhance business decision-making processes. This position requires expertise in SQL, data aggregation, and Power BI, and involves collaborating with stakeholders to meet their data needs while ensuring data accuracy and integrity. The developer will also manage requests from both internal and external clients, contributing to the overall mission of providing high-quality outcomes for patients with rare diseases.

Responsibilities

• Designs, develops, and maintains data solutions that support business intelligence requirements.
• Collaborates with stakeholders to understand their data needs and develop appropriate solutions.
• Performs data analysis and develops data models that support data-driven decision-making.
• Develops and maintains ETL processes to move data between systems and integrate data from various sources, particularly with SQL.
• Creates and maintains reports and dashboards using Power BI and other BI tools.
• Writes measures and calculated columns using the DAX language.
• Ensures data accuracy, integrity, and consistency by implementing appropriate data quality measures.
• 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.

Requirements

• Bachelor's degree in mathematics, IT, or related fields.
• Minimum 3 years of experience in business intelligence development, data warehousing, or related fields.
• Strong SQL skills and experience with data aggregation and data modeling.
• Experience with Power BI and other BI tools.
• Excellent communication and interpersonal skills, with the ability to work collaboratively with stakeholders across the organization.
• Strong problem-solving and analytical skills.
• Experience with data warehouse design and implementation.

Nice-to-haves

• Familiarity with specialty pharmacy or healthcare data
• Experience with Python or R Studio.
• Experience with Spark and/or Databricks.

Benefits

• Paid holidays
• Disability insurance
• Health insurance
• Dental insurance
• Flexible spending account
• Paid time off
• Employee assistance program
• Vision insurance
• 401(k) matching
• Life insurance