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