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