Business Intelligence Developer

The Business Intelligence Developer will work on a team interacting with all aspects of the business to support the BI platform, design models for new products, analyze data, and build reports and dashboards. The ideal candidate should be a results-oriented person with excellent communication and troubleshooting skills. The BI Developer will work focus mainly on the Looker/BigQuery platform as we migrate from on-prem to GCP Cloud.
Key Responsibilities

• Design and produce complex reports, dashboards, and scorecards using Looker for internal and external customers
• Assist in designing of new data models using Google BigQuery
• Recommend and lead database changes working with DBAs and Developers
• Use GitHub actions to promote objects to multiple Looker environments
• Work closely with Developers, Business Analysts, Product Managers to develop product metrics
• Complete complex data analysis and ad-hoc requests
• Must be able to troubleshoot and resolve data issues with large data sets in a complex data structure.
• Maintain Looker Cloud environments (Dev, UAT, and Production)
• Manage system security to ensure new product reports and customers are configured properly
• UI/UX design
• Understanding of HIPAA requirements and data security and how they apply to our work

Minimum Requirements

• 2+ years of experience working with Looker
• 2+ years of experience working with Google BigQuery (preferred) or Snowflake or DataBricks
• Advanced experience with SQL (stored procedures, views, synonyms, etc)
• Working experience with data modeling
• Working experience with GCP ETL/ELT tools like Cloud Run or Cloud Functions
• Working experience with GitHub and Looker API
• Experience with Python
• UI/UX design training

Critical Skills

• Advanced data troubleshooting skills
• Excellent written, verbal, and interpersonal communication skills
• Comfortable working interactively with Developers, Product Managers, Account Managers, Customer Support, and external customers
• Great attention to detail

Additional Knowledge & Skills

• Experience with Cognos Analytics (version 11.x)
• Experience with Tableau
• Experience with Oracle 12c/19c
• Experience with Unix/Linux
• Familiar with Jira and Confluence
• Familiar with pharmacy real-time transaction standards
• Familiar with pharmaceutical manufacturer data and marketing methods

Education
4-year degree
At CoverMyMeds, we care about the well-being of the patients and communities we serve, and that starts with caring for our people. That's why we have a Total Rewards package that includes comprehensive benefits to support physical, mental, and financial well-being. Our Total Rewards offerings serve the different needs of our diverse employee population and ensure they are the healthiest versions of themselves. For more information regarding benefits at CoverMyMeds, please click here.
As part of Total Rewards, we are proud to offer a competitive compensation package at CoverMyMeds. This is determined by several factors, including performance, experience and skills, equity, regular job market evaluations, and geographical markets. In addition to base pay, other compensation, such as an annual bonus or long-term incentive opportunities may be offered.
Our Base Pay Range for this position
$80,300 - $133,900
CoverMyMeds is an equal opportunity and affirmative action employer. We embrace diversity and are committed to creating an inclusive environment for all employees. Qualified applicants will be considered for employment without regard to race, religion, gender, gender identity, sexual orientation, national origin, age, disability or veteran status.