Business Intelligence Engineer II

Description

JOB SUMMARY

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

Qualifications

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