Senior Business Intelligence Developer

This is a fully remote position, open to applicants in Ohio.

📋 Description

• Manage comprehensive reporting projects across pharmacy sectors and the pharmacy management system.

• Oversee the LookML semantic layer, including explores, views, dimensions, and measures.

• Establish and document standardized business metrics, implementing necessary adjustments upstream into dbt.

• Lead the migration of dashboards by evaluating usage, metric definitions, and data warehouse ownership.

• Handle client-facing deliverables for manufacturers, ensuring the accuracy of reconciled figures and labels.

• Develop PHI reporting that incorporates masking policies, role-based access, and BAA obligations.

• Report directly to the Manager, BI & Reporting.

• Guide and support teammates to help them overcome obstacles in their work.

⛳️ Requirements

• A degree is not mandatory; equivalent practical experience is fully recognized.

• Generally, 4 to 7 years of experience in building business intelligence on an operational platform, including production dashboards relied upon by users.

• Experience with Looker and LookML; familiarity with Power BI, Tableau, or Domo, along with a willingness to learn Looker, is also acceptable.

• Proficiency in SQL, including window functions, precise joins, and validation of join-fanout.

• Skills in data modeling, particularly in identifying table grain, gaps, and dashboard specifications.

• Good judgment in data visualization.

• Capability to validate work against source data and evaluate confidence levels.

• Ability to clarify unclear requests from operations leads or account managers.

• Mentoring skills.

• Strong knowledge of healthcare data, PHI, and HIPAA regulations.

• Excellent communication and data-driven decision-making abilities.

• Preferred: experience in healthcare, pharmacy, or regulated data, including PHI, HIPAA, and BAAs.

• Preferred: familiarity with dbt and experience with pull-request-based model changes.

• Preferred: experience with Snowflake or another cloud data warehouse in production, ideally including migration experience.

• Preferred: skills in Git-based BI development, including version control, code review, environments, and promotions.

• Preferred: experience in migrating a BI platform.

• No formal leadership or management experience is required.

🏝️ Benefits

• Competitive salary package.

• Opportunities for professional development and growth.

• Flexible work environment and potential for remote work.

• Comprehensive health and wellness benefits.