Senior Analytics Engineer

Job Summary We're opening eyes, hearts and minds to the impact that a pharmacy team can have in changing lives. Join our group of talented, committed team members-pharmacists, pharmacy care coordinators, technologists, product strategists and more-to create and expand the delivery of personalized health support that people didn't even know could be possible. The Senior Analytics Engineer for Brightpath Technologies will help our communities thrive as a key member of the Technology Team. You will work closely with Brightpath Technologies leaders and across the organization as we work collaboratively to unlock the health of millions of Americans by turning "use as prescribed" into a guarantee, not a direction. We are a culture that is unabashedly driven by purpose — making a difference to our patients and team members while growing at an accelerated rate. In this evolved role, you will leverage AI-powered tooling, MCP-enabled integrations, and prompt-based development as core parts of your day-to-day workflow — accelerating how clean, reliable data gets transformed into actionable insights and business-ready reports. Accountabilities: Data Quality & Preparation - The engineer is accountable for taking raw data from data engineers and ensuring it is clean, well-organized, and compliant with data hygiene best practices — essentially making data trustworthy and ready for use. Data Modeling & Transformation Designing and maintaining meaningful data structures (using Kimball dimensional modeling methodology) that give end users the context they need to answer their own business questions without needing engineering support. BI & Reporting Delivery Translating business requirements into finished reports, dashboards, and visualizations — and increasingly doing so efficiently through prompt-based development workflows with AI tools. Integration & Pipeline Ownership Building and maintaining integrated views of data from multiple sources, including MCP-enabled connections between data warehouses and BI tools like Qlik or Tableau. Documentation & Data Governance Maintaining consistent definitions, schemas, and documentation across the data team so everyone speaks the same data language — a critical accountability in a regulated healthcare environment. AI Tooling Adoption Actively using and championing AI-powered tools within their own workflow, and sharing those practices with teammates to lift the team's overall productivity. Stakeholder Enablement & Training Bridging the gap between technical data systems and business users — training analysts, pharmacists, coordinators, and other stakeholders to be self-sufficient with data tools. Analytics Project Leadership Leading analytics projects end-to-end, from scoping and design through to operationalization, including building project plans and managing milestones. Role and Responsibilities: Core Analytics Engineering Take data compiled by data engineers and clean it in compliance with data hygiene best practices Organize and transform data in a meaningful way, providing additional context to make it ready for analysis Work with data engineers to streamline upstream processes so that data is cleaner earlier in the pipeline Maintain documentation related to datasets and analysis, ensuring consistent language and definitions across the data team Build and maintain complex databases in partnership with the technology team Create integrated views of data collected from multiple sources Develop and use tools, algorithms, and processes for data mining and data visualization to generate decision-ready reports Train business analysts and key stakeholders to use various data tools effectively Discover opportunities for the organization to improve systems, enterprises, and processes through the use of data analytics AI-Assisted Development & Automation Tooling Use AI-powered tools and automation platforms (e.g., Claude, ChatGPT, GitHub Copilot, or similar) as active parts of the engineering workflow — accelerating data transformation, SQL development, pipeline troubleshooting, and documentation Apply AI tooling to automate repetitive tasks such as data profiling, schema documentation, anomaly flagging, and test case generation Continuously evaluate and adopt emerging AI tools that improve the speed, quality, and consistency of analytics engineering work Share AI productivity practices with teammates to raise the overall capability of the data team MCP-Enabled BI Integrations Configure and maintain MCP (Model Context Protocol) connections between data sources and BI/visualization tools such as Qlik, Tableau, or equivalent platforms Ensure MCP-connected data contexts are well-structured, performant, and aligned with organizational data governance standards Collaborate with BI developers and data consumers to troubleshoot, optimize, and expand MCP-based integrations as reporting needs evolve Document MCP configurations and integration patterns to support team scalability and knowledge transfer Prompt-Based BI &