BI Analytics Lead

WellDyne; United States; Remote; USD 120,000 - 160,000; Full time

Job summary

WellDyne is seeking a passionate Lead of BI Analytics to guide HealthDyne Business decisions through scalable data insights. This role combines building reporting solutions with mentoring BI analysts and delivering executive-ready dashboards.

You will partner with cross-functional teams to define KPIs, ensure data fidelity, and establish repeatable analytics processes while communicating complex findings to non-technical audiences.

Qualifications

• 5+ years of BI/data analytics experience with relational DBs and cloud data warehouses.
• Experience with Power BI/Tableau/QuickSight to build dashboards.
• Experience with data modeling, ETL/ELT, and data quality.
• Proficient in Python for automation.
• 2+ years of people leadership or player-coach role.
• Experience partnering with cross-functional stakeholders to define KPIs and communicate insights to technical and non-technical audiences.

Responsibilities

• Develop, coach, and mentor BI team members and align analytics capabilities with business goals.
• Serve as player-coach balancing hands-on analytics with leadership and delivery oversight.
• Establish standards for reporting accuracy, data governance, and repeatable analytics processes.
• Partner with teams to manage workload, priorities, and timely delivery of reporting commitments.
• Design and support a platform providing ad hoc access to large datasets.
• Manipulate data from databases (Redshift, MySQL, Oracle, SQL Server) using SQL and ETL.
• Write scripts (Python/UNIX) to mine log files and spreadsheets.
• Develop analytical tools, dashboards, metrics, and UIs for stakeholders.
• Conduct deep-dives and root-cause analyses to answer business questions.
• Define source of truth and ensure data fidelity across analytics.
• Communicate findings and methodologies to senior leadership.
• Collaborate with engineering to capture and store data appropriately.
• Handle ad hoc data retrieval and analysis.
• Monitor metrics, propose new ones, and identify actionable signals.

Skills

Strong SQL

Leadership

Cross-functional collaboration

Communication

Mentoring

Tools

Power BI

Tableau

SQL Server

Redshift

Python

ETL tooling

Job description

At our company, we move fast, adapt quickly, and turn challenges into opportunities—all while keeping quality at the heart of everything we do. We believe that work should be a positive and respectful place, and that with the right mindset, anything is achievable.

Our Vision:

Fulfill the essential promise of pharmacy care and help people to live to their healthiest, happiest, and fullest potential.

Our Mission:

To be the disruptive force that drives meaningful change within pharmacy services.

This position is not eligible for employment visa sponsorship. Applicants requiring sponsorship now or in the future, including those on STEM OPT, are not eligible for consideration.

Summary

We are actively looking for a passionate Lead of BI Analytics to join our team and help inform the direction of HealthDyne Business through data, at scale. This role serves as both a hands-on analytics leader and a player-coach, responsible for developing reporting solutions, identifying KPIs that drive the business, performing analysis to support strategic and tactical initiatives, and translating findings into clear insights for less-technical audiences. The Lead will also coach, mentor, and develop BI analysts by providing guidance on analytical approach, technical execution, stakeholder communication, prioritization, and quality standards. Successful candidates will be comfortable creating and optimizing table structures, generating reports consumed across the Business organization, partnering with cross-functional stakeholders, and helping establish scalable best practices for analytics delivery. Strong SQL experience is required; scripting skills and a background in operations are highly valuable. This is a highly visible role that partners with business, product management, operations, and technical teams.

Essential Duties and Responsibilities

• Develop, coach, mentor, and cross-train BI team members to strengthen analytical capabilities, technical skills, and business acumen.
• Serve as a player-coach by balancing hands-on analytics work with team leadership, prioritization, and delivery oversight.
• Establish and reinforce standards for reporting accuracy, documentation, data governance, quality control, and repeatable analytics processes.
• Partner with team members to assess workload, remove obstacles, assign priorities, and ensure timely delivery of reporting and analytics commitments.
• Design, implement, and support a platform providing ad hoc access to large datasets.
• Manipulate/mine data from database tables (ex. Redshift, MySQL, Oracle, SQL Server) using SQL and ETL.
• Manipulate/mine data from log files, spreadsheets by writing scripts (ex. PERL, Python, UNIX).
• Develop analytical tools: deep-dive tools, UIs, metrics, and dashboard.
• Perform deep-dives and root cause analysis to answer business questions.
• Work with cross-functional stakeholders in defining the source of truth and obsessively making sure the data fidelity is high.
• Effectively communicate (written and verbal) solutions and methodologies to senior leadership.
• Work with engineering teams to enable the appropriate capture and storage of data.
• Complete ad hoc data retrieval and analysis.
• Monitor existing metrics, develop and propose new metrics, and identify new, actionable risk signals.

Education and Experience

• 5+ years of progressive experience in business intelligence, data analytics, data engineering, reporting, or related roles, including hands-on experience analyzing and interpreting data from relational databases, cloud data warehouses, or large-scale datasets such as Redshift, Oracle, SQL Server, MySQL, Snowflake, or similar platforms.
• Demonstrated experience building, maintaining, and governing business intelligence solutions using Power BI, Tableau, QuickSight, or similar visualization tools, with the ability to translate business requirements into scalable dashboards, reports, and executive-ready insights.
• Experience with data modeling, data warehousing, ETL/ELT pipelines, metric definition, and source-of-truth design, including partnering with technical teams to improve data quality, structure, accessibility, and reliability.
• Working knowledge of statistical analysis, forecasting, root cause analysis, and advanced analytics methods; experience with tools such as Python, R, SAS, or similar platforms is preferred.
• Advanced SQL skills required, with practical scripting experience in Python, R, or similar languages to automate workflows, transform datasets, support modeling, and improve repeatable analytics processes.
• 2+ years of people leadership, team lead, or player-coach experience preferred, including developing analysts, coaching technical and analytical work, managing priorities, and supporting cross-training across BI functions.
• Experience partnering with operations, product, finance, technology, or other cross-functional stakeholders to define KPIs, clarify business problems, prioritize analytics requests, and communicate insights to both technical and non-technical audiences.

Knowledge, Skills and Abilities

• Experience with AWS solutions such as EC2, DynamoDB, S3, and Redshift.
• Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets

Work Environment / Physical Demands

This position is in a typical office environment which requires prolonged sitting in front of a computer. Requires hand-eye coordination and manual dexterity sufficient to operate standard office equipment including operation of standard computer and phone equipment. May have occasional high stress when dealing with customers/clients. Some travel may be required.

EOE M/F/D/V – WellDyne and HealthDyne are equal opportunity employer and prohibits discrimination of any kind. All employment decisions are based on business needs, job requirements, and individual qualifications, without regard to race, color, religion, gender, sexual orientation, gender identity, national origin, veteran or disability status, or any other protected status under federal, state, or local law.