Business Intelligence Coordinator
Remote in North America
We need you at Pilothouse!
We're a fast-growing performance marketing agency that manages tens of millions per month in direct-response ad spending for awesome direct-to-consumer brands.
We work with disruptive brands, and big budgets, and make crazy ideas come to life!
Our model is built upon the core values of Alignment and Transparency, which means that, unlike traditional agencies that win by charging huge retainers, Pilothouse wins by delivering huge results.
Alongside our team of 170+ members spanning Media Buyers, Copywriters, Content Managers, Landing Page Developers, Content Creators, Email & SMS Coordinators, CGC & Influencer Managers, we need a Business Intelligence Coordinator to facilitate the data network that keeps all our divisions informed and operational.
REQUIREMENTS:
- Accounting experience is an advantage
- Highly advanced skills with formulas for either Google Sheets or Excel.
- Highly detail-oriented and committed to getting everything correct.
- Proven ability to manage databases, reporting software, or any similar experience.
- Self-motivated and ambitious: We’ve grown quickly without any venture capital
Not required, but nice to have:
- Experience creating an aesthetically pleasing visual representation of data
- Experience with automation
THE DAY-TO-DAY:
- Build Google Sheet formulas that work with constantly updating data, and solve complex data integrations using Google Sheets formulas that can be connected to our existing database.
- Make monthly data entries for Staff Commissions, Content Costs, and other information that informs our profitability.
- Support the Division Heads in strategic planning for internal intelligence systems.
- Find and resolve bugs as they arise within the network.
- Adapt existing structures within the network as operating systems change.
ABOUT THE POSITION
Our Business Intelligence Coordinator position is a one-of-a-kind role at the center of everything. As new objectives emerge, the Business Intelligence team is responsible for building and automating the tools for processing new data. We’re looking for a creative problem solver with strong attention to detail and a mind for good operational strategy.
There’s always more to learn and you’ll get a chance to work with every team, guiding them with new systems that support their operations.
In this role, you’ll be given the keys to work directly with executives and managers to help drive company success. You’ll work primarily in a network of connected Google Sheets that automate various custom calculations to inform financial reporting and analysis throughout the company.
We are focused on building a team of hustlers who are passionate about the Direct-To-Consumer space and who are eager to learn and grow. We push each other to do awesome work and encourage team members to bring even the wildest ideas forward.
ABOUT PILOTHOUSE
We work with disruptive brands, big budgets, and make crazy ideas come to life!
Our model is built upon the core values of Alignment and Transparency, which means unlike traditional agencies that win by charging huge retainers, Pilothouse wins by delivering huge results.
We are focused on building a team of hustlers who are passionate about the Direct-To-Consumer space and who are eager to learn and grow. We push each other to do awesome work and encourage team members to bring even the wildest ideas forward.
Team culture is everything at Pilothouse. Along with foosball games and Friday night beers, we have regular check-ins to discuss industry trends and new opportunities. You'll work with a team that has decades of marketing experience and want to learn from you just as much as you will from them.
APPLICATION INSTRUCTIONS - friendly hint - don't miss this part ; )
Along with your resume, please submit a cover letter and a brief explanation of why you are interested in this position. Within your cover letter or resume, we ask that you rate your skill from 0 to 10 (0 being no experience at all to 10 being mastery) in the following areas:
- Google Sheets
- Looker Studio
- SQL Programming
- Xero
- Communication
- Problem-Solving
- Attention to Detail
- Time Management
Feel free to include an example of some of the awesome things you've done that make you stand out - the nerdier the better.
We appreciate your time and thank all applicants for their interest, but we will only be responding to shortlisted applicants.
BENEFITS
- Perks for our online team members:
- Fun virtual events - we host company events to focus on fun and growth
- Casual dress
- Flexible work schedule
- Perks for if you’re ever in town:
- Commuter friendly - we have bike storage inside our office
- Dog friendly
- Beer on tap - cold, local beer waiting for you
Job Types: Full-time, Permanent
Benefits:
- Additional leave
- Flexible schedule
- Work from home
Schedule:
- 8-hour shift
- Early shift
Job Type: Full-time
Work Location: Remote
