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

Key Responsibilities

• Design new data models using GCP and BigQuery
• Work with other groups in the organization to build out the new GCP platform to enable access for both internal and external customers
• Work with GCP tools Cloud Run and Cloud Functions to build out data flow processes
• Use GitHub actions to promote objects to multiple environments
• Using Looker design and produce complex reports, dashboards, and scorecards
• Building LookML data models
• For legacy systems will work with on-prem Oracle databases and IBM Cognos BI platform
• Work closely with Developers, Business Analysts, Product Managers to develop product metrics
• 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 user and data security in a multiple customer environment
• UI/UX design
• Understanding of HIPAA requirements and data security and how they apply to our work

Minimum Requirements

• 2 years of experience with GCP tools like Cloud Run and Cloud Functions
• 2 years of experience working with Google BigQuery (preferred) or Snowflake or DataBricks
• Advanced experience with SQL (stored procedures, views, synonyms, etc)
• Experience with Python
• Working experience with Looker BI platform
• Working experience with data modeling
• Working experience with GitHub and Looker API
• 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 supportphysical, 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

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

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.