Business Intelligence Engineer - Empower Pharmacy

Position Summary:

At the heart of Empower's technological advancement, the Business Intelligence Engineer emerges as a key innovator, turning the tide of data into a powerful force for strategic empowerment and operational excellence. In this dynamic role, you will be the architect of intelligence systems, crafting cutting-edge BI solutions that illuminate the path to insightful decision-making and sustainable growth. Working at the confluence of data science and business strategy, your mission will be to harness diverse datasets from sales, marketing, supply chain, and beyond, molding them into a cohesive narrative that propels Empower forward. 

  

Your canvas will be the vast expanse of data landscapes, where you'll employ your artistry to design and deploy transformative BI tools. These tools will not just report numbers; they will tell stories, uncover hidden opportunities, and chart new courses for success. As the steward of Empower's data integrity and insight, you will standardize and elevate our analytical discourse, making data not just accessible, but actionable. 

  

This position is more than a job; it's a voyage into the future of healthcare, where your work directly contributes to shaping a world where quality, affordable medication is within everyone's reach. Join us on this journey, and let's redefine what's possible together. 

Duties and Responsibilities:

• Develops and refine Power BI reports and dashboards, translating pharmaceutical data from diverse sources into visual narratives that inform and drive decision-making across sales, clinical trials, manufacturing, and supply chain operations.
• Crafts and maintains robust data structures and models, including tabular and multidimensional setups, to support comprehensive BI reporting and insights generation.
• Designs and implements business analysis systems and data recording frameworks to streamline reporting processes, ensuring a consistent and efficient approach to data handling.
• Conducts thorough evaluations of existing BI reports, identifying and addressing any issues to enhance accuracy and reliability.
• Collaborates with business stakeholders to deeply understand their data needs, translating these into effective and tailored Power BI solutions.
• Spearheads the integration of BI systems with other enterprise platforms, enhancing data connectivity and workflow automation across departments.
• Champions the adoption of best practices in data visualization, navigation, and interactivity within Power BI, optimizing the end-user experience and the effectiveness of BI tools.
• Engages in proactive exploration of new technologies, analytics methodologies, and BI tools, leading pilot projects to assess their potential impact and integration into Empower's BI ecosystem.
• Drives initiatives for data governance, ensuring the highest standards of data quality, consistency, and security are maintained across all BI platforms and processes.
• Delivers training and development programs to build data literacy and BI tool proficiency among both technical and non-technical team members, fostering a data-driven culture.
• Applies advanced analytics, predictive modeling, and machine learning to unearth deeper insights, support strategic decisions, and provide a competitive edge.
• Facilitates regular interaction with key stakeholders through forums and workshops to gather feedback, discuss challenges, and align BI solutions with evolving business needs.
• Continuously monitors and optimizes the performance and scalability of BI systems and tools, ensuring they remain aligned with business objectives and user requirements.
• Utilize storytelling and innovative data visualization techniques to convey complex data insights in an intuitive and engaging manner, aiding in decision-making and strategic planning.
• Leads cross-departmental efforts to integrate disparate data sources, creating a unified and comprehensive data landscape that supports holistic analysis and insight generation.
• Performs other duties as assigned.

 

To perform this job successfully, an individual must be able to perform each essential function satisfactorily. The requirements listed above represent the knowledge, skill, and ability required. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform essential functions. 

 

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 work day and frequently use their hands and fingers to handle or feel  in order 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 toattend 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.  

Knowledge and Skills:

• Familiar with data modeling best practices.
• Strong SQL and Excel skills.
• Proven track record of delivering high-quality BI solutions that drive business value and support strategic initiatives.
• 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 other accountable to meet commitment. 
• 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.  

Experience and Qualifications:

• Bachelor’s degree from an accredited college or University.
• 3-5 years of related hands-on experience with PowerBI.
• Extensive proficiency and expertise with Power BI DAX Queries, and associated supportive tooling (DAX Studio, DBeaver, etc.) required.
• High level of experience working with organizing raw, unvetted data, relational databases, presenting time series analysis, and identifying data quality issues.
• Experience in a role in a business analyst role within the manufacturing, life sciences, healthcare industries preferred.
• Experience with ETL or data transformation tools like DBT, Apache Hop, is a plus.
• Previous experience with Python and JavaScript is strongly preferred.
• PowerBI Certified preferred.

Benefits:

• No-Cost Medication: Get your prescribed compounded medications at no cost, ensuring your health without the financial burden.
• Onsite Health & Wellness – IV Therapy Drips: Rejuvenate with complimentary onsite IV Therapy drips, enhancing your well-being and energy levels.
• Comprehensive Medical, Dental, and Vision Options: Choose from three medical plans tailored to your needs, plus options for dental and vision coverage for you and your family.
• Telehealth visits: Access board-certified Doctors anytime, anywhere for you and your family.
• Paid & Volunteer Time Off: Enjoy paid time off for personal pursuits and contribute to causes you care about with volunteer time off.
• Paid Holidays (8 scheduled; 2 floating): Celebrate with eight scheduled holidays and two floating holidays, giving you flexibility and time for personal traditions.
• Life & AD&D Coverage: Secure your and your family's financial future with life and accidental death and dismemberment (AD&D) insurance.
• FSA (Flexible Spending Account): Manage healthcare expenses smartly with pre-tax dollars in a Flexible Spending Account (FSA).
• 401K Dollar-for-Dollar Up to 4%: Invest in your future with our 401K plan, featuring a dollar-for-dollar match up to 4%.
• Company Paid Long-Term Disability: Provided at no cost, which replaces 60% of your income if you become disabled for a long period of time.
• Flexible Schedules: Balance work and life seamlessly with our flexible scheduling options.
• Rewards & Recognition Program: Your hard work doesn't go unnoticed – enjoy rewards and recognition beyond your paycheck.

 

Additional Voluntary Benefits

• Accident Insurance: Pays a lump sum benefit to help cover expenses following an accidental injury.
• Hospital Indemnity Insurance: Enhance your peace of mind with supplemental hospital insurance for unexpected stays.
• Critical Illness: Protect your finances from the expenses of a serious health issue.
• Short-Term Disability: Protect your income during illness or injury with short-term disability coverage.
• Supplemental Life & AD&D: Add an extra layer of financial protection for you and your loved ones with supplemental life and AD&D coverage.
• Legal Services: Access professional legal assistance to address concerns confidently.
• Identity Theft Protection: Safeguard your identity and finances with our identity theft protection benefit.
• Pet Insurance: Care for your furry family members with our pet insurance coverage.
• Employee Assistance Program: Confidential counseling and support services for a holistic approach to your well-being.