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

JD Sports - Sales Assistant Full Time
JD Sports Leeds, England Today

Ensure that customers receive the best possible service every time that they enter a JD store. You will assist in maximising store profitability by exceeding

Customer Assistant
Lidl London, England 11.95 - 13 GBP HOURLY Today

Our Customer Assistants work together as a team to ensure their store is clean, tidy and well-stocked so that customers can get the products they love and need.

cashier and checker
Pollo Campero Santa Ana, CA 33834 - 28694 USD ANNUAL Today

Job Description:


  • Responsible for welcoming new and repeat guests every visit
  • Be knowledgeable of all menu...

Home Care Worker
Complete Community Home Care Ltd Ashington, South East England, England 11 GBP HOURLY Today

*To be considered for this role you must have a full UK driving licence and your own car.*. As a *Home Support Assistant*, you will provide crucial care and

Team Member
Tim Hortons Cookstown, Northern Ireland 18559 - 20663 GBP ANNUAL Today

Team Member Front of House Location: Salary: Hourly paid, minimum wage & above Job Type: Full-time & Part Time available Want to change up your career