bi analyst

bi analyst Remote

Pilothouse
Full Time Remote 10.56 - 12.04 CAD Today
Job description

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

About Pilothouse

Revenue: Unknown / Non-Applicable
Size: 51 to 200 Employees
Type: Company - Private
Website: www.pilothouse.co
Year Founded: 2019

bi analyst
Pilothouse

www.pilothouse.co
Victoria, Canada
Unknown / Non-Applicable
51 to 200 Employees
Company - Private
Advertising & Public Relations
2019
Related Jobs

All Related Listed jobs

Food and Drink Runner - Westminster
Step Ahead London, England 12 - 14 GBP HOURLY Today

Ensure high standard service, cleanness, smiley and proactive attitude with customers and colleagues. Introduce a friend bonus scheme from 200 to 400 each

digital marketing
Anne Corder Recruitment Peterborough, England 40000 - GBP ANNUAL Today

Newly created role for global market leader based in Peterborough as Brand Marketing...

Accommodation Cleaner
Hendra Holiday Park Newquay, England 12 GBP HOURLY Today

You will have a flexible attitude and approach to your work. 50% off food and hot drinks. Make beds in all caravans and lodges.

People (HR) Manager
Morrisons Strood, England 34713 - 43944 GBP ANNUAL Today

Our People Managers are operational business partners, real experts in their field - ensuring successful alignment of the people and operational store plan(s)

Retail Security Officers
Dockside Personnel London Today

London Industrial 13 per hour We are currently seeking Security Officers to join our dedicated and hard-working team, located in various sites across London. We are looking for presentable,...