Excel Vba Developer Jobs in Indiana (NOW HIRING)

The Business Analyst, Pricing and Underwriting, is responsible for the compilation, analysis, and reporting of data to support pricing contracts for Specialty services within a Pharmacy Benefit Manager (PBM) setting. Partner cross-functionally with Underwriting, Finance, Clinical, and Account Management teams to develop custom reports, assess the impact of client-driven changes, and perform data-driven analyses. Utilize SQL, Excel, and data visualization tools to maintain and monitor Specialty pricing models, support financial forecasting, and contribute to strategic economic modeling. Design and generate reports to inform daily operations and executive decision-making. Collaborate within the Pricing & Underwriting department to develop queries across multiple systems, offering robust analytical support to key business units.

Position Location:

This is a remote-based position within the Continental US.

Our Company Founded in 1926, Maxor is a leading, independent pharmacy solutions platform that improves prescription drug affordability and outcomes. Over time, Maxor has built a unique and complementary suite of clinically integrated services and technology offerings that deliver clinical, financial and strategic value to patients, payors and providers across the pharmacy supply chain. Maxor has a proud heritage of growth and innovation earned over the decades. Amarillo, Texas is the legacy headquarters for Maxor, but our talent base is national. We operate pharmacies and other business operation sites across the United States with employees working from 44 states.

Why Join Maxor?

At Maxor, we recognize that our employees are our most valuable assets. We actively seek and retain talented professionals who are mission-driven to improve healthcare outcomes for patients. Likewise, our employees are essential to their own well-being, finding fulfillment in meaningful work, competitive compensation, diverse and inclusive teams, and limitless career possibilities. With a growing workforce of 1,500+ and almost a century of pharmacy experience, we offer the stability of a Fortune 500 company and the energy and innovation of a startup. Our expertise and technology support the entire pharmacy ecosystem, but our impact goes beyond pharmacy services. We enable pharmacy care.

• Create and maintain custom data-mining queries to produce actionable insights for pricing and business strategy.
• Analyze pharmacy claims, drug pricing, rebate models, and utilization trends for internal teams and client reporting.
• Interpret complex pharmacy benefit structures and clearly communicate findings to varied audiences.
• Provide forecasting, reporting, and analytical support to senior management for strategic planning.
• Automate and streamline reporting to increase efficiency and reduce manual processes within PBM pricing operations.
• Contribute to Specialty Pricing operations by:
  • Managing pricing appeals, coordinating with Maxor Specialty, and compiling data for automated processing.
  • Executing weekly pricing tasks to ensure accuracy and implementation consistency.
  • Gathering and preparing input data from pricing resources to support core processes.
  • Documenting procedures to meet audit and compliance requirements.
• Execute dynamic pricing strategies in response to market changes to ensure competitive positioning and profitability.
• Collaborate with Pricing, Underwriting, Sales, and Account Management teams to evaluate and support new/existing client opportunities.
• Enhance financial models and streamline operational processes for greater accuracy and efficiency.
• Create and distribute ad hoc reports and financial models tailored to business needs.
• Develop tools for performance monitoring and key metric tracking across business units.
• Maintain current knowledge of financial tools, market conditions, and PBM industry trends.
• Author and manage Standard Operating Procedures (SOPs) for custom and standardized tasks.
• Communicate complex analytical findings effectively across technical and non-technical audiences.
• Foster continuous improvement with a strong focus on operational excellence and process optimization.

Education:  Bachelor’s Degree in Finance, Business Analytics, Computer Information Systems, Data Science, or Economics. Or similarly related degree preferred.

Experience: Minimum of 2 years’ experience completing complex analytical, financial analysis for PBM services. Minimum of 1 year experience using SQL or other applicable programming language (Python/VBA/C++/etc).

Knowledge, Skills, and Abilities:

• Knowledge of pricing components and service mix, including plan design, prescription utilization, retail networks, rebates, Specialty/Mail pharmacy services, and brand/generic dynamics.
• Advanced Excel and Word expertise, with experience in building complex financial models and reports.
• Proficient in SQL, using SELECT, CASE, JOIN, and conditional logic to extract and analyze large datasets.
• Strong analytical skills to assess client-specific data within the broader context of business strategy, delivering actionable pricing recommendations.
• Experience working with complex, unstructured datasets to drive insights and decisions.
• Proven ability to manage multiple priorities, coordinate deliverables, and meet critical deadlines.
• Effective cross-functional collaborator in fast-paced environments involving Operations, Sales, Account Management, and Finance.
• Skilled communicator with experience presenting findings to senior leadership. Self-motivated project manager with excellent follow-through and organizational discipline.
• Detail-oriented with exceptional time management and process documentation skills.

WE OFFER

At Maxor, we foster a diverse and progressive culture that promotes a work-from-home model and a "dress-for-your-day" approach to work attire. Our team-oriented environment encourages collaboration and innovation.

We offer highly competitive compensation and comprehensive health benefits including:

• Comprehensive mental health and wellbeing resources
• Nationwide Blue Cross Blue Shield PPO with employee-friendly plan design, including a $850 individual annual medical deductible and $25 office visit copays, with low biweekly premiums
• Company-paid basic life/AD&D, short-term and long-term disability insurance
• Rx, dental, vision, other voluntary benefits, and FSA
• Employer-matched 401k Plan
• Industry-leading PTO plan
• And more!