Pharmacy Data Analyst II

Accountabilities:: Develop and execute complex data requests, SQL queries, reports, and visualizations to support business and operational objectives. Analyze large datasets from multiple sources, identify meaningful patterns, and translate findings into actionable business insights. Prepare comprehensive written reports and deliver presentations to senior management, summarizing analytical results, conclusions, and strategic recommendations. Design and implement key performance indicators (KPIs) to monitor data trends, identify potential issues proactively, and evaluate the effectiveness of programs and business solutions. Collaborate with multiple departments and stakeholders on cross-functional analytical projects and reporting initiatives. Utilize internal systems, business partner portals, and reporting tools to extract, manage, and interpret relevant data. Support the development and implementation of analytical methodologies, reporting processes, and data-driven solutions. Assist in training and mentoring junior Data Analysts, sharing technical knowledge and promoting analytical best practices. Develop and maintain supporting documentation for queries, reports, and analytical processes to ensure consistency and transparency. Apply critical thinking and problem-solving techniques to investigate data discrepancies and address complex analytical requests. Manage multiple assignments simultaneously while maintaining accuracy, efficiency, and adherence to deadlines. Perform additional analytical and reporting responsibilities as required by business needs. Requirements: Bachelor's degree in a related discipline or equivalent relevant professional experience is required. A bachelor's degree in Finance, Economics, Analytics, Mathematics, Statistics, or a related field is preferred. At least 4 years of professional experience in pharmacy or medical data analysis is required. Minimum of 1 year of advanced proficiency in SQL and/or SAS is required. Demonstrated experience extracting, querying, and analyzing information from data warehouses. Previous experience in managed care pharmacy, health plans, or managed care environments is strongly preferred. Familiarity with predictive modeling techniques and applications is an advantage. Strong analytical skills, with exceptional attention to detail and the ability to critically evaluate data and business requests. Ability to synthesize large volumes of information from multiple sources and communicate complex findings clearly. Excellent written, verbal, and presentation skills, including the ability to communicate analytical insights to both technical and non-technical audiences. Advanced Microsoft Excel proficiency, including the ability to create pivot tables, charts, graphs, and presentation-ready visualizations. Proficiency in Microsoft Word and PowerPoint for preparing professional reports and presentations. Familiarity with data visualization platforms such as Tableau, Power BI, or similar analytical software is preferred. Working knowledge of descriptive statistics and statistical analysis techniques is an advantage. Familiarity with Medicare Stars and HEDIS quality metrics is preferred. Strong organizational and time management skills, with the ability to manage multiple priorities accurately and efficiently under tight deadlines. Ability to work independently in a fast-paced healthcare environment while proactively communicating potential risks, challenges, and project updates to management. Creative and systemic thinking, strong problem-solving abilities, and a genuine curiosity for innovation and continuous improvement. Demonstrated ability to collaborate effectively, build professional relationships, influence stakeholders, and contribute to team development. Benefits: Competitive annual base salary ranging from $72,200 to $115,500, depending on qualifications, experience, and role-related factors. Eligibility for additional performance-based bonuses tied to individual and organizational results. Comprehensive employee benefits and total rewards package. Full-time remote working arrangement. Opportunities to contribute to meaningful healthcare and pharmacy data initiatives. Collaborative and inclusive working environment that values diverse perspectives and professional contributions. Opportunities for professional development, continuous learning, and technical skill enhancement. Exposure to advanced analytics, predictive modeling, and healthcare data visualization tools. Opportunities to develop leadership skills through mentoring and supporting junior analysts. Work environment that encourages innovation, creative problem-solving, and continuous improvement. Organizational commitment to employee well-being, inclusion, and professional growth.