Reporting Consultant

ABOUT PEARL WEST   This is an opportunity to join our rapidly growing team in Downtown Vancouver, British Columbia. Here at Pearl West, we are a rapidly growing business within the e-commerce industry focusing on buying, selling, and launching brands.  Over the last few years, we have grown at an average rate of 30% each year. This newly-created position will be an integral part of our team as we embark on the next phase of our growth.  Established in 2018, Pearl West is quickly becoming a leader in offering the industry. Our creative marketing campaigns have quickly earned us brand recognition, and a reputation for being a breath of fresh air in our industry.  We believe that business needs to be innovative and creative in order to thrive, and we think it’s important to provide an exciting and vibrant place to work. Culture is the driving force to our success and feeds into every aspect of what we do.  But we admit we’re not for everyone. We’re successful because we have high standards, work hard, and hire smart people with strong critical thinking skills – people who are honest and confident enough to say “I don’t know – BUT I’ll find out!” People whose burning questions during interviews include “How many sick and vacation days do I get?” need not apply.  Your time here will be fast and furious and quite the ride.  But the rewards are plentiful.    Overview :   We are seeking an experienced Reporting Consultant to join our team on a contract basis, with the possibility of evolving into a part-time or full-time role. To create cohesive reports and dashboards, the ideal candidate will be skilled in extracting, merging, and centralizing live data via API connections from Amazon, Shopify, Notion, TikTok, and Meta. With expertise in PPC reporting (specifically for Amazon and Google), this person will work closely with our team to build and maintain a centralized reporting system using Power BI, Google Sheets, or other preferred tools.   Key Responsibilities :

• Extract and unify data from multiple platforms (Amazon Seller Central, Amazon Ads, Shopify, Notion, TikTok, Meta) to create centralized, cohesive reports.
• Develop live, custom reporting dashboards using Power BI, Google Sheets, or other selected tools, enabling cross-platform insights and data-driven decisions.
• Collaborate with relevant teams to ensure reporting aligns with business objectives and supports key metrics.
• Manage PPC reporting for Amazon and Google, providing insights into ad performance and suggesting actionable improvements.
• Ensure data accuracy and regular updates, troubleshooting API connections, data discrepancies as needed.
• Document and standardize reporting processes, optimizing for efficiency and reliability in data extraction and report generation.
• Actively seek feedback from stakeholders to improve reporting effectiveness continuously.   Requirements :
• Proven experience in creating reports and dashboards using Power BI or similar tool, with proficiency in extracting and merging data from multiple sources.
• Strong understanding of PPC reporting specifically for Amazon and Google platforms.
• Experience working with e-commerce metrics and familiarity with platforms like Amazon, Shopify, and Meta.
• Excellent analytical skills, with the ability to transform raw data into meaningful insights.
• Ability to work in EST or PST time zones, ensuring timely collaboration and availability.
• Strong communication skills, interpreting and communicating data insights to technical and non-technical stakeholders.
• Attention to detail and high standards of work with the ability to maintain data integrity and reliability.   Preferred Qualifications :
• Experience in data automation and data warehousing practices.
• Familiarity with advanced data visualization techniques.
• Proactive, bias-for-action attitude, with a demonstrated ability to initiate improvements in reporting processes.
• Growth mindset, with an eagerness to continually refine and expand skills. Compensation :
• Contract-based hourly rate (to be determined based on experience).
• Flexible hours with the potential for part-time or full-time engagement based on performance and business needs.   To improve your chances of being contacted, please attach a link to a PowerBI dashboard you have previously built (with sensitive data redacted).     Powered by JazzHR