What you’ll do
In a few words…
This may be an underwriter role, but there’s nothing “under” about it—well, except for the need to understand loads of data that, without your help, no one else would dare undertake… and data would then overtake and overstress us. Perhaps another “under” would be the suggestion to try and behave in an understated fashion when it comes to your brilliant underwriting talents. Nobody enjoys an overbearing pedantic genius. So you see, there’s going to be a lot of over and undercurrents occurring, but in your role as underwriter you’ll be above and beyond.
We want you to support our underwriting efforts. We want you (and only you) because of your outstanding analytical skills and experience with analytic tools. We know enjoy working proactively and as quickly as possible, lickety split, and that’s perfect since there is often a fixed timeline to submit pricing proposals to prospective clients. You are data-curious and can critically asses a dataset to identify potential issues, so you’ll have no issues hitting the ground running. You love learning, are enthusiastic about understanding the key drivers of profitability in the PBM business, and we can’t wait to meet you!
The fundamentals for the job…
You will have a blast analyzing potential client guarantees and Abarca’s margin for prospective clients. We try not to marginalize.
You will prepare pricing proposals for prospective and existing Abarca clients, and present them to the underwriting lead (the under-lead).
Another thing we really really need is for you to develop performance-guarantee dashboards and monitors.
You’ll definitely find your work cut out for you when you collaborate cross-functionally to stay highly aware of pharmacy network contracting and generic pricing strategy to ensure it aligns with the underwriting strategy.
You will shine when modeling rebate and network performance for prospective clients.
You will use SQL to complete the claims repricing process. It’s not as dull as it sounds.
And another thing: you’ll build SQL models to automate rebate estimation process. We estimate you’ll find that loving your job is not just another process but a total success.
What you’re made of
The bold requirements…
Bachelor’s degree in an analytic field (e.g. engineering, economics, math, statistics) OR bachelor’s degree + 2 years of professional analytic experience. (In lieu of a degree, equivalent relevant experience may be considered.)
You are an undisputed Master of Microsoft Excel- you don’t need to tell us: we know you have used Excel to create complex analytic models. Don’t be shy.
Yeah, we expect you to bring strong SQL abilities. Tableau and Qlikview experience would also be nice.
You’ll pass an analytic assessment test. We’re not saying you “must”: we know you’ll pass.
Do we even need to mention you’re fierce when it comes to critical thinking? You simply need to seek out problems in data, propose potential solutions, and so on and so forth. Data nerd and proud.
You are, indubitably, a self-starter. You were probably born 2 months early weighing 8 pounds and asking to see your chart.
If you have previous underwriting experience, guess what? That would be a big fat plus.
Healthcare/PBM experience would also add some cool glittery confetti.
So you’re experienced presenting to senior leadership? Be still our beating hearts!
Process improvement experience? Hold on, you must want us to fall in love.
It goes without saying you are computer proficient, with knowledge of Microsoft Office products, and have plenty of Internet experience. (The daily digital basics.)
You are able to communicate effectively (read, speak, write, exchange pleasantries, small talk and beyond) in English and Spanish.
That something extra we´d love to see…
1. Analytical: You have to be. It’s in your job title! You value the power of context & enjoy examining the past. You get the present by over-analyzing events leading up to it. Also, as explained by someone, somewhere, analysis comes from the root word “anal” and the greek word “ysis”, meaning "to pull facts and numbers from."
2. Curious: You are the “wanna-know” type, characterized by ever-inquiring intellectual activity. Your inquisitiveness is bottomless and packed with all manner of (usually) empirical knowledge. You boldly go where you don’t recall you’ve gone before. Invaluable to your less-imaginative counterparts as inspiration and entertainment.
3. Driven: You bring an extremely competitive nature and can manage multiple priorities without missing deadlines. You measure yourself against everything, everyone, animal, vegetable, mineral and beyond. You strive to win first place in everything. Nevertheless, your type of obsessive mindset, if properly harnessed, is a goldmine.
4. Logical: You are relentless in the search for reasons, causes and effects. Unencumbered by excessive sentimentality, you are able to think about all the factors that might affect a situation, which would be a great trait if you were a politician. However, as a logistician you enjoy your intellect for your own purposes and don’t care for questionable games.
5. Master cross-collaborator: You are able to work across multiple departments, businesses and personnel. You can also apparently be in two places at once.
The above description is not intended to limit the scope of the job or to exclude other duties not mentioned. It is absolutely not a final set of specifications for the position. It’s simply meant to give readers an idea of what the role entails.