MedImpact, an independent, trend-focused pharmacy benefit manager (PBM), is the nation’s largest privately held PBM, serving health plans, self-funded employers and government entities. Our business model is unique. We focus on effectively managing client pharmacy benefits to promote Lower Cost and Better Care through One Source. Our model aligns us with our clients. We help promote prescribing of lower-net-cost, medically appropriate drugs with fulfillment at the most appropriate participating pharmacy providing competitive pricing, good value and high-quality service. Our number-one goal is client satisfaction by providing flexible solutions and member-centric products with a focus on lowest-net cost and quality outcomes.

The Business Intelligence (BI) Data Analyst III is responsible for developing an in-depth understanding of the underlying data and proper business uses to translate end-user data and information requirements into a format to aid various MedImpact organizations and teams in drawing insight from that data. This includes creating queries, visualizations, algorithms, and reports. Also, as a BI Data Analyst III, you will be required to lead operational meetings, make business decisions as a department SME and act as a backup for the team’s manager. By creating a more data-driven approach to business, you will enable your colleagues to make smarter, faster decisions enabling the business to grow and adapt to an ever-changing global environment.

What You Get To Do

• Defines methodology and analytic approach to ensure each assigned Salesforce case is completed as efficiently as possible
• Writes complex, highly-optimized queries across large volumes of data to create detailed and accurate outputs with understanding of statistics and Knowledge of PL/SQL and or SAS
• Writes and maintains detailed documentation of including specifications, expected outcomes, validation methodology/processes, test results, recommendations, version control, and configuration design
• Understands data standards and identifies data abnormalities
• I nstills data quality in all outputs that are delivered
• Takes personal ownership and accountability for pre-determined Service Level Agreements by following up and following through on all deliverables
• Recommends and implements improvements to existing processes and assists with adoption of new software tools
• Acts as a technical business liaison to explain complicated technical information to non-technical audiences (both internal and external) effectively
• Promptly responds to service failures, resolves issues, and escalates concerns as appropriate
• Promotes continuous improvement by ensuring adherence to quality principles
• Seeks out and actively participates in business initiatives that contribute to service excellence
• Keeps current with industries best practices and seeks additional training/seminars to improve technical skills

Supervisory Responsibilities

This job has no direct supervisory responsibilities but will be required to perform as a team leader and act as a backup for the team’s manager.

For consideration candidates will need:

• Bachelor’s degree or higher in engineering, IT, economics, math, statistics, science, or other related fields in quantitative or analytical discipline (or equivalent combination of education and experience)
• Eight (8+) years relevant hands-on experience in an analytics, business intelligence or comparable data engineering role, including data warehousing, and business intelligence tools, techniques, and technology
• Experience with pharmacy claims data, insurance data, managed health care industry or PBM operations preferred
• Experience as a project manager, team leader or supervisor

Computer Skills

• Working Knowledge of standard business Applications, Microsoft Office Suite (MS Access, MS Visio, MS Project, MS Word, and MS PowerPoint), Golden 32 or TOAD and Salesforce
• Advanced proficiency with Excel (Pivot tables, pivot charts, conditional formatting, VLOOKUP, formulas); VBA macro experience a plus
• Strong knowledge of PL/SQL (complex joins, nested subqueries, aggregation, partitions, functions, pivots, and unions)
• Solid understanding of databases, their architectures and database constraints
• Working knowledge of COGNOS is a plus

Certificates, Licenses, Registrations

• MYSQL Certification or demonstrated knowledge
• Oracle Certified Professional is a plus
• SAS Certified Base Programmer a plus

Other Skills And Abilities

• Executes and delivers within the confines and timeframes provided by regulatory agencies
• Strong knowledge of the US healthcare system and healthcare claims data
• Ability to work beyond standard business hours as required by deadlines and deliverables
• Ability to prioritize urgent issues effectively
• Proven team player, delivery-focused, yet flexible and creative when called upon
• Ability to communicate positively, tactfully, and effectively with multiple stakeholders including team members, management, and customers
• Well-developed facilitation and collaboration skills
• Experience and understanding of how to accomplish deliverables in a matrixed environment
• Ability to effectively delegate tasks to junior team members
• Ability to mentor and train team members

Travel
This position may require domestic travel up to 15%; attendance may be required at various local conferences and meetings