Business Intelligence Engineer II

JOB SUMMARY (Added June 2024)

The BI Engineer II will support the business by building comprehensive reports and dashboards to showcase pharmacy data in innovative ways. In this role, there will be a focus on building an external BI portal for pharmacies to help them better understand their business.  This role requires a keen sense of detail, a love for data and a desire to problem solve on a daily basis. A strong understanding of data and a business mindset allow the BI Developer to act as a key middleman, connecting the company’s data assets to real value. It is expected that the Engineer II will be an expert on at least one pillar’s data sets and approach in order to support the business. Additionally, the Engineer II will work closely with engineers on building appropriate pipelines to support reporting.

ESSENTIAL DUTIES & RESPONSIBILITIES

• Build and maintain Looker dashboards and scorecards focused on pharmacy activity, trends and opportunities
• Work collaboratively with cross-functional partners to proactively communicate, and clearly articulate, outcomes, insights, and recommendations
• Develop innovative approaches to manipulate data sets in a way that enables pharmacy clients to see patterns and trends
• Act as expert for datasets within the pharmacy, payer and/or pharma space for internal and external teams
• Support, troubleshoot and resolve BI issues from end users
• Work closely with Data Engineers to understand data architecture and build pipelines in order to move data into the enterprise data warehouse

KNOWLEDGE & REQUIREMENTS

• Ability to build Visualizations in Looker and/or Tableau, including knowledge of LookML best practices for coding
• Understands business requirements and how to use data to create stories related to those requirements
• Brainstorms Looker or Tableau solutions to recommend appropriate analytics or KPIs
• Ability to implement persistent derived tables and data security/permissions for users
• Analyze data via SQL queries to assess structure, granularity, quality and fit for analytics
• Drives projects and provides leadership to the data team
• Partake in internal and external calls when necessary, to explain data models and trends
• Travel Requirements: Domestic and/or International, up to 10%

EDUCATION & EXPERIENCE REQUIREMENTS

• Minimum years of work experience:   3 years
• Minimum level of education or education/experience:   Bachelors Degree 
• Experience with API’s and system integration methodology
• Experience working with Cloud databases
• Strong knowledge of SQL
• 3+ years experience with Looker, Tableau or equivalent BI tool
• Experience working with healthcare professionals in a clinical setting

PHYSICAL REQUIREMENTS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.

• Frequent sitting in stationary position at a desk
• Occasional standing, walking, stooping, kneeling, squatting, and climbing stairs
• Occasional twisting of body
• Occasional reaching by extending hands and arms in any direction
• Occasional lifting, pulling, or pushing

What’s In It For You?

• Medical, Dental and Vision Plans
• Voluntary Benefits
• HSA & FSA
• Fertility & Family Planning Benefits
• Paid Parental Leave
• Adoption Assistance Program
• Employee Resource Groups
• Flex