Business Intelligence Engineer I

JOB SUMMARY 

The BI Engineer 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.

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  
• Support, troubleshoot and resolve BI issues from end users 
• Work closely with Data Engineers to understand data architecture and pipelines 

KNOWLEDGE & REQUIREMENTS 

• Ability to build Visualizations in Looker, 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 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 

EDUCATION & EXPERIENCE REQUIREMENTS

• Minimum 2 years of work experience
• Minimum level of education of Bachelor's Degree 
• Experience with API’s and system integration methodology 
• Experience working with Cloud databases 
• Strong knowledge of SQL 
• 2+ years experience with Looker or equivalent BI tool 
• Experience working with healthcare professionals in a clinical setting 
• Travel Requirements: Domestic and/or International, up to 10% 

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 PTO for Exempt Associates & up to 15 PTO days in first year of employment for non-exempt associates
• 11 Paid Holidays
• Corporate Wellness Program
• 401k Employer Match & Roth Option Available – immediate eligibility

#LI-FC1