Analytics Engineer

Empower is a visionary healthcare company committed to providing quality, affordable medication to millions of patients across the nation. We hold the distinguished position of being the largest 503A compounding pharmacy and FDA-registered 503B outsourcing facility in the country serving the functional medicine markets.  

What sets us apart is our relentless focus on four core values: People, Quality, Service and Innovation. Our dedicated team of professionals collaboratively works to break new ground in the fields of manufacturing, distribution and quality control, providing a uniquely integrated approach to healthcare. Leveraging our vertical integration of the pharmaceutical supply chain, state-of-the-art technology, and a commitment to excellence, we are constantly pushing the boundaries of what is possible in medication accessibility and affordability.  

You're not just starting a job; you're joining a mission. We believe in empowering our team to innovate, grow, and drive real change in the healthcare industry. If you're a forward-thinker who thrives in a fast-paced, transformative environment, Empower is the place for you. Here, you’ll be encouraged to share your ideas, expand your skill set, and contribute to projects that genuinely make a difference. We prioritize the well-being of our team members, and we offer a supportive and engaging workplace where your contributions are not just recognized but celebrated.

Let’s revolutionize healthcare, together. Join us and be a part of something extraordinary.  

The Analytics Engineer plays a key role in shaping data-driven decision-making at Empower Pharmacy by developing and maintaining advanced business intelligence (BI) solutions. This position supports our values of service, quality, and innovation by creating powerful data visualizations, reports, and dashboards that drive business insights across various departments, including sales, clinical trials, manufacturing, and supply chain. The Analytics Engineer ensures that critical data is not only accessible but also structured in a way that enhances operational efficiency and strategic decision-making.

This role involves designing data structures and relationships, building custom calculations, and integrating multiple data sources into cohesive Power BI reports. By working closely with stakeholders, the Analytics Engineer translates complex business requirements into actionable data models, helping various teams—including pharmacy operations, finance, and Human Resources—leverage real-time insights to improve outcomes. Additionally, this role plays a significant part in optimizing BI systems and addressing data quality issues to ensure reliability and accuracy.

As a key contributor to Empower’s data strategy, the Analytics Engineer is responsible for evolving the company’s data platforms, particularly Snowflake, and providing technical expertise for troubleshooting and training. This role also supports the development of enterprise-wide dashboards and reports, enabling both high-level decision-making and detailed operational analyses.

At Empower, we are dedicated to producing innovative medications that help people live healthier, happier lives. If you have a passion for data-driven insights, collaboration, and technology innovation, we invite you to join our mission to expand access to quality, affordable medications by applying for the Analytics Engineer role today.

• Develops Power BI reports and dashboards to visualize and analyze pharmaceutical data from various sources, including sales, clinical trials, manufacturing, and supply chain.
• Establishes data structure setup, for developing BI reports, and for providing insights to improve decision-making.
• Creates relationships between data and develops tabular and other multidimensional data models in collaboration with team data engineers.
• Creates customized charts and custom calculations as required to address business stakeholder's complex analytical requirements.
• Designs business analysis and data recording systems for use in the reporting processes with special emphasis on Snowflake and PowerBI.
• Examines existing reports to locate and resolve issues. These reports consist of key performance indicators (KPIs), daily pharmacy operational dashboards, financial, and production quality analysis while addressing data quality issues emanating from end-to-end data integrations and analytics.
• Makes essential technical and strategic changes to improve present business intelligence systems.
• Works closely with business stakeholders to understand their data analysis needs and translates requirements into effective Power BI solutions.
• Develops and updates technical documentation for providing end-to-end data cataloging and data lineage while augmenting with user-friendly business definitions.
• Collaborates with teams to integrate systems across to evolve single and consistent data definitions(metrics/KPIs). This effort involves data team’s collaboration (not limited to) with pharmacy operations (Pharmacy Management Systems), Enterprise Resource Planning, Finance, and HR.
• Designs and implements data models, transformations, and calculations within Power BI to ensure accurate and reliable reporting.
• Provides technical expertise and support to end-users for troubleshooting, training, and adoption of Power BI and self-service solutions.
• Develops Enterprise dashboards and reports such as KPIs, Operational dashboards, financial metrics for both enterprise level decision making and departmental deed-dives.
• Coordinates development of Business Intelligence products with cloud data team and departments such as pharmacy operations, finance, quality, and HR to enable self-serve analytics.
• Optimizes Power BI performance and usability by implementing best practices for data visualization, navigation, and interactivity.
• Maintains data analytics platforms such as Enterprise Data Warehouse on Snowflake.
• Conducts troubleshooting on BI models.
• Performs other duties as assigned.

While performing the responsibilities of the job, the employee is required to talk and hear. The employee is often required to remain in a stationary position for a significant amount of the workday and frequently use their hands and fingers to handle or feel to access, input, and retrieve information from the computer and other office productivity devices. This is primarily a remote position. The employee is regularly required to attend video conference meetings in surroundings conducive to clear communication in a non-distracting way. The company will, from time to time, have the employee travel to meet with business stakeholders, or attend learning events and conferences. The employee is occasionally required to stand, walk, reach with arms and hands, climb or balance, and to stoop or kneel.

• Familiar with data modeling best practices.
• Strong Structured Query Language and Excel skills.
• Strong Python programming skills required.
• Strong writing and documentation skills.
• Strong analytical and problem-solving skills.
• Ability to understand the needs and expectations of multiple stakeholders.

Key Competencies

• Customer Focus: Ability to build strong customer relationships and deliver customer centric solutions.
• Optimizes Work Processes: Know the most effective and efficient processes to get things done, with a focus on continuous improvement.
• Collaborates: Builds partnerships and works collaboratively with others to meet shared objectives.
• Resourcefulness: Secures and deploys resources effectively and efficiently.
• Manages Complexity: Makes sense of complex, high quality, and sometimes contradictory information to effectively solve problems.
• Ensures Accountability: Holds self and others accountable to meet commitments and objectives.
• Situational Adaptability: Adapts approach and demeanor in real time to match shifting demands of different situations.
• Communicates Effectively: Develops and delivers multi-mode communications that convey a clear understanding of the unique needs of different audiences.

Values

• People: Our people define who we are as a company, and we believe that understanding and addressing the needs of our team, clients, and community is fundamental to fostering a culture of support and growth.
• Quality: Quality stands at the core of our mission, reflecting our commitment to excellence in every medication we produce.
• Service: We are here to serve others. Every interaction with our patients, providers, employees and other stakeholders comes from a place of service.
• Innovation: By continuously exploring new methodologies and embracing technology, we ensure that every solution we offer is at the forefront of pharmaceutical care.

• Bachelor’s degree from an accredited college or University.
• Minimum of 3 years of related experience with PowerBI or other related dashboard systems such as Looker, Tableau, Superset, or Dash.
• Experience Power BI, Data Analysis Expressions (DAX) Queries, and associated supportive tooling (DAX Studio, DBeaver, etc.) required.
• Experience with Extract, Transform, Load or data transformation tools is required. Examples are Apache Hop, Alteryx, and Data Build Tool.

We offer comprehensive benefits to support your health, well-being, and future, including medical, dental, and vision coverage, paid time off, 401(k) matching, wellness perks, IV therapy, and compounded medications. Learn more: https://careers.empowerpharmacy.com/benefits/