General Description 

Equiscript is seeking a meticulous, motivated, and analytical Program Analyst to join us on our Program Analytics Team. Responsible for collecting, analyzing, and summarizing all client data and trends. As a Program Operations Analyst, you will be responsible for optimizing organizational processes, identifying opportunities for efficiency improvements, and providing insights through data analysis. The ideal candidate should possess strong analytical skills, attention to detail, and a passion for driving operational excellence.

Key Responsibilities 

• Collect, analyze, and summarize Client data and trends. Forecast and track key account metrics. 

• Develop monitoring tool for new client performance – separate from existing clients 

• Responsible for driving processes and improvement initiatives by gathering and documenting business requirements.

• Performs and participates in the analysis, design and implementation of business and systems processes and procedures following appropriate standards.

• Monitor all day-to-day OPS IT functions to ensure inbound and outbound file processing works effectively. 

• Assist the AE in reviewing volume and providing expertise in driving revenue and volume for the client 

• Continuously assess business and operation needs 

• Document business requirements and training materials 

• Ensure the business needs of customers are identified and addressed. 

• This position plays an essential role in presenting operational solutions and recommendations to internal teams for decision-making purposes.

• Identify claim/impact related to Drug Manufacturer exclusions - impact analysis – identify opportunity for designations 

• Ensure a successful process -Submit to ESP daily/weekly 

• Oversee / Drive and conduct all client deployment activities, ensuring delivery on time and as designed 

• QA and Go Live Processes 

• Testing pre and post-go-live activities 

• Client Services 2nd and 3rd level support issues 

• QA Functions 

• Functional client performance issues - research and issue resolution 

• Program Configuration Expert, supporting Account Management and Implementation in identifying and implementing client-specific business needs 

• Coordinate any system changes needed to support the client – everything from Admin Tool updates, eligibility rule changes, crosswalk changes, the addition of new sites/pharmacies, etc. 

• Address all Program related questions including: 

• 340B Compliance, regulations, processes, training, and product 

• Is responsible for extracting data from multiple sources, manipulating, and validating data, and presenting analytic findings.

• Will organize and analyze data to review past trends and current conditions 

• Troubleshoot, investigate and execute complex data-related tasks (manipulation of data, mathematical calculations, reports design) 

• Synthesize data and feedback from users, clients, and management 

• Leverage quantitative skills to derive answers to clients' ongoing business analytics and reporting questions 

• Prep incoming data for higher-level analysis 

• Communicate the data results to the client, with an emphasis on answering the business question as opposed to the analytical and reporting processes used 

• Other duties as assigned 

Professional Qualities 

• Knowledge of current computing technologies and software applications such as 

• Specialized Business Intelligence software 

• SQL query language (MS SQL) 

• Perform ad hoc analysis using SQL to extract data 

• Skilled in using Microsoft tools 

• Comfortable working with large raw data files 

• csv, txt, etc. 

• Ability to edit, manipulate, and search data sets required 

• Ability to create meaningful visualizations from complex data 

• Be self-driven and show the ability to deliver on ambiguous projects with incomplete or dirty data 

• Strong organizational and analytical skills 

• Ability to collaborate with a team and possess the ability to thrive in a fast-paced, deadline-driven environment 

• Demonstrate a deep understanding of source data from various internal/external systems 

• Think strategically and analytically about business and technical challenges, with the ability to work cross-functionally 

• Demonstrate continuous effort to improve operations, streamline work processes, and work cooperatively and jointly to provide quality, seamless customer service 

• Work in an ambiguous environment, drawing out and developing business requirements to meet changing needs 

• Make data-driven decisions and recommendations 

Preferred Experience 

• Bachelor’s degree in Computer Science, Business, Finance, Economics or related field. 

• Proven experience as a Data Analyst with ETL focus. 

• Proficient in ETL tools, SQL, and scripting languages. 

• Excellent analytical and problem-solving skills. 

• Experience in 340B is strongly preferred. 

• Effective communication and collaboration skills. 

Physical Requirements 

• Requires the ability to sit or stand for long periods of time, occasional stooping, and reaching; May require lifting up to 25 pounds; requires normal range of vision and hearing with or without accommodations. 

Additional Information 

• Clear Background Check Required. 

Employment Information 

• Position is Remote 

• Benefits include health plan, dental, vision, and paid time off. 

• Flex time. 

• 401k with up to a 4% company match.