Note: The job is a remote job and is open to candidates in USA. WellDyne is a pharmacy services company focused on driving meaningful change in pharmacy care and helping people achieve healthier lives. The Manager of BI Analytics will lead a team while remaining hands-on, developing reporting solutions, defining KPIs, analyzing data, and translating findings into actionable insights. The role partners with business, product, operations, and technical teams to establish scalable analytics practices and mentor BI analysts.
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
Skills
- 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
- 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
- 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
- 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
- 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
- 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
Company Overview