The Hired Guns are seeking a Programmatic Analyst, Financial Planning and Analysis for a major publishing data hub’s programmatic ad sales. If you’re doing Financial Planning and Analysis modeling inside a big media or ad tech company, come take your programmatic game to the top.
The Nitty Gritty
The backstory on the organization and why they need to hire you!
Client finance practices at this media conglomerate are idiosyncratic, and they need an FP&A analyst who can standardize the whole lot for programmatic ad sales. You’ll oversee both the collection and management of the data, as well as the administration of client transactions. Plying your ever-expanding technical chops in SQL, Python, and as much Tableau as you can handle, you’ll become omniscient in financial operations using data science techniques.
Day to day, you’ll be advising on budgets, goal-pacing, and operating models — primarily for the programmatic business and traffic, but you may be called to help out other sectors, too. Wherever you’re working, you’ll be growing; your boss is beloved for turning can-do learners into done-that achievers.
The Quest
What success looks like in your first year…
- You’ll take the helm of existing data analysis driving FP&A for ad sales/ programmatic revenue…
- …by using SQL, Tableau, and Looker to create more sophisticated predictive modeling techniques and data visualizations to provide better revenue projections…
- …thereby increasing the accuracy of forecasting across a broader range of KPIs.
Why You?
How you’ll know if you’re a fit…
You already have the financial capabilities to manage spend, budget, and billing — plus the FP&A expertise to serve as a subject matter expert. You take pleasure in formulating complex queries for client insights, and satisfaction in deriving sophisticated predictions from them. Your in-depth knowledge of programmatic advertising at a media outlet has you murmuring excitedly how perfect this job is for you.
You’re always elbow-deep in SQL algorithms and Python, building forecast models and doing CBAs. You’ve got at least enough experience in Tableau to put it on your resume, and you want to learn more.
Tell Me About a Time When …
The interview questions you need to rock to score a “swipe right”…
- What technologies are you currently using in your job?
- Do you have experience writing complex queries?
- What is your methodology in creating forecasts?
- Tell me about a time you learned a new technology? Are you using it today?
The Inside Skinny
Why you should quit your job right now and join this organization!
If your goal is to be successful, but you know you can go a lot further, this place will evolve you into an FP&A unicorn. Instead of just building models in Excel, you’ll learn to build models that are reproducible and automated. If you already know the key tools and techniques, you could move up quickly at this top-name outfit.
The Hired Guns does not and will not discriminate in considering and referring candidates for employment, or in its treatment or advancement of its employees, and will not tolerate harassment, on the basis of race, color, religion, gender (including gender identity and expression), sexual orientation, national origin, age, disability, or any other status protected by applicable federal, state or local law.
